Insert DepartmentHasADSGroup via process chain results in a "Violation of PRIMARY KEY constraint ... Cannot insert duplicate key in object" - Error

What version are you using? Can you share the parameters of the job doing the insert?

Hi Markus,

it is an HandleObjectComponent - Insert Step with two params: UID_ADSGroup and UID_Department.

Version 9.0

Can't post images here...

Hi,

You need to use CallMethod - AssignDirect.

HTH, B.

Hi Barry,

sounds promising. I'll try that and report here if it worked.

Regards,

Alexander

Hi Barry,

i tried to follow your suggestion applying the AssignDirect() - Method on an DepartmentHasADSGroup - Assignment with Xorigin = 2.

First i went to the Objectbrowser, selected the assignment, navigated to the Methods tab in the properties an ran the AssignDirect() - Method on it. In the result section it tells me: "Method successfully finished." but when i check Xorigin afterwards it is still set to 2 though i expected to see now a 3 in Xorigin.

Did i something wrong?

How to do it right?

Regards,

Alexander

Hi Alexander,

Hmmm looks like when you call the AssignDirect method in OB it works as you say but you get no option to 'save' the object ..... and that's the issue .... after calling the method you have to save the object.  So in a script you would have these lines:

                                                            baseObjectN.CallMethod("AssignDirect")

                                                            baseObjectN.Save(Session)

In a process you would use the HandleObjectComponent - CallMethod process task and in the parameters enable Save with Value = True

HTH, Barry.

Hi Alexander,

Hmmm looks like when you call the AssignDirect method in OB it works as you say but you get no option to 'save' the object ..... and that's the issue .... after calling the method you have to save the object.  So in a script you would have these lines:

                                                            baseObjectN.CallMethod("AssignDirect")

                                                            baseObjectN.Save(Session)

In a process you would use the HandleObjectComponent - CallMethod process task and in the parameters enable Save with Value = True

HTH, Barry.

Hi Barry,

activating the save paramter in the Call method process task did it for me.

Thank you very much for the support!

Regards,

Alexander