/scripts/ahub.form.attachments.js
0

Found duplicate primary key SAP BW 7.4 on Hana

Feb 06, 2017 at 12:58 PM

96

avatar image
Former Member

the result from a uniqueChecker:

6] TableConsistencyCheck with check option = 'CHECK_PRIMARY_KEY' failed for "SAPABAP1"."/BI0/SBILL_NUM" (part 0: err=5101, Found duplicate primary key 0050746456 at udiv 14727658 with rowid 14727658 for SAPABAP1:/BI0/SBILL_NUM which is a duplicate of key at udiv 14719952, value ids 14457, 14457 for SAPABAP1:/BI0/SBILL_NUM (t 2817)

As you can see there is a duplicated value on primary key field.

Please, can anyone tell me how is this posible and if there is a solution for this?

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

2 Answers

avatar image
Former Member Feb 06, 2017 at 02:34 PM
0

Hi Tatyana,

Please refer SAP NOTE - 2334576.

Thanks

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member
Feb 08, 2017 at 08:38 AM
0

Also in general make sure there is no manipulation with indexes on BW-generated tables at HANA DB level, this is not supported (Note 2259872)

Share
10 |10000 characters needed characters left characters exceeded
Skip to Content