search cancel

ORA-20000: Entity has not been setup in Data Warehouse Settings

book

Article ID: 41786

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When I execute the "Load Data Warehouse" job, the job fails and in the bg-dwh.log, I see an error message:

"ORA-20000: Entity has not been setup in Data Warehouse Settings"

Environment

Release: All Supported
Component: Clarity Data Warehouse 

Cause

Clarity is not yet configured correctly to successfully execute the "Load Data Warehouse" job.

Resolution

Set the Language and Fiscal Periods for the Data Warehouse and populate it.

Follow these steps: 

  1. Open Administration and from General Settings, click System Options.
  2. In the Data Warehouse Options section, complete the following fields:
    1. Languages
    2. Entity for Fiscal Periods
  3. Populate the Data Warehouse with Clarity Data. Run the following jobs in this order:
    1. Time Slicing
    2. Load Data Warehouse (Important! If you are running the job for the first time to populate the Data Warehouse, select the Full Load configuration in the job parameters)
    3. Load Data Warehouse Access Rights