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?
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:
- Go to Administration, Data Administration, Reports and Jobs
- Click the link for the Load Data Warehouse job
- Click the Incompatible Jobs tab
- 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.
Reference TEC603467 : Incompatible jobs for Time Slicing job
Reference TEC528729 : Configuring and Scheduling some of the main jobs