cancel
Showing results for 
Search instead for 
Did you mean: 

unique constraint violated exception: unique constraint violated

akshinde
Participant
0 Kudos

Hi All I am getting following error while inserting large no of records (187000)into ADSO Direct update / Standard ADSO comprising 12 keys as composite key

SQL error: "301". SQL message: "unique constraint violated while inserting data into Direct Update/Standard ADSO through AMDP

Error message is

"SAPABAP1"."ZFXX_VOLUME_REPORTING=>METH_INSERT_BMS_PIVOT": line 27 col 1 (at pos 903): [301] (range 3) unique constraint violated exception: unique constraint violated: TrexUpdate failed on table 'SAPABAP1:/BIC/AG9SC26ADU2' with error: unique constraint violation in self check for table

I am able to create similar table with same constraints in my schema and there I am able to successfully insert large no of records 18700 however unable to insert in ADSO tables.

I have BW ON HANA 7.5 and HANA is on SPS10.

Accepted Solutions (0)

Answers (0)