Skip to Content

unique constraint violated exception: unique constraint violated

Jun 16, 2017 at 02:42 PM


avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers