Hierarchy Data Load Issue

[Former Member]

Hi All,

At the time when i was loading data from source to BI for Hierarchy one of the data packet having invaid character

Error - The node name for ID 00000217 contains invalid characters

In case of PSA we can edit that record and load it again to target but we are loading hierarchy we asre doing it using IDOC ALE.

We already set Infopackage with following selection -

Under processing tab we selected  - ALE inbox and infoobject.

Under update tab - Full load.

As this IP is part of process chain so that chain also got failed due to invalid char issue.

Can any one tell how to correct those invalid char and load it again to target as i am not able to see any PSA type of thing for correcting invalid chars.

Regards

Ankit

[Former Member · Accepted solution]

Hi,

One way to correct the invalid character as discussed above is in ECC by understanding the pattern.

Another way would be to apply a formula in the transformation at the field level which will checl all invalid characters ( including lower/upeer case issue, special characters) etc. This will reislve your issue and PC will not fail then again.

Thanks and Regards,

Shyam Alok

[Former Member · Accepted solution]

Hi Ankit,

     Try this one to resolve your issue.

     go to RSA3 (in source system)-->enter datasource name of hierarchy --> enter hierarchy name (HIENM) for which you are getting an error and press extraction

after that go to alv grid to display data and select hierarchy node in segment

filter the data by ID for which you are getting error like 205, 206 etc. and check that node contains invalid text or not. if it contain invalid text then you can allow those char in RSKC.

Hope it will help.

Regards,

Om Ambulker

[Former Member · Accepted solution]

Thx Om