Self-Solve Knowledge Search

Minimize Maximize
Cross Project Customization take long time to applying changes on to the project...
Title :
Cross Project Customization take long time to applying changes on to the project.
Document ID :
KM00908722
Product - Version:
quality center ;
OS :
Updated :
Tue May 13 16:33:11 GMT 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.
Problem
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.