Skip to Content
avatar image
Former Member

SAP Data Services: duplicate records in AL_Audit table

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 )
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 14 at 12:38 PM

    issue might be with the SEQUENCE which generates sequence number.

    Add comment
    10|10000 characters needed characters exceeded