ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

SCHEDULE_START is updated to NULL after upgrading to 15.9.2


Article ID: 221580


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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.


Change in logic defined in DWH_DW_INVESTMENT_V


Version: 15.9.2


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.