search cancel

Update Report Tables Job Fails if Entity is not set in PPM


Article ID: 32829


Updated On:


Clarity PPM SaaS Clarity PPM On Premise



Update Report Tables job (Formerly known as 'Update Business Objects Report Tables' job) fails if Entity is not set in PPM. If this setting is missing, below is an excerpt of the error message you will see in the bg-ca.log regarding the Update Report Tables job failure:


Error executing job: com.niku.union.persistence.PersistenceException: 

SQL error code: 50000 

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




To add an Entity: 

1. In PPM, go to Administration -> General Settings -> System Options
2. Scroll down to the 'Data Warehouse Options' section and update the 'Entity for Fiscal Periods' and then click Save.

Note: As noted under 'Entity for Fiscal Periods' field, setting an entity for the first time will cause the Time Slicing job to take longer then normal to process the first time after this setting change has been made as it is installing the new data warehouse time slice requests)


Release: ESPCLA99000-14.3-Clarity-Extended Support Plus