SCHEDULE_START is updated to NULL after upgrading to 15.9.2

book

Article ID: 221580

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

We have BI reports that rely on the Start Date of investments. We see that these are failing since upgrading to 15.9.2. We notice that the error message is that SCHEDULE_START is null against DWH_INV_INVESTMENT table.

Cause

Change in logic defined in DWH_DW_INVESTMENT_V

Environment

Version: 15.9.2

Resolution

DWH_DW_INVESTMENT_V had the following logic in 15.9.0:

  1. Evaluate Investments for Start Date
  2. If they are NULL set them to today's date

Its logic has been altered to the following in 15.9.2:

  1. Evaluate Investments for Start Date
  2. If Start Date is NULL
  3. AND If the Investment Type is one of the following:
    1. Application
    2. Asset
    3. Idea
    4. Other
    5. Services
  4. then retain NULL as the Start Date
  5. If Investment Type is anything else, then replace NULL dates with Today's date

So, it is expected for SCHEDULE_START column in DWH_INV_INVESTMENT table (in DWH) to be populated with NULL values if the Investment Type is one amongst those mentioned above.