Description of Issue
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
Context
- AR Cube
- Accounts Receivable
- General Billing
Cause
SQL server Analysis Services memory usage is high
Resolution
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)
Additional Information
Add Comment