Question

2
Replies
127
Views
Close popover
sudheer kurmana (sudheerk0543)
ING Bank NV
Dev Engineer
ING Bank NV
NL
sudheerk0543 Member since 2017 10 posts
ING Bank NV
Posted: July 20, 2017
Last activity: July 26, 2017
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

System Administration Upgrades
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.