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

[Former Member · Accepted solution]

Hi,

I found that issue can be resolved with the help of the note (399900 - Hierarchy in 0CUST_SALES: various problems).

Regards,

Anusha A

[RamanKorrapati · Accepted solution]

Hi Anusha,

Thanks for sharing the note.

Please close the thread by choosing your own reply as correct answer.That would be helpful to future refence.

Thanks

[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

[RamanKorrapati]

Seems like your source system or flat file have lot of duplicate records under multiple nodes. mean same customer might be assigned to multiple nodes.

So please verify source data and change accordingly.

Cross check about nodes - 9902ATUS0000013355/64/48/43.

Same customer can be stored under the multiple nodes. So please verify your source data.

if your loading from source then inform source team and ask the to change value under nodes.

[Former Member]

Hi Anusha

Are you doing this hierarchy via flat file? If Yes, check for the node mentioned in the file your loading to see if its duplicated. There seems to be something wrong with the hierarchy file provided

Thanks

Abhishek Shanbhogue