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

SQLLoaderException while Data Schema Upgrade Process

SA-21925

Summary



Upgrading an application from 6.1SP2 to 7.2 causes the Data Upgrade is failing trying to add an index.

Error Messages



[java] INFO: File: oracledate00840.sql
[java] Mar 12, 2016 7:38:38 PM com.pega.pegarules.install.SQLLoader writeMessage
[java] INFO: CREATE INDEX DATA.ATTACH_REF_FROM
[java] Mar 12, 2016 7:38:38 PM com.pega.pegarules.install.SQLLoader writeException
[java] WARNING: Failed to execute SQL in file oracledate00840.sql
[java] java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
[java]
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)

Steps to Reproduce



Follow the process to update to 7.2 split schema.  On the data schema upgrade step execute “./upgrade.sh --dataOnly true”

Root Cause



A defect or configuration issue in the operating environment.  In the data schema there is a table which is not part of the core Pega product.  This table has an index named Attach_Ref_From which is causing a conflict with the one that is needed for the pc_link_attachment table. 

Resolution



Make the following change to the operating environment: 

For any tables added to the schema which are not part of the Pega product or any of its frameworks make sure that the names of the table, constraints, indexes, etc.  do not conflict with names needed for Pega schema objects.

Drop and rename the conflicting index name and then the update completes without issue.
Suggest Edit

Published April 8, 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