Error occurred while loading 0cust_sales hierarchy

[#1]

Hi,

Could you please help me in resolving the below error occurred while loading hierarchy data to 0CUST_SALES hierarchy, please see the below screen shots:

Regards,

Anusha

[Loed]

Hi Anusha,

In the UPDATE tab of the DTP of your hierarchy, just tick the HANDLE DUPLICATE RECORD KEYS..

Perhaps this will solve your problem..

Regards,

Loed

[Former Member]

Hi Loed,

We are working on SAP BW 3.0B system, we do not have any DTPs used. Update is happening via info package. The processing type for updating data is ALE inbox and info object.

Regards,

Anusha A

[RamanKorrapati]

Hi Anusha

in 3.x, processing tab, if you select only PSA then you may get option like "ignore double data records".

But you choose ALE inbox, so you won't get that option as i guess.

you need correct the source data and then reload.

Thanks

[Loed]

Hi Anusha,

Perhaps there is also a HANDLE DUPLICATE RECORDS setting in PSA..Try the suggestion of Ramanjaneyulu..

Regards,

Loed

[Former Member]

Hi Ramanjaneyulu,

Please find the below screen shot of info package:

I don't find any option to choose PSA.

I have no where found an option to handle the duplicate records.

And also as per my understanding, one of the possible ways to resolve this issue is to contact the person who has uploaded the hierarchy data into R/3 system. But, I am left with no clue to find out who is the user (last changed by) who has uploaded this. Please suggest me on this.

Regards,

Anusha

[Former Member]

Dear Anusha,
can you create a new infopackage and see if the option of choosing only PSA is available to you?
Also as mentioned above if the source is flat file source system, then loading has been done from the BI system itself  either loading the flat file from application server or local workstation. just cross check once.
Thanks!

[RamanKorrapati]

i already said about that option you won't find.

if you use psa then only above option will be visible.

Above issue is not belongs to you.

From error notify the all error nodes and customer sales numbers.

inform to ECC/Source team to rectify the all mentioned nodes/customer sales.

Once they did the correction, you can reload into bw.

[Former Member]

Thank you, will check with them.

Regards,

Anusha