Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

Duplicate key violation when inserting into in aeprocesslogdata in ActiveVOS
Problem Description
In ActiveVOS, there is a duplicate key violation when inserting into in aeprocesslogdata.

There is an error message in your log file as follows:

C​annot insert duplicate key in object dbo.aeprocesslogdata ​​

KB619384.PNG

Cause
​This issue occurs when in one case where records are deleted from aeprocesslogdata by date only instead of by processid resulting in a corrupted ActivevOS engine.

When the ActivevOS engine attempts to insert a record into a table, and the unique key it is using is not unique, it means that the ActiveVOS engine is corrupt. The server is not consistent with itself. This should never happen and is a serious issue.

This is not the example where completed processes are selected by DATE and then deleted. The issue is when dated is deleted by date only.

Solution
​To resolve this issue, do not delete from the aeprocesslog data table by date. Any deletions, if needed, should be done by processid.
More Information
Applies To
Product: Active VOS
Problem Type: Crash/Hang; Stability
User Type: Developer; Administrator
Project Phase: Implement
Product Version:
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:9/15/2020 4:53 AMID:619384
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)