Error while creating Hierarchies using flat file

[Former Member]

Hi,

I am trying to load a sample hierarchies using flat file (attached). I am facing the below error while loading. please let me know how to proceed.

I am using the method mentioned in http://scn.sap.com/docs/DOC-24996 . Thanks.

HIER TEST SAMPLE.txt.zip

[priya_ramani]

This message was moderated.

[Former Member]

Hi All,

i too getting dump while creating hierarchy can any one please give me suggestions how to resolve this.

flat file format:

transformations of hierarchical structure:

while triggering the info package getting the error.

Regards,

Somanath BSG

[benshee]

Hi, you are missing Header in Infopackage on the Extraction tab. Create new Header and than try to exetute Infopackage again.

[Former Member]

Thanks, worked perfect for me.

[Former Member]

I believe issue has something to do with transformation. we are loading zcountry object here. info object is mapped directly.

[RamanKorrapati]

Hi,

Why you mapped fiscyear?

Where is data in flat file for fisc year?

Remove that mapping and try to load data.

Even your data source doesn't have texts info objects also.

We need to use the flat  file structure based on data source.

Text data loaded thru text data source.

Thanks

[RamanKorrapati]

Hi,

Can you share Ltxt from details from your error screen shot.

Thanks

[Former Member]

Hi Ram,

here is the long text of error message:

'  ' is not a valid InfoObject name

Message no. RH615

Diagnosis

The name '  ' is not a valid InfoObject name.

System Response

Processing is terminated.

Procedure

Check the transformation rules and the data from the source and make sure
that an invalid InfoObject name is not created.

---------------------------------------------------------------------------------------------------------------------------

Error occurred in record number 1 and node ID 00000000

Message no. RH604

Diagnosis

The previous error (for example, the previous error in the log) occurred in
the hierarchy data for record number 1 and node ID 00000000.

System Response

Processing has been terminated.

Procedure

Look at the previous error message and check the data record with record
number 1 and node ID 00000000 in the previous object (for example, PSA of the
DataSource) or in the simulation of the data transfer process.

[Former Member]

Hi Ravi,

       Mostly your xls format is wrong. The column in which the  info object has to be maintained  is empty in your xls , as per the  error message.

What I would suggest you is from the Hierarchy data source generate the sample file and use the same as a template and construct your xls file.

Thanks & Regards

  A.Dinesh

[Former Member]

sorry forgot to attach the screenshot

[Former Member]

thanks Dinesh. I did the same again but not working

[RamanKorrapati]

Hi Ravi,

Problem is your flat file data.

Please delete the existing file and create a new one.

Enter data carefully, in one of your data there is empty space at end of the data.

Eample - NODEID - its 8 digit length, if you enter 1 and use spaces up to 9 digits then that will be an issue. So enter 1 and use back space. delete that empty space.

Like that way you need to use exact length for defined info object at flat file.

Thanks

[Former Member]

Problem is not the flat file. I have tried to load the example file created from data source it self without any changes but facing same issue.