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:
- 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'
- 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'
- On the Project, General properties page, DO NOT MAKE ANY CHANGES, but simply click 'Save' button
- 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.
Resolved in Clarity 13.2 Generic Patch. Reference TEC599354
Resolved in Clarity 13.3 Generic Patch. Reference TEC605767
Resolved in CA PPM 14.1