Question

100
Views
Devan Member since 2014 34 posts
Virtusa
Posted: April 6, 2017
Last activity: April 6, 2018
Closed

Privilages required for generateudf

Hi team,

Im trying to execute the generateudf.sh script and getting the below error.

017-04-06 09:25:50,630 ( OracleUDFJarLoader) WARNING - Encountered database error attempting to load jar into Oracle:

java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1017)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:655)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:45)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:933)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1075)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1640)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1603)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:308)
at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.installJarOnOracle(OracleUDFJarLoader.java:174)
at com.pega.pegarules.install.udf.loaders.OracleUDFJarLoader.load(OracleUDFJarLoader.java:73)
at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.loadUDFJar(UDFManager.java:348)
at com.pega.pegarules.install.UDFManager$ExecuteUDFWithOutTransaction.executeInner(UDFManager.java:293)
at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.execute(UDFManager.java:357)
at com.pega.pegarules.install.UDFManager.process(UDFManager.java:178)
at com.pega.pegarules.install.UDFManager.main(UDFManager.java:129)

I hope the df user dosent have appropriate privialge to load jar files. Please correct me if my understanding is wrong.

Could you please let me know what all the privilages required for the database user to execute the generateudf script.

Thanks,

Aruldevan

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