Support Article

During data-only upgrade SQL exception occurs for a constraint

SA-29806

Summary



During a Data upgrade, there is a SQL Exception error in the log.


Error Messages



     [java] 2016-10-25 19:51:29,213 (                  SQLLoaderInternal) WARNING - Statement: ALTER TABLE SPEGAD01_TEMP.PR_PAGE_STORE
     [java] DROP CONSTRAINT PR_PAGE_STORE_I01U
     [java] 2016-10-25 19:51:29,214 (                  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


Steps to Reproduce



Recreated the schema copy and tried again with same results


Root Cause



An issue in the custom application code or rules unexpected primary key name in production PR_PAGE_STORE table

Resolution



Perform the following local-change: 

The primary key name was incorrect and was changed to match the one in the lower environment where the data upgrade had worked.

It had been set to PR-PAGE_STORE_I01U and needed to be changed to 
PR-PAGE_STORE_PK.

 

 

Published October 31, 2016 - Updated December 14, 2016

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.