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

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.

 

 

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