Question

108
Views
Close popover
ARULDEVAN T.T (Devan)
Virtusa

Virtusa
IN
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

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.