Service Desk Practitioners Forum
cancel

Data Exchange loading relationships

Highlighted
dmann
Super Contributor.

Data Exchange loading relationships

OVSD 4.5 SP18

I have the following CI loads:
CI server
CI job
CI schedule
These server, job, schedule, load fine.

If I load the realted data,

servers runs jobs
schedule contain jobs

These load fine, also. That is, they load without error.

If I only load one relationship, data loads as expexted.

Independent loads
Sched1 Contains Job1
Sched2 Contains Job2
Sched3 Contains Job3
Sched4 Contains Job4

server1 runs job1
server1 runs job2
server1 runs job3
server1 runs job4

However, when I load both relationships, the last one over writes the relationship type.

Sequential Loads
Sched1 runs Job1
Sched2 runs Job2
Sched3 runs Job3
Sched4 runs Job4

server1 runs job1
server1 runs job2
server1 runs job3
server1 runs job4

The last load will change the related type.


I think I am missing something easy, but I have not found it.
Any ideas would be greatly appreciated.

1 REPLY
George M. Meneg
Acclaimed Contributor.

Re: Data Exchange loading relationships

Hello Bill,

In your CI Relation import mapping, both CI From and CI To must be used as unique keys.
menes fhtagn