Skip to Content
0

SAP Data Services: duplicate records in AL_Audit table

May 02 at 11:04 PM

39

avatar image
Former Member

Since last night all jobs in 1 repositories do end in error. Seems BODS is inserting duplicate records in an audit table. Jobs in a second repository run fine. We are not aware of any changes that can result in this kind of error. Any idea on what can be the rootcause? How to solve?

<ORA-00001: unique constraint (UNKNOWN.obj#=2136462)
violated>. The SQL submitted is <INSERT INTO "AL_AUDIT"
("OBJECT_KEY", "HISTORY_KEY", "DF_LANG_KEY",
"STATUS", "RULEINFO") VALUES (119556, 25898, 1069, 0, 
NULL )
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ravi kiran Pagidi May 14 at 12:38 PM
0

issue might be with the SEQUENCE which generates sequence number.

Share
10 |10000 characters needed characters left characters exceeded