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

 Jagannath Rajagopalan (JagannathR8869)
DXC Technology

DXC Technology
BE
JagannathR8869 Member since 2016 43 posts
DXC Technology
Posted: Feb 23, 2018
Last activity: Mar 7, 2018
Posted: 23 Feb 2018 9:00 EST
Last activity: 7 Mar 2018 10:38 EST
Closed

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

Show More

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


Show Less
To see attachments, please log in.
Low-Code App Development
System Administration
Installation and Deployment

Posted: 6 years ago
Posted: 23 Feb 2018 10:07 EST
Mohammad Asif Hasan (Mohammad_Asif_Hasan)
EPAM Systems, Inc.
Mohammad Asif Hasan
EPAM Systems, Inc.
ES

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

 

To see attachments, please log in.
Posted: 6 years ago
Posted: 6 Mar 2018 9:46 EST
Jagannath Rajagopalan (JagannathR8869)
DXC Technology

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.

To see attachments, please log in.
Posted: 6 years ago
Posted: 7 Mar 2018 10:38 EST
Jagannath Rajagopalan (JagannathR8869)
DXC Technology

DXC Technology
BE

I found the answer for this in this link :

https://community.pega.com/support/support-articles/alter-prindexcircumstancedef-errors-when-adding-circumstance

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

To see attachments, please log in.

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