UpdateImportantMessages agent exception
The system displays the UpdateImportantMessages agent to be in an Exception state.
Property 'StatusOnWeb' is not a Database Column.
Steps to Reproduce
This issue occurred due to a missed Installation step that was required for the use of Important Customer Messages functionality, where the sample data for PegaCSHC was not imported.
Hence, the Data-ImportantMessages class was mapped to pr_data instead of the important_messages table and the important_messages table was not present in the database. The pr_data does not have an exposed column for StatusOnWeb. Therefore the error displayed.
Perform the following local-change:
- If the Important Customer Messages functionality is not used in the application, disable the agent through the Agent Schedule. This prevents the agent from running and encountering the error.
- If the Important Customer Messages functionality is used, utilize the PegaCSHC sample data JAR file to create the important_messages table in the database and map the Data-ImportantMessages class to it.
100% found this useful