Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Not able to bring it up Pega application due to some changes

SA-21731

Summary



Pega application crashes due to changes in application rules or access groups and not able to bring it up the application.

Error Messages



2016-04-04 14:24:40,263 [        VFWAPPDB2054] [          ] [                    ] [                    ] (        internal.access.Opener) ERROR   - Caught exception during open
com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=7;PEGARULES.PR4_RULE, DRIVER=4.19.26
               at com.ibm.db2.jcc.am.kd.a(Unknown Source)
               at com.ibm.db2.jcc.am.kd.a(Unknown Source)
               at com.ibm.db2.jcc.am.kd.a(Unknown Source)
               at com.ibm.db2.jcc.am.ResultSet.completeSqlca(Unknown Source)
               at com.ibm.db2.jcc.am.ResultSet.earlyCloseComplete(Unknown Source)
               at com.ibm.db2.jcc.t4.bb.a(Unknown Source)
               at com.ibm.db2.jcc.t4.cb.a(Unknown Source)
               at com.ibm.db2.jcc.t4.cb.c(Unknown Source)
               at com.ibm.db2.jcc.t4.q.a(Unknown Source)
               at com.ibm.db2.jcc.t4.h.readFetch_(Unknown Source)
               at com.ibm.db2.jcc.am.ResultSet.flowFetch(Unknown Source)
               at com.ibm.db2.jcc.t4.c.f(Unknown Source)
               at com.ibm.db2.jcc.am.mc.a(Unknown Source)
               at com.ibm.db2.jcc.t4.c.a(Unknown Source)
               at com.ibm.db2.jcc.am.ResultSet.nextX(Unknown Source)
               at com.ibm.db2.jcc.am.ResultSet.next(Unknown Source)
               at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
               at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
               at com.pega.pegarules.data.internal.access.DatabaseResultSet.next(DatabaseResultSet.java:452)
               at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.createPageFromResultSet(PageDatabaseMapperImpl.java:471)
               at com.pega.pegarules.data.internal.access.Opener.getResultFromResultSet(Opener.java:945)
               at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:716)
               at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:410)
               at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:4547)
               at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:4374)
               at com.pega.pegarules.exec.internal.declare.infengine.cbi.DeclarativeCacheManagerImpl.addDecisionRuleReferencedByDeclarative(DeclarativeCacheManagerImpl.java:2086)
               at com.pega.pegarules.exec.internal.declare.infengine.cbi.DeclarativeCacheManagerImpl.initializeDeclarativeReferencingInfoIfNeeded(DeclarativeCacheManagerImpl.java:1027)
               at com.pega.pegarules.exec.internal.declare.infengine.cbi.DeclarativeCacheManagerImpl.getPropertyUsageType(DeclarativeCacheManagerImpl.java:922)
               at com.pega.pegarules.exec.internal.declare.infengine.cbi.DeclarativeCacheManagerImpl.isPropertyUsedByDeclaratives(DeclarativeCacheManagerImpl.java:707)
               at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl.autoChain(ClipboardPropertyImpl.java:1025)
               at com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl.autoChain(ClipboardPropertyImpl.java:922)
               at com.pega.pegarules.data.internal.clipboard.DirectStreamContainer.getStringAndChainBasedOnType(DirectStreamContainer.java:1278)
               at com.pega.pegarules.data.internal.clipboard.ClipboardPageImpl.getValueInTypeAndChain(ClipboardPageImpl.java:1371)
               at com.pega.pegarules.data.internal.clipboard.ClipboardPageImpl.getValueInType(ClipboardPageImpl.java:1267)
               at com.pega.pegarules.data.internal.clipboard.ClipboardPageBase.getValue(ClipboardPageBase.java:1883)
               at com.pega.pegarules.data.internal.clipboard.ClipboardPageBase.getBoolean(ClipboardPageBase.java:1962)
               at com.pega.pegarules.data.internal.clipboard.ClipboardPageImpl.getBoolean(ClipboardPageImpl.java:484)
               at com.pega.pegarules.data.internal.clipboard.ClipboardPageBase.getBoolean(ClipboardPageBase.java:1951)
               at com.pega.pegarules.data.internal.clipboard.ClipboardPageImpl.getBoolean(ClipboardPageImpl.java:484)

Steps to Reproduce



Not Applicable.

Root Cause



 In DB2 SQLCODE=-668, SQLSTATE=57016 error means that the access to the table is restricted, this error may happen after the ALTER TABLE or DROP COLUMN statement.


Resolution



 Reorganize the table PR4_RULE in DB2 database to resolve the issue.
Suggest Edit

Published May 4, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community 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
Contact us