Related Tips & Info
Wikis - Page

Knowledge Document: Unable to delete record due to Reference constraint error with table TSWORKINGC

Caroline Oest
 
0 Likes

Users are unable to delete a record due to the following eror: Error: Error executing SQL statement: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK_wcRecordUri". The conflict occurred in database "DatasetName", table "dbo.TSWORKINGC", column 'wcRecordUri'. Details: SQL state and native error code are consecutively 23000 , 547

Environment

Content Manager 10.x, 23.x

Situation

Users receive the below error when trying to delete a record

Cause

This is due to the record having an existing Working Copy within the dataset. This can be checked by using the following SQL (if it returns with rows then it means the record has an existing Working Copy attached to it):
SELECT * from TSWORKINGC where wcRecordUri = Number
*Note: Number is the Unique Identifier (URI) of the to-be-deleted record
Find resolution on support portal

Labels:

Support Tips/Knowledge Docs
Comment List
Related
Recommended

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.