Cross Project Customization take long time to applying changes on to the project.

  • KM00908722
  • 13-May-2014
  • 13-May-2014

Summary

Cross Project Customization would take a very long time to apply changes on to the project when there are modifications on the template project.

Error

You will notice that the Cross Project Customization would take a very long time to apply changes on to the project when there are modifications on the template project. This is particular to big projects when big amount of data on different tables along with deleting User defined Fields (UDF fields).

Cause

This is caused by the amount of entries that are deleted on the AUDIT_PROPERTIES and AUDIT_LOG tables.

Fix

This are the suggested steps:
 
1. From ALM, go to the following path:
Tools -> Clear History (in the linked project)
With this, we can reduce the size of the table AUDIT_LOG and AUDIT_PROPERTIES.
 
2. Manually from the Site Administrator run this query:
Delete  FROM AUDIT_LOG WHERE (((AU_ENTITY_TYPE = /*P*/'RUN')) AND LOWER(AU_ACTION) NOT LIKE 'ca\_%' ESCAPE '\') AND AU_ACTION_ID NOT IN (SELECT DISTINCT AP_ACTION_ID FROM AUDIT_PROPERTIES)
3. Try the Cross Prject Customization again.