Discussion
Nordea
SE
Last activity: 22 Jul 2020 10:35 EDT
ORA-02443: Cannot drop constraint - nonexistent constraint
Hi,
We are upgrading from 8.3.2 to 8.4.1 and getting below error:--
a] Exception in thread "main" com.pega.pegarules.install.SQLLoaderException: Error executing SQL statements [java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:79) [java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:64) [java] Caused by: java.sql.SQLException: ORA-02443: Cannot drop constraint - nonexistent constraint [java] [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) [java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) [java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) [java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) [java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252) [java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213) [java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37) [java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896) [java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119) [java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1737) [java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1692) [java] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:300) [java] at com.pega.pegarules.install.SQLLoaderInternal.readAndExecuteSQLStatements(SQLLoaderInternal.java:149) [java] at com.pega.pegarules.install.SQLLoaderInternal.load(SQLLoaderInternal.java:108) [java] at com.pega.pegarules.install.SQLLoader.loadInner(SQLLoader.java:97) [java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:76) [java] ... 1 more [java] Caused by: Error : 2443, Position : 64, Sql = ALTER TABLE KYC10_APP_DATA.PC_ASSIGN_WORKBASKET [java] DROP CONSTRAINT GETNEXTWORKFROMBASKET, OriginalSql = ALTER TABLE KYC10_APP_DATA.PC_ASSIGN_WORKBASKET [java] DROP CONSTRAINT GETNEXTWORKFROMBASKET, Error Msg = ORA-02443: Cannot drop constraint - nonexistent constraint
Similar issue was observed in the below thread but I don't see any proper solution. Although it was applicable for 7.2.2
here is attached sql file which was generate under /schema/generated/oracledate/update folder