Service Desk Practitioners Forum
cancel

Parent Child Relationship

SOLVED
Go to solution
Highlighted
Michael Lutfi
Outstanding Contributor.

Parent Child Relationship

Hello All,

Can anyone please justify why I get the error:
Cannot find parent Column SerialNumber_R

[DSN]
NAME=Server
USR=
PWD=

[SYSTEM]
LOG=TRUE
XML=TRUE
LOG_FILE=Server.log
XML_OUTPUT_FILE=Server.xml
APPLICATION_NAME=Server

[CLASSES]
NAME=Rack,Server


[Rack]
SOURCE=RACK
ATT=[Name_R],[Model_R],[Size_R],[SerialNumber_R],[Location]
COLUMNS=[Name_R],[Model_R],[Size_R],[SerialNumber_R],[Location]
LOADTABLE=TRUE
Maxrecords=5

[Server]
SOURCE=SYSTEMS
PARENT=Rack
PARENT_RELATION=[SerialNumber_SR]=[SerialNumber_R]
--[SerialNumber_R]
ATT=[SerialNumber_SR],[Name_S],[Model_S],[SerialNumber_S],[Size_S],[OS],[Weight],[Heat],[Power],[Application],[Support]
COLUMNS=[SerialNumber_SR],[Name_S],[Model_S],[SerialNumber_S],[Size_S],[OS],[Weight],[Heat],[Power],[Application],[Support]
LOADTABLE=TRUE
2 REPLIES
Mariana Flinta
Super Contributor.
Solution

Re: Parent Child Relationship

Hi Michael,

I have the same problem when trying to import data to SD. So, I avoid the error deleting the relation from the ini file and giving the relation in the import mapping. There fill the reference to search code.

I'm new on this. Hope can help my answer.

Good luck.
Mariana
There's nothing impossible!
Mike Bush
Acclaimed Contributor.

Re: Parent Child Relationship

Don't PARENT and PARENT_RELATION have to come AFTER the COLUMNS?

And I always use all UPPER CASE for the ATTRIBUTE names to avoid problems with case sensitivity in the import mapping.