Support Article
pzPersistSystemInfo Throwing Error
SA-30528
Summary
In a new install of Pega 7.2 with Pega CS 7.21, user is seeing NonexistentTableException in the logs regarding pzPersistSystemInfo activity. It seems to be complaining about the PA_CTI_CALL and PA_COMMUNICATION_TYPES tables to be missing.
Error Messages
2016-10-19 00:00:27,304 [.PRPCWorkManager : 3] [ STANDARD] [ PegaRULES:07.10] ( internal.access.SQLGenerator) ERROR - No columns were found for table DATA.PA_CTI_CALL
2016-10-19 00:00:27,320 [.PRPCWorkManager : 3] [ STANDARD] [ PegaRULES:07.10] (nal.state.DatabaseTableHandler) ERROR - Database exception while retrieving the database table information for class PegaApp-CTI-Call
com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable DATA.pa_cti_call PegaDATA
From: (B0ADCDDD3B9E19CA4B14694002AB1F0A3)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:618)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:468)
2016-10-19 00:00:28,492 [.PRPCWorkManager : 3] [ STANDARD] [ PegaRULES:07.10] ( internal.access.SQLGenerator) ERROR - No columns were found for table DATA.PA_COMMUNICATION_TYPES
2016-10-19 00:00:28,508 [.PRPCWorkManager : 3] [ STANDARD] [ PegaRULES:07.10] (nal.state.DatabaseTableHandler) ERROR - Database exception while retrieving the database table information for class PegaApp-Interface-CommunicationType
com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable DATA.pa_communication_types PegaDATA
From: (B0ADCDDD3B9E19CA4B14694002AB1F0A3)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupColumnInfo(TableInformationMapImpl.java:618)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:468)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:352)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.get(TableInformationMapImpl.java:314)
at com.pega.pegarules.monitor.internal.state.DatabaseTableHandler.persistAllCurrentComponents(DatabaseTableHandler.java:71)
at com.pega.pegarules.monitor.internal.state.AbstractCategoryHandler.persistAllCurrentComponents(AbstractCategoryHandler.java:64)
at com.pega.pegarules.monitor.internal.state.SnapshotPersistenceStrategy.persistClusterState(SnapshotPersistenceStrategy.java:52)
Steps to Reproduce
- Restart application server after a new install of Pega 7.2 with Pega CS 7.21.
Root Cause
A defect in Pegasystems’ code or rules is identified as root cause of the issue. The classes mapped to tables PA_CTI_CALL and PA_COMMUNICATION_TYPES are no longer valid in Pega CS 7.21. PA_CTI_CALL table has been replaced with PFW_CS_INTERACTION table and PA_COMMUNICATION_TYPES table has been merged with PA_COMMUNICATION_OPTIONS table.
Resolution
Perform the following local-change:
- Delete the Data-Admin-DB-Table records corresponding to PA_CTI_CALL and PA_COMMUNICATION_TYPES tables.
- Restart the Application Server.
Published November 20, 2016 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.