Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Modified alert is not saved in system after modifying the alert

SA-63202

Summary



Modified alert is not saved in the system after modifying an alert message in the 'Alerts and Messages' widget.


Error Messages



Not Applicable.


Steps to Reproduce

  1. Launch the portal
  2. Create an alert in the 'Alert and Messages' section
  3. Modify the created alert and check the system


Root Cause



A defect in Pegasystems’ code or rules.
An issue in the upgrade script of MS SQL. The PCA_ALERTS table in the script has all column names in uppercase letters. As MS SQL columns are case sensitive, the queries fail.



Resolution

Perform the following local-change:

Update the below columns to Camel case:
  • pzInsKey
  • pzPVStream
  • pxObjClass
  • pxInsName
  • pxSaveDateTime
  • pxCommitDateTime
  • pxCreateDateTime
  • pxUpdateDateTime
  • pxCreateOperator
  • pxCreateOpName
  • pxCreateSystemID
  • pxUpdateDateTime
  • pxUpdateOperator
  • pxUpdateOpName
  • pxUpdateSystemID
  • pyLabel
  • pyID
  • pxCoverInsKey
  • pxCoveredCount
  • pxCoveredCountOpen

 

Published August 24, 2018 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us