Hierarchy issues

612 Views

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.