Support Article
Pxobjclass column too small in table pc_work_notification
SA-39119
Summary
Repeated exceptions appear in the PegaRULES logfile indicating the Pega engine cannot read or list items from the PC_WORK_NOTIFICATION table because the pxObjClass column is too small. This effects cases in the following classes:
- PegaEvent-Notification-Gadget
- PegaEvent-Notification-Email
Error Messages
2017-06-05 22:00:01,730 [ PegaRULES-Batch-5] [ STANDARD] [ ] [ PegaRULES:07.10] (anner.UnpopulatedColumnScanner) WARN - Unable to process class 'PegaEvent-Notification-Gadget'
com.pega.pegarules.pub.database.DatabaseException: There was a problem getting a list: code: -302 SQLState: 22001 Message: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.14.137
DatabaseException caused by prior exception: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.14.137
| SQL Code: -302 | SQL State: 22001
From: (B66F3008E286C813E58032FBF234516FE)
SQL: SELECT pzInsKey FROM DATA.pc_work_notification WHERE pxObjClass = ? AND pxApplication is null AND pxCommitDateTime < ?
Caused by SQL Problems.
Problem #1, SQLState 22001, Error code -302: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.14.137
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:262)
at com.pega.pegarules.data.internal.access.ListSpec.list(ListSpec.java:491)
at com.pega.pegarules.data.internal.access.DBQueryExecutor.executeRDB(DBQueryExecutor.java:114)
Steps to Reproduce
Create notification items in Pega 7.2.2.
Root Cause
A defect in Pegasystems’ code or rules:
The column PXOBJCLASS was erroneously defined as VARCHAR(24) in this table.
Resolution
Perform the following local-change:
Change the definition of the column to VARCHAR(96) in the PC_WORK_NOTIFICATION table.
Published July 20, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.