/
Processing AR Cube Stuck In Status Running

Processing AR Cube Stuck In Status Running

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 

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

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)





Related content

Cubes jobs failed due to the Object ID Property was not found
Cubes jobs failed due to the Object ID Property was not found
More like this
Master Article - Nightly Cubes Job Failing at Step 1
Master Article - Nightly Cubes Job Failing at Step 1
More like this
SQL Server Analysis Services Memory Usage High
SQL Server Analysis Services Memory Usage High
More like this
Cubes step 1 failure - Incorrect GAS URL
Cubes step 1 failure - Incorrect GAS URL
More like this
Nightly Cubes Job Failing at Step 1 - SQL Analysis Collation mismatch
Nightly Cubes Job Failing at Step 1 - SQL Analysis Collation mismatch
More like this
The SQL Server Analysis Service Started and Then Stopped
The SQL Server Analysis Service Started and Then Stopped
More like this