Load Data Warehouse Failing after Upgrade Due to All DWH Period Options being Unchecked

Document ID : KB000121518
Last Modified Date : 26/11/2018
Show Technical Document Details
Issue:
After an upgrade, if all of the Data Warehouse Options are unchecked, the Load Data Warehouse job for both the full and incremental loads will fail with the following error in the bg-dwh logs: 

2018/11/23 23:00:24 - Abort job - ERROR (version 5.0.2, build 1 from 2013-12-04_15-52-25 by buildguy) : At least 1 checkbox for 'Include Period Data' must be checked under System Options for the Data Warehouse.
 
Resolution:
At least one period data (Weekly, Monthly, Fiscal) option will need to be checked under Administration - General Settings - System Options. 
  • Include Weekly Period Data
    Specifies if you want to look at the data by week. When selected, facts are loaded in weekly increments.

  • Include Monthly Period Data
    Specifies if you want to look at the data by months. When selected, facts are loaded in monthly increments.
  • Include Fiscal Period Data
    Specifies if you want to look at the data by fiscal time periods. When selected, facts are loaded in fiscal time periods. The fiscal time period is determined by the value set in the Entity for Fiscal Periods field.

Once one or more period data options are selected, run a Full Load instance of the Load Data Warehouse job.