search cancel

Project Management Domain corrupted after 15.9.3 patch 1

book

Article ID: 227788

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Has anyone reported any issue with the domains after the patch has been completed.  The project management domain had the issue below after the patch, I ran the restore domains job and it worked again.  You can see some of the table names are referenced in lower case:

 

There are problems with the Domain:

The following join expressions have invalid fields:

 

The expression DWH_INV_INVESTMENT.INVESTMENT_KEY == DWH_INV_program_HIER_V.CHILD_INVESTMENT_KEY references one or more fields that cannot be found: ID [DWH_INV_program_HIER_V.CHILD_INVESTMENT_KEY] (Source: JoinTree_1)

The expression DWH_INV_program_HIER_V.PARENT_INVESTMENT_KEY == DWH_INV_program_V.INVESTMENT_KEY references one or more fields that cannot be found: ID [DWH_INV_program_HIER_V.PARENT_INVESTMENT_KEY, DWH_INV_program_V.INVESTMENT_KEY] (Source: JoinTree_1)

The expression DWH_INV_status_REPORT.INVESTMENT_KEY == DWH_INV_INVESTMENT.INVESTMENT_KEY references one or more fields that cannot be found: ID [DWH_INV_status_REPORT.INVESTMENT_KEY] (Source: JoinTree_1)

The expression DWH_INV_status_REPORT_LN.status_REPORT_KEY == DWH_INV_status_REPORT.status_REPORT_KEY references one or more fields that cannot be found: ID [DWH_INV_status_REPORT_LN.status_REPORT_KEY, DWH_INV_status_REPORT.status_REPORT_KEY] (Source: JoinTree_1)

The expression DWH_INV_status_REPORT_LN.LANGUAGE_CODE == DWH_INV_status_REPORT_LN.OBJ_LANG_CODE references one or more fields that cannot be found: ID [DWH_INV_status_REPORT_LN.LANGUAGE_CODE, DWH_INV_status_REPORT_LN.OBJ_LANG_CODE] (Source: JoinTree_1)

The expression DWH_ODF_BOE_VALUE_STREAM_00.COP_PRJ_statusRPT_KEY == DWH_INV_status_REPORT.status_REPORT_KEY references one or more fields that cannot be found: ID [DWH_ODF_BOE_VALUE_STREAM_00.COP_PRJ_statusRPT_KEY, DWH_INV_status_REPORT.status_REPORT_KEY] (Source: JoinTree_1)

Encountered a join expression with an unused table alias. The following join expressions have invalid reference(s):

 

Expression DWH_INV_INVESTMENT.INVESTMENT_KEY == DWH_INV_program_HIER_V.CHILD_INVESTMENT_KEY have invalid references [DWH_INV_program_HIER_V]

Expression DWH_INV_program_HIER_V.PARENT_INVESTMENT_KEY == DWH_INV_program_V.INVESTMENT_KEY have invalid references [DWH_INV_program_HIER_V, DWH_INV_program_V]

Expression DWH_INV_status_REPORT.INVESTMENT_KEY == DWH_INV_INVESTMENT.INVESTMENT_KEY have invalid references [DWH_INV_status_REPORT]

Expression DWH_INV_status_REPORT_LN.status_REPORT_KEY == DWH_INV_status_REPORT.status_REPORT_KEY and DWH_INV_status_REPORT_LN.LANGUAGE_CODE == DWH_INV_status_REPORT_LN.OBJ_LANG_CODE have invalid references [DWH_INV_status_REPORT_LN, DWH_INV_status_REPORT, DWH_INV_status_REPORT_LN, DWH_INV_status_REPORT_LN]

Expression DWH_ODF_BOE_VALUE_STREAM_00.COP_PRJ_statusRPT_KEY == DWH_INV_status_REPORT.status_REPORT_KEY have invalid references [DWH_INV_status_REPORT]

 

Environment

Release : 15.9.3

Component : CLARITY JASPERSOFT

Resolution

This was an isolated occurrence and was not reproducible in other environments.

Please run the Restore Domains job to resolve the issue.