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
Nordea
SE
In the Oracle script file I can see below scripts are causing his problem as the table already has constraint name set as PC_ASSIGN_WORKBASKET_PK:--
ALTER TABLE KYC10_APP_DATA.PC_ASSIGN_WORKBASKET
DROP CONSTRAINT GETNEXTWORKFROMBASKET
/
ALTER TABLE KYC10_APP_DATA.pc_assign_workbasket
ADD CONSTRAINT "PC_ASSIGN_WORKBASKET_PK" PRIMARY KEY
so, for now, I have resolved the issue by running the below query so that pega upgrade script drop & regenerate the needed constraint:--
ALTER TABLE KYC10_APP_DATA.PC_ASSIGN_WORKBASKET RENAME CONSTRAINT
PC_ASSIGN_WORKBASKET_PK TO GETNEXTWORKFROMBASKET;
But can someone from GCS team look into the upgrade script file for 8.4.1 as this error appears everytime we start the upgrade.