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

Lock and primary key constraint violation errors

SA-44806

Summary



Lock errors and primary key constraint violation errors in the Autonomic Event Services (AES) system logs. This results in large log files and subsequently the system does not work correctly.


Error Messages



104 [WebContainer : 8] [STANDARD] [AES:07.14] (Line.PegaAES_Data_Alert.Action) ERROR your_node|your_ip|SOAP|PegaAES|Events|logAlert|A9FFE283AB6CBD6877F049869A5021DE6 - obj-save failed.
com.pega.pegarules.pub.database.DuplicateKeyException: Database-Saver-Insertfail
DatabaseException caused by prior exception: com.ibm.websphere.ce.cm.DuplicateKeyException: Violation of PRIMARY KEY constraint 'PEGAAM_ALERT_PK'. Cannot insert duplicate key in object 'dbo.pegaam_alert'. The duplicate key value is (PEGAAES-DATA-ALERT 20170914T134101.263 GMT!41FBB9B0F0281094E929905EA9EE5B36!1564).



Steps to Reproduce



Unknown


Root Cause



A software use or operation error The prlogging file contained references to the AES SOAP appenders. The Predictive Diagnostic Cloud (PDC) URL landing page also specified the AES server and enabled the dynamic appenders. Hence, the alerts were sent twice which resulted in duplicate key violation.


Resolution



As a local-change, remove the appender references from the prlogging file and restart the monitored nodes.

Refer to:

https://pdn.pega.com/troubleshooting-aes-717-and-aes-72-connectivity-performance-and-reporting-problems/troubleshooting

Suggest Edit

Published February 17, 2018 - Updated October 8, 2020

Did you find this content helpful? Yes No

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.

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