1. Home
  2. Support
Article - CS69458

"Add Database Constraints" phase fails with "ORA-02296: cannot enable (xxxxx.) - null values found" error in Windchill PDMLink

Modified: 02-Aug-2016   


Applies To

  • Windchill PDMLink 10.0 to 11.0
  • FlexPLM 10.2 to 11.0

Description

  • Add Database Constraints phase fails with
java.sql.SQLIntegrityConstraintViolationException: ORA-02296:cannot enable (xxxxx.) - null values found
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1033)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1329)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1909)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1871)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)
    at wt.tools.sql.SQLCommand.doExecute(SQLCommand.java:98)
    at wt.tools.sql.AbstractCommand.doExecute(AbstractCommand.java:74)
    at wt.tools.sql.AbstractCommand.execute(AbstractCommand.java:56)
    at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeCommand(AbstractUpgradeDBHelper.java:349)
    at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeSql(AbstractUpgradeDBHelper.java:307)
    at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeBatchByName(AbstractUpgradeDBHelper.java:517)
    at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeBatchByName(AbstractUpgradeDBHelper.java:494)
    at com.ptc.windchill.upgrade.dbservices.AbstractUpgradeDBHelper.executeBatch(AbstractUpgradeDBHelper.java:487)
    at com.ptc.windchill.upgrade.phases.AddConstraints.execute(AddConstraints.java:131)
    at com.ptc.windchill.upgrade.statemachine.state.DefaultRunningUpgradeState.execute(DefaultRunningUpgradeState.java:34)
    at com.ptc.windchill.upgrade.statemachine.state.PhaseEventUpgradeState.execute(PhaseEventUpgradeState.java:50)
    at com.ptc.windchill.upgrade.statemachine.state.PersistPhaseUpgradeState.execute(PersistPhaseUpgradeState.java:100)
    at com.ptc.windchill.upgrade.statemachine.state.ReportWriterUpgradeState.execute(ReportWriterUpgradeState.java:76)
    at com.ptc.windchill.upgrade.statemachine.UpgradeFrameworkStateMachine.run(UpgradeFrameworkStateMachine.java:399)
    at com.ptc.windchill.upgrade.statemachine.UpgradeFrameworkStateMachine.main_(UpgradeFrameworkStateMachine.java:786)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at com.ptc.windchill.upgrade.statemachine.DynamicLauncher.runUpgradeFrameworkStateMachine(DynamicLauncher.java:112)
    at com.ptc.windchill.upgrade.statemachine.DynamicLauncher.main(DynamicLauncher.java:30)
  • Different SQL statements can be seen such as:
SQLCommand[ALTER TABLE WTDOCUMENT MODIFY(hasHangingChange NUMBER(1) NOT NULL ..." error in Windchill PDMLink 10.1

SQLCommand[ALTER TABLE WTACLENTRY MODIFY(allExceptPrincipal NUMBER(1) NOT NULL, permissionType NUMBER NOT NULL) ].
This is a printer-friendly version of Article 69458 and may be out of date. For the latest version click CS69458