Highlighted
Absent Member.
Absent Member.
32 views

data exchange SD4.5 SP21

hello,
We have a data exchange utility which add/modifies users, organisations etc in the early hours each morning. It has been running for 6 months, but in the last few days we have noticed that some users and organisations are being duplicated. Import Mapping has the unique key on Search_Code and Organisation also has unique key, yet it is still duplicating. I have found a previous hit here but that was ealier level and and blocked, that is not the case here. recently we have upgraded to sp21 and in the days leading up to problem impemented change, release etc. Has anyone ever come across duplication before and as we have UNIQUE key set in import mapping how could it possibly happen??

cheers

peter
its a long way to the top if ya wanna
0 Likes
5 Replies
Highlighted
Absent Member.
Absent Member.

Re: data exchange SD4.5 SP21

further,

We have restored our dev from prod and rerun the dataloads and the problem did not happen. It is sporadic. Yet is has happened on a couple of days in prod. We running oracle 9.

cheers

peter
its a long way to the top if ya wanna
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: data exchange SD4.5 SP21

HI
If this actual for "Blocked" records, set one more UNIQUE files Blocked = NO.

Vasily
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: data exchange SD4.5 SP21

tks vasily, no it wasnt that. Have used business objects to list the clones (there were over 100 in person/org), and also had some Accounts being duplicated. Will have to drill a bit deeper.
its a long way to the top if ya wanna
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: data exchange SD4.5 SP21

Hi
Now your task remove duplicate from DB, if this Person by one Organization. If this Person belong different Organizations, then removing not possible, need use and Organization as UNIQUE.
So in data exchenge in one map you must mark 3 fields as UNIQUE - Searchcode, Organization and Blocked.

Vasily
0 Likes
Highlighted
Absent Member.
Absent Member.

Re: data exchange SD4.5 SP21

tks vasily,

I fixed all the workgroups/accounts and orgs, still errors with auditing, HP not interested, I am surprised that no one else has had this problem, after all there are several sites who seem to be using data exchange for similiar tasks.

cheers


peter
its a long way to the top if ya wanna
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.