Error Message after clicking on Audit Log details present in History tab of a Requirement

  • Questions
  • Error Message after clicking on Audit Log details present in History tab of a Requirement
Question ID: 106344
0
0

Hi All,

**Issue Description**

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.

![alt text][1]

From Initial investigation it is found that whichever requirements has the "RQ_TEXT_SYNC" field in its backend AUDIT LOG is experiencing this issue.

Ex:

select * from project_database_db.audit_log,project_database_db.audit_properties
where project_database_db.audit_properties.AP_FIELD_NAME =’RQ_TEXT_SYNC’ and
ap_action_id =au_action_id

**Questions**:

1. Noticed that RQ_TEXT_SYNC column has data value either "NULL" or "Y".
I want to understand in which scenario NULL will be populated in RQ_TEXT_SYNC field for a REQ , and in which case "Y" will be populated in RQ_TEXT_SYNC field?

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:
Run below query to get a count from AUDIT_PROPERTIES table:

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
WHERE AP_FIELD_NAME = ‘RQ_TEXT_SYNC’

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?
Please provide your valuable thoughts on this issue , I will try them out on my end.

Regards,
Srihari

[1]: /storage/temp/328-original.png

Marked as spam
Posted by (Questions: 28, Answers: 21)
Asked on August 17, 2015 5:18 pm
6 views
Answers (1)
1
Private answer

Also posted at:

[http://h30499.www3.hp.com/t5/Quality-Center-Support-and-News/Error-Message-while-we-attempt-to-click-on-Audit-Log-details/m-p/6775072#M93629][1]

[1]: http://h30499.www3.hp.com/t5/Quality-Center-Support-and-News/Error-Message-while-we-attempt-to-click-on-Audit-Log-details/m-p/6775072#M93629

Marked as spam
Posted by (Questions: 6, Answers: 167)
Answered on August 21, 2015 4:22 pm
Hi Captain Mercury, Can you please validate my analysis peformed for this issue, please let me know in case if I need to consider any alternatives. Regards, Srihari
( at August 21, 2015 5:23 pm)