1. Home
  2. Support
Article - CS198198

mks.frame.sql.FrameworkSQLException error discarding pending create subproject after running Integrity reysnccp

Modified: 11-Dec-2017   


Applies To

  • PTC RV&S (formerly Integrity Lifecycle Manager) 10.5 to 10.7

Description

  • mks.frame.sql.FrameworkSQLException error discarding pending create subproject after running Integrity reysnccp
  • Got error message "*** Could not execute sql.Statement: mks.frame.sql.FrameworkSQLException" when trying to discard Integrity change package that has CreateSubproject entry
  • Integrity server log shows:
[mksis.IntegrityServer] GENERAL(0): mks.frame.sql.LoggingSQLException -- java.sql.SQLException: The DELETE statement conflicted with the REFERENCE constraint "FK_CMSUBPROJECT_SUBTRUNK". The conflict occurred in database "Moodys_106", table "dbo.CMSUBPROJECT", column 'SUBTRUNK'.; SQLState=23000; code=547; SQLStatement=DELETE FROM CMPROJECT
  WHERE CMPROJECT.OID=? AND
  CMPROJECT.WRITE_TICK=?
 at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
 at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
 at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
 at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631)
 at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:590)
 at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:552)
 at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:500)
 at mks.frame.sql.jdbc.common.CancellablePreparedStatement.executeUpdate(CancellablePreparedStatement.java:94)
 at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:239)
 at mks.im.core.sql.ShortTransaction.executeStmt(ShortTransaction.java:501)
 at mks.im.core.sql.ShortTransaction.executeStmt(ShortTransaction.java:462)
 at mks.im.core.IMUnitOfWork.generateSQL(IMUnitOfWork.java:2166)
 at mks.im.core.IMUnitOfWork.writeoutScratchObjects(IMUnitOfWork.java:2029)
 at mks.im.core.IMUnitOfWork.commit(IMUnitOfWork.java:242)
 
    This is a printer-friendly version of Article 198198 and may be out of date. For the latest version click CS198198