[SQLServer] Entity has not been setup in Data Warehouse Setting

book

Article ID: 4607

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

You run the Job "Load Data Warehouse"  and this jobs fails and if you look under the log file bg-dwh.log, you will find this error message:

"[CA Clarity][SQLServer JDBC Driver][SQLServer]Entity has not been setup in Data Warehouse Settings"

 

Cause

The Cause of this error unde CA PPM is that you need to configure correctly in order to successfully run the Job "Load Data Warehouse".

Environment

Release: ESPCLA99000-14.2-Clarity-Extended Support Plus
Component:

Resolution

What is  needed to run this correctly is to set the Language and Fiscal Periods in order to populate Data Warehouse.

Follow the next steps:

  1. Under administration, General Settings and click on "System Options"
  2. Under the options "Data Warehouse" section, the next fields: 
    • Languages [English (must be set) and you can add an additional (Spanish) 
    • Entity for Fiscal Periods (must enter the Fiscal Period)

 

To get to populate the Data Warehouse with the CA PPM Data. You need to run the following jobs, you will have to follow this order:

Run the next Jobs;

  1. Time Slicing
  2. Load Data Warehouse (Full Load)
  3. Load Data Warehouse Access Rights