Initial Load error due duplicate attributes

[Former Member]

Hi Gurus,

I am facing below error during initial load of one our system with further investigation & pointers from SAP , we have found that every privileges uploaded from back-end system contains attributes with duplicate values

Initial Load Error screen shot.

Query result.

Query result detail.

Pherphas , Can some one guide best approach to clear duplicate enteries.

Regards,

Ali.

[Former Member]

Hi,

Did this solve your problem?

Regards,

Ole K.

[Former Member]

Hi Ole,

Yes indeed apart from your query , I have also run below query from Note : 2030931

delete from mxi_values where changenumber in

(select max(changenumber) from mxi_values group by mskey,attr_id,searchvalue,bChecksum having count(searchvalue)>1);

I was planning to perform complete initial load again that is why cant able to respond to you.

Many Thanks

Ali.