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

book

Article ID: 32829

calendar_today

Updated On:

Products

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

Issue/Introduction

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)

Environment

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