Support Article
UpdateImportantMessages agent exception
SA-89790
Summary
The system displays the UpdateImportantMessages agent to be in an Exception state.
Error Messages
Property 'StatusOnWeb' is not a Database Column.
Steps to Reproduce
Not Applicable
Root Cause
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.
Resolution
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.
Tags:
Published March 25, 2020 - 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.