Support Article
Error when update.sh is run during application update
SA-58938
Summary
Error occurs when update.sh is run while updating to Pega 7.4.
Error Messages
Error : 604, Position : 0, Sql = create or replace java class schema PEGA_DATA using blob(select pzbinarycontent from pz_blobtable where pzclassname='com/pega/pegarules/data/udf/directstreamreader/UnsupportedFeatureException.class'), OriginalSql = create or replace java class schema PEGA_DATA using blob(select pzbinarycontent from pz_blobtable where pzclassname='com/pega/pegarules/data/udf/directstreamreader/UnsupportedFeatureException.class'), Error Msg = ORA-00604: error occurred at recursive SQL level 1
[java] ORA-20031: Java Development Disabled
( OracleUDFJarLoader) WARNING - Encountered database error attempting to load jar into Oracle:
[java] java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
[java] ORA-20031: Java Development Disabled
[java] ORA-06512: at line 4
[java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
[java] at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
[java] at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
[java] at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
[java] at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
[java] at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:213)
[java] at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:37)
[java] at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:896)
[java] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1119)
[java] at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1661)
[java] at oracle.jdbc.driver.OracleStatement.executeLargeUpdate(OracleStatement.java:1626)
[java] at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1613)
[java] at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:282)
[java] at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.installJarOnOracle(OracleUDFJarLoader.java:168)
[java] at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.load(OracleUDFJarLoader.java:73)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.loadUDFJar(UDFManager.java:348)
[java] at com.pega.pegarules.install.UDFManager$ExecuteUDFWithOutTransaction.executeInner(UDFManager.java:293)
Steps to Reproduce
- Update from Pega 7.2.1 to Pega 7.4
- Run update.sh file after following the steps in update document
Root Cause
Java was not enabled in the database.
Resolution
Perform the following local-change:
Enable Java Development in the Oracle database.
Published July 23, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.