Support Article

During data-only upgrade SQL exception occurs for a constraint



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] 2016-10-25 19:51:29,214 (                  SQLLoaderInternal) WARNING -
     [java] ********************************************************************************
     [java] Encountered a SQL Exception, clean schema before running again.
     [java] ********************************************************************************
     [java] Exception in thread "main" com.pega.pegarules.install.SQLLoaderException: Error executing SQL statements
     [java]  at com.pega.pegarules.install.SQLLoader.load(
     [java]  at com.pega.pegarules.install.SQLLoader.main(
     [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


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 



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.