Why do we have intermittent issues with scheduled instances of the Load Data Warehouse job failing?

Document ID : KB000036882
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

When we run the Load Data Warehouse job in immediate mode, it is successful; why does it fail occasionally when it is run as a scheduled job?

Answer: 

The Investment Allocation job and Time Slice job should be set as incompatible with the Load Data Warehouse job.

To set these jobs as incompatible:

  1. Go to Administration, Data Administration, Reports and Jobs
  2. Click the link for the Load Data Warehouse job
  3. Click the Incompatible Jobs tab
  4. Click "Add" button and place checkmarks in the check boxes for "Investment Allocation" and "Time Slicing"

If the jobs are already set as incompatible, please contact PPM Support and provide a copy of the bg-dwh.log file for further investigation. 

Additional Information: 

Reference TEC603467 : Incompatible jobs for Time Slicing job

Reference TEC528729 : Configuring and Scheduling some of the main jobs