1. Home
  2. Support
Article - CS341358

DB constraint violation when deleting a Test Session in Windchill RV&S / Integrity Lifecycle Manager

Modified: 23-Mar-2021   


Applies To

  • PTC RV&S (formerly Integrity Lifecycle Manager) 10.8 to 12.4
  • Additional Test Result Fields configured for Test Result type

Description

  • DB constraint violation when deleting a Test Session in Windchill RV&S / Integrity Lifecycle Manager
  • Test Session deletion results in error:
    • Oracle example (constraint name can be different)
      DEBUG(5): mks.ci.exception.CIException -- java.sql.SQLException: MKS131372: An unhandled database exception has occurred.  Please contact your administrator.
      The error supplied by the database is:
        ORA-02292: integrity constraint (INTEGRITY.SYS_C007021) violated - child record found
    • MS SQL example (constraint name can be different)
      DEBUG(5): mks.ci.exception.CIException -- java.sql.SQLException: MKS131372: An unhandled database exception has occurred.  Please contact your administrator.
      The error supplied by the database is:
        The DELETE statement conflicted with the REFERENCE constraint "FK__TRMetadat__Resul__62CE36BF". The conflict occurred in database "<DB name>", table "dbo.TRMetadata", column 'ResultID'.
    • SQL logging enabled will show this to happen at
      DELETE FROM TRResults WHERE TRResults.SessionID or TRResults.CaseID
This is a printer-friendly version of Article 341358 and may be out of date. For the latest version click CS341358