Question
DXC Technology
BE
Last activity: 7 Mar 2018 10:38 EST
Error while loading rules jar
Dears,
I am getting the below error while loading the rules jar. But the development team says that they have not done any changes to the mentioned table. Why is this showing up. Though it doesnt affect the jar import and doesnt throw errors during import.
[2/23/18 14:52:10:969 CET] 00000019 SystemOut O 2018-02-23 14:52:10,965 [.PRPCWorkManager : 3] [ STANDARD] [ ASL:01.46] ( internal.access.DatabaseImpl) ERROR id222222 - Error occured while trying to add Index columns for an property
com.pega.pegarules.pub.database.DatabaseException: Database-General Problem executing SQL to update database schema 1031 42000 ORA-01031: insufficient privileges
From: (B37F39C4DC7128CAFA639AB13652A2772)
SQL: alter table ASL_RULES_SCHEMA.pr_index_circumstance_def add (pyTempText VARCHAR2(32) )
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 1031: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
Dears,
I am getting the below error while loading the rules jar. But the development team says that they have not done any changes to the mentioned table. Why is this showing up. Though it doesnt affect the jar import and doesnt throw errors during import.
[2/23/18 14:52:10:969 CET] 00000019 SystemOut O 2018-02-23 14:52:10,965 [.PRPCWorkManager : 3] [ STANDARD] [ ASL:01.46] ( internal.access.DatabaseImpl) ERROR id222222 - Error occured while trying to add Index columns for an property
com.pega.pegarules.pub.database.DatabaseException: Database-General Problem executing SQL to update database schema 1031 42000 ORA-01031: insufficient privileges
From: (B37F39C4DC7128CAFA639AB13652A2772)
SQL: alter table ASL_RULES_SCHEMA.pr_index_circumstance_def add (pyTempText VARCHAR2(32) )
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 1031: java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaDDL(DatabaseImpl.java:7259)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaUpdates(DatabaseImpl.java:7169)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBAddIndexColumns(DatabaseImpl.java:7094)
at com.pega.pegarules.session.internal.mgmt.Executable.executeDBAddIndexColumns(Executable.java:8256)
at com.pegarules.generated.activity.ra_action_savecircumstanceindex_5cc8fc82adff7c948485cb141ae9d1c8.step4_circum0(ra_action_savecircumstanceindex_5cc8fc82adff7c948485cb141ae9d1c8.java:666)
at com.pegarules.generated.activity.ra_action_savecircumstanceindex_5cc8fc82adff7c948485cb141ae9d1c8.perform(ra_action_savecircumstanceindex_5cc8fc82adff7c948485cb141ae9d1c8.java:130)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.exec.internal.declare.infengine.ChainingEngineUtilImpl.runActivity(ChainingEngineUtilImpl.java:225)
at com.pega.pegarules.exec.internal.declare.infengine.TriggerImpl.evaluateNetworks(TriggerImpl.java:307)
at com.pega.pegarules.data.internal.access.DatabaseImpl.performTriggers(DatabaseImpl.java:12809)
at com.pega.pegarules.data.internal.access.Saver.performTriggers(Saver.java:676)
at com.pega.pegarules.data.internal.access.Saver.saveDeferred(Saver.java:380)
at com.pega.pegarules.data.internal.access.DatabaseImpl.saveDeferred(DatabaseImpl.java:4951)
at com.pega.pegarules.data.internal.access.DatabaseImpl.saveDeferred(DatabaseImpl.java:14521)
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importContents(SaverLoader.java:457)
at com.pega.pegarules.deploy.internal.util.ImportImpl.performImport(ImportImpl.java:889)
at com.pega.pegarules.deploy.internal.util.ImportImpl.performImport(ImportImpl.java:762)
at com.pega.pegarules.deploy.internal.util.ImportImpl.importArchive(ImportImpl.java:670)
at com.pega.pegarules.deploy.internal.util.ImportImpl.importPegaArchive(ImportImpl.java:739)
at com.pega.pegarules.deploy.internal.archive.PegaArchiveAbstract.doImport(PegaArchiveAbstract.java:362)
at com.pegarules.generated.pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.pxImportArchive07_10_17(pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.java:142)
at com.pegarules.generated.pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.invoke(pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.java:84)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:133)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:110)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:8954)
at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181)
at com.pegarules.generated.pega_importexport_pximportexport.pxImportArchive(pega_importexport_pximportexport.java:281)
at com.pegarules.generated.activity.ra_action_pegarulesmove_zip_to_db_8f7de3715a31006e8f8dda67c50322d5.step8_circum0(ra_action_pegarulesmove_zip_to_db_8f7de3715a31006e8f8dda67c50322d5.java:879)
at com.pegarules.generated.activity.ra_action_pegarulesmove_zip_to_db_8f7de3715a31006e8f8dda67c50322d5.perform(ra_action_pegarulesmove_zip_to_db_8f7de3715a31006e8f8dda67c50322d5.java:207)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3500)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivities(ThreadRunner.java:572)
at com.pega.pegarules.session.internal.mgmt.PRThreadImpl.runActivities(PRThreadImpl.java:453)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.executeBatchTask(QueueProcessor.java:257)
at com.pega.pegarules.session.internal.async.agent.QueueProcessor.execute(QueueProcessor.java:320)
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:945)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.performTargetActionWithLock(PRSessionProviderImpl.java:1259)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:1008)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.doWithRequestorLocked(PRSessionProviderImpl.java:901)
at com.pega.pegarules.session.internal.async.BatchRequestorTask.run(BatchRequestorTask.java:670)
at com.pega.pegarules.session.internal.async.Agent.runBatchTask(Agent.java:815)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.processAsyncTask(AsyncServant.java:230)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.AsyncServant.invoke(AsyncServant.java:167)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._invokeEngine_privact(EngineImpl.java:315)
at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.invokeEngine(EngineImpl.java:263)
at com.pega.pegarules.session.internal.engineinterface.etier.ejb.EngineBean.invokeEngine(EngineBean.java:225)
at sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:367)
at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:408)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:223)
at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingException(AppServerBridgeToPega.java:245)
at com.pega.pegarules.internal.etier.ejb.EngineBeanBoot.invokeEngine(EngineBeanBoot.java:168)
at com.pega.pegarules.internal.etier.interfaces.EJSLocalStatelessEngineBMT_f2439d86.invokeEngine(Unknown Source)
at com.pega.pegarules.session.internal.engineinterface.etier.mdb.PRAsync.processRequest(PRAsync.java:155)
at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.AsyncTask.run(AsyncTask.java:64)
at com.pega.pegarules.session.internal.engineinterface.etier.asynchbeans.RunnableWrapper.run(RunnableWrapper.java:71)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:271)
at java.security.AccessController.doPrivileged(AccessController.java:399)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:797)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1731)
Caused by:
java.sql.SQLSyntaxErrorException: ORA-01031: insufficient privileges
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:194)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1882)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1847)
at oracle.jdbc.driver.T4CStatement.execute(T4CStatement.java)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:301)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.pmiExecute(WSJdbcStatement.java:1579)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.execute(WSJdbcStatement.java:722)
at com.pega.pegarules.data.internal.access.GenericExecutor.execute(GenericExecutor.java:31)
at com.pega.pegarules.data.internal.access.DatabaseImpl.executeDBSchemaDDL(DatabaseImpl.java:7247)
... 63 more
Pegasystems Inc.
IN
Hi Jagannath,
Thanks for posting on PSC.
I got little confused by the statement "I am getting the below error while loading the rules jar" and "Though it doesnt affect the jar import and doesnt throw errors during import." as they're contradictory in nature, though forgive me if I went completely wrong.
Though, I could observe that there is an exception related with insufficient privileges.
Database-General Problem executing SQL to update database schema 1031 42000 ORA-01031: insufficient privileges
Could you explain me, what you're trying to achieve? Is this jar a part of Hfix which modifies database table or schema? If yes, contact your database administrator to get the required permission to successfully import this jar.
Hope it helps, kindly notify if it does.
Regards,
Asif
DXC Technology
BE
Thanks for your reply.
I would like to know why the below script is being triggered during rule installation. Nothing related to this table has been modified as part of development. Moreover it is not even a functional table but one that comes with product.
alter table ASL_RULES_SCHEMA.pr_index_circumstance_def add (pyTempText VARCHAR2(32) )
Its not related to hot fix. It is a plain rules jar containing patches and fixes.
DXC Technology
BE
I found the answer for this in this link :
Seems like when a circumstance using property is created, an entry is added into this table but since there is no admin access to alter tables, the error is thrown.
regards,
Jagan