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
Published February 17, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.