Question

2
Replies
125
Views
sudheerk0543 Member since 2017 10 posts
ING Bank NV
Posted: 3 years ago
Last activity: 3 years 2 months ago
Closed

SQL exception while doing the Data Only upgrade

I am receiving the below error

[java] 2017-07-20 13:26:26,719 ( SQLLoaderInternal) INFO - DROP VIEW SMIN_DATA_OWNER.PCV4_ASSIGNMENTWB_SUMMARY

[java] 2017-07-20 13:26:26,733 ( SQLLoaderInternal) INFO - File: oracledate00150.sql

[java] 2017-07-20 13:26:26,734 ( SQLLoaderInternal) INFO - DROP VIEW SMIN_DATA_OWNER.PCV4_WORK_HISTORY

[java] 2017-07-20 13:26:26,744 ( SQLLoaderInternal) INFO - File: oracledate00160.sql

[java] 2017-07-20 13:26:26,745 ( SQLLoaderInternal) INFO - ALTER TABLE SMIN_DATA_OWNER.PR_INDEX_ACCESSGROUPROLES

[java] 2017-07-20 13:26:26,774 ( SQLLoaderInternal) INFO - Failed to execute SQL in file oracledate00160.sql

[java]

[java] java.sql.SQLException: ORA-01442: column to be modified to NOT NULL is already NOT NULL

[java]

[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)

[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)

[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)

[java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)

[java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)

[java] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)

[java] at com.pega.pegarules.install.SQLLoaderInternal.readAndExecuteSQLStatements(SQLLoaderInternal.java:151)

[java] at com.pega.pegarules.install.SQLLoaderInternal.load(SQLLoaderInternal.java:110)

[java] at com.pega.pegarules.install.SQLLoader.loadInner(SQLLoader.java:98)

[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:77)

[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)

[java] 2017-07-20 13:26:26,777 ( SQLLoaderInternal) WARNING - Statement: ALTER TABLE SMIN_DATA_OWNER.pr_index_accessgrouproles MODIFY pzInsKey NOT NULL

[java] 2017-07-20 13:26:26,777 ( 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-01442: column to be modified to NOT NULL is already NOT NULL

[java]

[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

[java] at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)

[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)

[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)

[java] at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1916)

[java] at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1878)

[java] at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:318)

[java] at com.pega.pegarules.install.SQLLoaderInternal.readAndExecuteSQLStatements(SQLLoaderInternal.java:151)

[java] at com.pega.pegarules.install.SQLLoaderInternal.load(SQLLoaderInternal.java:110)

[java] at com.pega.pegarules.install.SQLLoader.loadInner(SQLLoader.java:98)

[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:77)

[java] ... 1 more

BUILD FAILED

/pega_install/scripts/setupDatabase.xml:2264: The following error occurred while executing this line:

/pega_install/scripts/setupDatabase.xml:2282: Java returned: 1

Please help

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn