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

  1. 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: 
  1. Delete the Data-Admin-DB-Table records corresponding to PA_CTI_CALL and PA_COMMUNICATION_TYPES tables.
  2. Restart the Application Server.

Published November 18, 2016 - Updated November 19, 2016


100% found this useful

Have a question? Get answers now.

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