Incremental Load Data Warehouse Job Failing with Invalid Object Name Error

Article Id: 105702

Status: Published

Updated On: 18-10-2019 15:16

Products:

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

Issue/Introduction:

The Incremental Load Data Warehouse job fails with the below error:

Caused by: java.sql.SQLSyntaxErrorException: [CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid object name 'dwh_x_inv_plan_per_facts_mv'.

Alternatively, it could fail with an error message referencing other views, such as 'dwh_x_res_team_per_facts_mv'.

Steps to Reproduce:
1. Configure Load Data Warehouse job to run as Incremental during the day and Full once per night
2. Monitor the system during Timeslice rollover (i.e. beginning of the month)
3. Allow Time Slicing to run through and monitor the Incremental Load running after the rollover

Expected Results: Load Data Warehouse - Incremental to complete successfully
Actual Results: Load Data Warehouse Incremental fails with error Invalid object name error

Cause:

Caused by DE30602/CLRT-81565

Environment:

PPM On Premise Environments using an MSSQL database

Resolution:

This issue is fixed on PPM 15.2 and later releases.

Workaround:
Manually recreate the missing view by copying it from another environment of the same release or contact Support for a copy of the view content.