cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Data Services: duplicate records in AL_Audit table

lvankets
Newcomer
0 Kudos

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 )

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member208402
Active Contributor
0 Kudos

issue might be with the SEQUENCE which generates sequence number.