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

« Previous Version 2 Current »

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)





  • 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.