The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Import via Data Exchange fails

Highlighted
MsE
Occasional Contributor

Import via Data Exchange fails

Hi,
we're running Service Desk 4.5 SP20 on a Windows 2003 Enterprise Edition server. I'm trying to import data from Microsoft SMS 2.0 into Service Desk using two data exchange tasks.
The export turned out quite well in my eyes because I get an XML file with all the computers of our SMS site, showing correct data and correct parent-child relations between the classes.
When I try to import the data from the XML file into SD I get errors like these:

Following problems encountered while loading entities:
======================================================
Processing SITE (id = 1)
Updating existing instance of SITE
While processing SITE (id = 1):
There are no changes to save.
Processing PU (id = 2)
Updating existing instance of PU
While processing PU (id = 2):
There are no changes to save.
Processing OS (id = 3)
Updating existing instance of OS
While processing OS (id = 3):
There are no changes to save.
Processing HARDDISK (id = 4)
Updating existing instance of HARDDISK
Processing HARDDISK (id = 5)
Updating existing instance of HARDDISK
Processing CDROM (id = 6)
Updating existing instance of CDROM
While processing CDROM (id = 6):
There are no changes to save.
Processing PU (id = 7)
Inserting new instance of PU
While processing PU (id = 7):
com.hp.ifc.ext.ExternalException: A configuration item with this search code already exists. For a unique configuration item you must enter a unique search code.
at com/hp/ifc/ext/AppExternalAccess.getMessage
[...]

I get a similar message for any of the other IDs.
Looks like there already are some configuration items but I can't see one single CI in SD. I have even deleted the DB and created a new one to make sure I'm using an empty one but that didn't help either.
After all theses messages the log says:

Following problems encountered while loading relations:
======================================================
Adjusting relation PARENT between PU and SITE
The relation PARENT between PU and SITE already exists.
Adjusting relation PARENT between OS and PU
The relation PARENT between OS and PU already exists.
Adjusting relation PARENT between HARDDISK and PU
The relation PARENT between HARDDISK and PU already exists.
Adjusting relation PARENT between HARDDISK and PU
The relation PARENT between HARDDISK and PU already exists.
Adjusting relation PARENT between CDROM and PU
The relation PARENT between CDROM and PU already exists.
While processing relation between PU (id = 7) and SITE (id = 1):
com.hp.ifc.ext.ExternalException: Parent PU does not exist.
at com/hp/ifc/ext/AppRelationLoad.processRelation
[...]

This is weird because saying "Parent PU does not exist" while processing a relation between PU and SITE would mean that PU is the parent of SITE which is not correct. My ini file and the XML file show the correct relations though.
So I think the import mapping might be responsible for the failing import. As I said before I'm using the standard sms20_import mapping which looks correct to me.

Any ideas? Any help is much appreciated.
//Add this to "OnDomLoad" event