Currently we are in the process of migrating and upgrading QC10 Patch 7 projects to QC 11.52 Patch5.
After the upgrade of QC10 project to QC11.52 Patch5 ; we noticed that while we attempt to click on Audit Log details present in History tab of a Requirement, we are receiving the below error message.
**"Failed to create new history entity . The field name "RQ_TEXT_SYNC" is incorrect."**
Below is the screenshot of the error message.
From Initial investigation it is found that whichever requirements has the "RQ_TEXT_SYNC" field in its backend AUDIT LOG is experiencing this issue.
select * from project_database_db.audit_log,project_database_db.audit_properties
1. Noticed that RQ_TEXT_SYNC column has data value either "NULL" or "Y".
2. Did any one face this issue before?Is this a known issue?
3.What is the purpose of RQ_TEXT_SYNC field ? From the database reference file I got to know that it is for internal use and data shouldn't be changed for this field.
4.Steps for replication of this issue over a newly created requirement and Details for fixing this issue?
5.One of the workaround we received from Vendor is below:
SELECT count(*) FROM AUDIT_PROPERTIES where AP_FIELD_NAME = ‘RQ_TEXT_SYNC’
The following SQL will remove all audit records pertaining to RQ_TEXT_SYNC field and that should resolve the reported error:
DELETE FROM AUDIT_PROPERTIES
How safe is to perform the above deletion operation? Will there be any impact because of conducting this deletion operation from the AUDIT_PROPERTIES table?
Marked as spam
Question ID: 106344