Discussion

2
Replies
80
Views
VigneshAravind Member since 2007 28 posts
Cognizant
Posted: 3 years ago
Last activity: 3 years 1 month ago
Closed

java.sql.SQLException: ORA-02443: Cannot drop constraint - nonexistent constraint

We were performing the fourth step of a lift and shift upgrade (6.1.2 to 7.2.2) "Upgrade data schema only" in QA environment.
We received the following error while running the upgrade.sh ( Linux + Weblogic + Oracle 12c setup)
Kindly help us with your suggestions.
[java] 2017-08-15 07:34:31,206 ( SQLLoaderInternal) INFO - File: oracledate00010.sql
[java] 2017-08-15 07:34:31,207 ( SQLLoaderInternal) INFO - ALTER TABLE SCHEMANAME.PC_ASSIGN_WORKBASKET
[java] 2017-08-15 07:34:31,218 ( SQLLoaderInternal) INFO - Failed to execute SQL in file oracledate00010.sql
[java]
[java] java.sql.SQLException: ORA-02443: Cannot drop constraint - nonexistent constraint
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
[java] ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)
[java] 2017-08-15 07:34:31,221 ( SQLLoaderInternal) WARNING - Statement: ALTER TABLE SCHEMANAME.PC_ASSIGN_WORKBASKET
[java] DROP CONSTRAINT GETNEXTWORKFROMBASKET
[java] 2017-08-15 07:34:31,222 ( SQLLoaderInternal) WARNING -
[java] ********************************************************************************
[java]
[java] Encountered a SQL Exception, clean schema before running again.
[java]
[java] ********************************************************************************
[java] Exception in thread "main" com.pega.pegarules.install.SQLLoaderException: Error executing SQL statements
[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:80)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)
[java] Caused by: java.sql.SQLException: ORA-02443: Cannot drop constraint - nonexistent constraint
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
[java] ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:77)
[java] ... 1 more
BUILD FAILED
/prpc/PRPC722/scripts/setupDatabase.xml:2264: The following error occurred while executing this line:
/prpc/PRPC722/scripts/setupDatabase.xml:2282: Java returned: 1
Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn