Unable to MERGE-Err Msg "MDM Server Failed to Merge the Selected Records"

[Former Member]

Hi Friends,

I am using a Match Strategy in the Workflow. In the START Process of the workflow I CHECK OUT the records. In the step MATCH / MERGE when I try to MERGE similar records I get the Error Message "MDM Server Failed to Merge the Selected Records".

But the same step works fine when I dont CHECK OUT (CHECK OUT = NO) the records in the START STEP. But this would not be the right way to do it, as the incoming duplicate records would be visible in the Data Manager by other users even before it is merged.

Your inputs would be greatly appreciated to tackle this problem.

Thanks.

[Former Member]

Hi Eswar

can you please give the workflow steps with parameters. Merging of records is manual or part of workflow?

regards

Ravi

[Former Member]

Hi Ravi,

The workflow steps are as follows: (I am on MDM 5.5 and SP 6)

Start (Check Out) -

---

> Process -

---

> Validate -

---

> Match (Manual Merge) -

---

> Approve----

---

> Stop (Check In)

The Match and Merge step is a Manual step in the Workflow.

I Check out the records when i start the Workflow and Once the entire process is complete I check in the record. What is happening is that it does not allow me to Merge the records and I get the Error message.

If i dont Check out the Incoming records and run the workflow it Merges fine. But this would not be correct as the Incoming records(whihc could be duplicates) would be visible in the system until they are merged.

Your Input woould be greatly appreciated.

Thanks in Advance.

[Former Member]

Hi,

You cannot run the Matching Strategy on the Checked out records because once you checked you the records it would not be incorrect to say that records are not present in the repository thats why Check out is not working in your case.

Try to handle the duplicates in Import Manager itself by setting appropriate Matching Keys and actions.

Regards,

Jitesh Talreja

[Former Member]

Hi Jitesh,

Thanks for your inputs.

This solution will not work. We need to make use of the feature in workflow.

Thanks.

[Former Member]

Hi Eshwar,

Let me explain why the matching/merging dont work on check out records?

If you know the concept of dirty data or corrupt data in which two or more than two users access same record from the central database meanwhile one did the changes and save it again, but the other is still working with the previous record. Due to this this corrupt record goes to two different users and generate inconsistencies in two different departments of an organization.

Now why i am talking about it because Checkout record option is one which is used to prevent such kind of inconsistencies; if two or more users are accessing a record from DM and having join check out permission, then all users can work on local copies of record and then final record with the help of Admin goes to central database. It means user can modify these records in between the processing using their local copies and then finally reflected in central database. Now if you are using checkout records, it means any other user which have join permissions can modify any record which you may consider duplicate. Thats why DM does not allow to do so.

Hope it will clear the confusion.

BR,

Alok