Skip to Content
May 02, 2018 at 11:04 PM

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"
"STATUS", "RULEINFO") VALUES (119556, 25898, 1069, 0,