Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 sudheer kurmana (sudheerk0543)
ING Bank NV
Dev Engineer
ING Bank NV
NL
sudheerk0543 Member since 2017 10 posts
ING Bank NV
Posted: Jul 20, 2017
Last activity: Jul 26, 2017
Posted: 20 Jul 2017 8:20 EDT
Last activity: 26 Jul 2017 7:46 EDT
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)

Show More

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


Show Less
To see attachments, please log in.
Updates

Posted: 8 years ago
Posted: 20 Jul 2017 21:16 EDT
Sai Boyana (boyas)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Sudheer,

 

Can you check this alter statement "ALTER TABLE SMIN_DATA_OWNER.PR_INDEX_ACCESSGROUPROLES" in oracledate00160.sql and validate the alter statement it seems one of the column is already NOT NULL and the statement is  trying to alter it again to NOT NULL.

Hope this helps you to resolve the issue.

 

Thanks

Sai Kishore

 

 

To see attachments, please log in.
Posted: 8 years ago
Posted: 26 Jul 2017 7:46 EDT
sudheer kurmana (sudheerk0543)
ING Bank NV
Dev Engineer
ING Bank NV
NL

Hi Sai,

Thanks for the response but can you please tell me where i can see oracledate00160.sql

 

 

To see attachments, please log in.

Related content:

Discussion

Upgrade only Data Schema

Question

I am receiving the error table or view does not exist while performing the data only upgrade

Discussion

Data only upgrade issue - 5.5 SP1 to Pega 7

Discussion

Null Pointer Exception on switching portals from Developer Portal only after upgrade

Discussion

How to overcome PRIMARY KEY constraint SQL exception during Rules Migration as a part of upgrade?

Discussion

Is VARBINARY data type is supported during upgrade for SQL server 2008?

Question

Issues while upgrading from 7.1.8 to 8.6 -Exception during processing of http request

Question

Upgrade.bat --Data only - Data upgrade failed From Pega 631 to 731 - unable to load classes from DB

Discussion

Caught exception while retrieving Data-Admin-Requestor instance "prpc!BATCH"

Question

PEGA Upgrade (7.3.1 to 8.3.1) - SQL issues.

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

Pega Collaboration Center 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