Hierarchy issues

[Former Member]

Hello, I am having problems with loading a hierarchy. I created a flat file which has the following fields:

Node Id      Info Object      Class      Link      Parent Id      Child Id      Next Id      Lang.      Text 

This flat file has about 8,000 rows ok.

It keep failing at a few records and giving me messages like:

NODEID xxxx starts an endless loop
AND

4,876 of 8,031 nodes in total not included in the hierarchy
AND

Node ID 00000341 not used in the hierarchy as a sibling node or child node

In my datasource i have 4 segments
1
2
3
4

1 has the following fields:
0HIENM
0HIER_VERS
0DATETO
0DATEFROM
0NORESTNODE
0STARTLEVEL
0NODEPOSIT
0ALEAFNODSP
0ALEAFNODCH

2 has the following:
0LANGU
0TXTSH
0TXTMD
0TXTLG

3 has the following:
NODEID
IOBJNM
NODENAME
TLEVEL
LINK
PARENTID
CHILDID
NEXTID
DATEFROM
DATETO
INTERVL
ZCO_TX

4 has the following:
LANGU
NODENAME
TXTSH
TXTMD
TXTLG

and in my transfer rules I only have the following fields mapped:
0HIENM
0HIER_VERS

and for NODE in transfer rules I have the following fields mapped:
0HIER_NODE
ZCO_TX

My question is where do I tell my transfer rules to map the fields in my FLAT file?  or may be the system is now looking at all the 8,000 records.  if so then where do i tell it to look?  I think that is where my problem is. please let me know what I should do.

I have already looked on SDN and found many threads stating these messages but could not find the solution.

Thanks.

[Former Member · Accepted solution]

Hi Venkat,

For Hierarchy you don't tell which field need to map with which field its totally like you need to give file in format in which hierarchy can accept. So instead of mapping fields you just need to specify the InfoObject in Transformation.

check below link for loading hierarchy from flat file.

http://scn.sap.com/docs/DOC-12010

Regards,

Ganesh

[umashankar_poojar]

Hi Venkat,

       For me it looks like issue with data.

NODEID xxxx starts an endless loop

                           some NODEID might not be linked to other and kept not linked

4,876 of 8,031 nodes in total not included in the hierarchy

                              Find the number 4876/8031 in your file and try to understand what is the issue there

Node ID 00000341 not used in the hierarchy as a sibling node or child node

                            Node 341 is left alone, means as it says, neither it is parent nor a child in hierarchy. Left unassigned.

Check on these and load again.

Hope it helps!

Umashankar

[Former Member]

Uma, thanks for your feedback.  I also think it is with the data but data looks just fine. i have many 0HIERNODE rows and most of them but a couple show eveyrthing good as green but it is only giving me the error message for them.

NODEID00003875 starts an endless loop

when I look at the long text, this is what it says:

Diagnosis

A continuous loop is started by the parent ID, child ID or next ID for the node with the ID 00003875. This means that the node refers indirectly or directly to itself.

Example
The node ID and the parent ID are identical.

Procedure

Check the parent ID, child ID and next ID for the node whose IDs are in the parent ID, child ID, or next ID for the node with the ID 00003875.

If this does not help, check the entire subtree of the parent node

with ID 00003725 to see if it contains nodes in which either the ChildID

or the NextID are identical to 00003875.

ok so this is what I have in NODEID: 00003875 (error one):

Node Id      Info Object      Class      Link        Parent Id      Child Id      Next Id      Lang.      Text 

3875          0HIER_NODE  CO_MIS  Nothing     1               3876         6875    

this is what I have for NODEID: 00003725 (Good One):

Node Id      Info Object      Class      Link        Parent Id      Child Id      Next Id      Lang.      Text 

3725          0HIER_NODE  CO_IIS   Nothing      1              3726          3875

This looks normal data to me.

Please let me know.

Thanks.

[Former Member]

Hello, can some one tell me what does the system mean by "4,876 of 8,031 nodes in total not included in the hierarchy"

Is it mean that the first 4876 of 8031 rows were skipped?

How can I find out which 4876 rows got skipped? i think that is the root of my problem. please help.

[Former Member]

Hi Venkat,

Only possible reason to skip the records is if Keys gets repeated. Can you able to find those nodes which are got skipped so comparison of loaded and not loaded nodes will give some idea about issue.

Regards,

Ganesh