Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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 



Suggest Edit

Published December 15, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us