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

[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.