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

Document ID : KB000032829
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue

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

 

Resolution: 

 

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)