PRJ_OBS_ASSOCIATIONS ID and LAST_UPDATED_DATE fields are updated upon Save action when no changes were entered by user

Document ID : KB000018981
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When you simply click the 'Save' button on the project properties page without making any specific changes to the OBS Unit values or any fields on the page, the records in the PRJ_OBS_ASSOCIATIONS table are 'updated' (removed and recreated??) with a new internal ID value and a new LAST_UPDATED_DATE value.

This could be a potential performance issue when clicking the 'Save' button.

Steps to Reproduce:

  1. Create an Investment, selecting OBS Unit values for any type of OBS associated with the object
    Example: I created a Project ; Project Unique Code Name = 'asdf'
  2. Execute a query in the database to examine the records that are created in the PRJ_OBS_ASSOCIATIONS table
    (Take a screenshot or save the results for later comparison)
    SELECT i.code INV_CODE, i.name INV_NAME, o.*
    FROM inv_investments i , prj_obs_associations o
    WHERE o.table_name = 'SRM_PROJECTS'
    AND o.record_id = i.id
    AND i.code = 'asdf'
  3. On the Project, General properties page, DO NOT MAKE ANY CHANGES, but simply click 'Save' button
  4. Now run the SELECT query again from Step #2 and compare the ID and LAST_UPDATED_DATE values

Expected Result: No changes should occur for the PRJ_OBS_ASSOCIATIONS record

Actual Result: The PRJ_OBS_ASSOCIATIONS.ID and PRJ_OBS_ASSOCIATIONS.LAST_UPDATED_DATE fields have been changed.

  

Solution:

WORKAROUND:

None.

STATUS/RESOLUTION:

CLRT-74061
Resolved in Clarity 13.2 Generic Patch. Reference TEC599354
Resolved in Clarity 13.3 Generic Patch. Reference TEC605767  
Resolved in CA PPM 14.1