Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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:

  1. Open SQL Server Management Studio, set Server type to Database Engine and select the Server name
  2. Choose Authentication method and enter required credentials, if applicable
  3. Click Connect
  4. In the Object Explorer side panel, expand SQL Server Agent > Jobs
  5. Right+click on the relevant environment and select Stop Job
  6. In the pop-out window, follow the prompts to stop the cubes job from running
  7. 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)





  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.