Question Re: Error while creating Hierarchies using flat file in Technology Q&A

Error while creating Hierarchies using flat file

Former Member — Tue, 23 Sep 2014 14:01:36 GMT

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.

Re: Error while creating Hierarchies using flat file

RamanKorrapati — Tue, 23 Sep 2014 14:08:24 GMT

Hi,

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

Thanks

Re: Error while creating Hierarchies using flat file

Former Member — Wed, 24 Sep 2014 04:30:45 GMT

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.

Re: Error while creating Hierarchies using flat file

Former Member — Wed, 24 Sep 2014 05:34:42 GMT

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

Re: Error while creating Hierarchies using flat file

Former Member — Wed, 24 Sep 2014 05:42:27 GMT

sorry forgot to attach the screenshot

Re: Error while creating Hierarchies using flat file

Former Member — Wed, 24 Sep 2014 05:48:02 GMT

thanks Dinesh. I did the same again but not working

Re: Error while creating Hierarchies using flat file

RamanKorrapati — Wed, 24 Sep 2014 06:03:08 GMT

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

Re: Error while creating Hierarchies using flat file

Former Member — Wed, 24 Sep 2014 06:48:43 GMT

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.

Re: Error while creating Hierarchies using flat file

Former Member — Wed, 24 Sep 2014 07:01:17 GMT

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

Re: Error while creating Hierarchies using flat file

RamanKorrapati — Wed, 24 Sep 2014 09:15:53 GMT

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

Re: Error while creating Hierarchies using flat file

Former Member — Wed, 29 Oct 2014 10:47:48 GMT

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

Re: Error while creating Hierarchies using flat file

benshee — Tue, 25 Nov 2014 10:49:14 GMT

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

Re: Error while creating Hierarchies using flat file

priya_ramani — Sat, 14 Feb 2015 14:08:47 GMT

This message was moderated.

Re: Error while creating Hierarchies using flat file

Former Member — Thu, 11 Jun 2015 10:05:59 GMT

Thanks, worked perfect for me.