Deleting a timesheet notes or timeentry notes leaves an orphan record on table ODF_CA_TIMESHEETNOTE & ODF_CA_TIMEENTRYNOTE and can cause performance issues are database level.
Steps to Reproduce:
Expected Result: The data on ODF_CA_timeentrynote & odf_ca_timesheetnote should also be deleted
Actual Result: The data is orphaned and the delete statement which executes is slow as there is no id column on the PRNOTE table
Caused by CLRT-79156
Applies to all supported PAS environments for specified releases.
This is fixed in CA PPM 14.4
Note: The following workaround is provided by our Sustaining Engineering team for On Premise Customers. If you implement Part I, the changes to the code file may be overwritten with subsequent patches or upgrades. Be sure to review this developer, pre-approved customization to the code. Once the issue is resolved in new version, be sure to check and verify the new files are installed and overwrites the existing code files.
If you are a Saas Customer, please contact CA Technical Support and reference this issue.
Part 1: Interim code modification to improve performance and avoid orphan records