Processing AR Cube Stuck In Status Running
- Knowledge Assistant
When processing the AR cube, the job hasn't Succeeded or Failed. The job status is Running and does not complete.
When viewing Integration Services package executions report, there are instances of OnWarning messagesÂ
Warning: The external columns for OLE_SRC XXXXXX data are out of synchronization with the data source column. The external column XXXXX needs to be updated.
Warning: Truncation may occur due to retrieving data from database column XXXXX with a length of XXX to data flow column XXXXX with a length of XX.
Load ARActivityFact Warning: The package contains data flow components with multiple inputs. Runtime dependencies that exist among these components may increase memory usage and reduce performance. Consider removing the dependency chain for the following component IDs and output IDs
- AR Cube
- Accounts Receivable
- General Billing
SQL server Analysis Services memory usage is high
To stop the current job from running:
- Open SQL Server Management Studio, set Server type to Database Engine and select the Server name
- Choose Authentication method and enter required credentials, if applicable
- Click Connect
- In the Object Explorer side panel, expand SQL Server Agent > Jobs
- Right+click on the relevant environment and select Stop Job
- In the pop-out window, follow the prompts to stop the cubes job from running
- Generate An Error Report For Failed Cubes Job
Once verifying the OnWarning messages in the error report, contact Enterprise ERP TSM Saas (for hosted sites) or Enterprise ERP TSM OnPrem for (self-hosted sites)