<div dir="ltr">Hi,<div><br></div><div>I have reconciliation task in scriptedSQL connector, it creates users in midpoint.  First of all, users are created with this task. But when I run task twice or more, it gives an error like below for all users:</div><div><br></div><div><font size="1">Error processing focus(user:null(TR45187127836)<wbr>): constraint violation: Found conflicting existing object with property {.../common/common-3}name = PP({.../common/common-3}name):<wbr>[PPV(PolyString:TR45187127836, origin: INBOUND:resource:ef2bc59b-<wbr>76e0-48e2-86d6-3d4f02d420db(<wbr>TirsanScriptedSQLResource))]: user:96dd9828-e16f-4a7c-bebe-<wbr>74c4d184b340(TR45187127836)</font><br></div><div><font size="1"><br></font></div><div>Correlation rule has PolyStringNorm such as:</div><div><br></div><div><div><font size="1"><synchronization></font></div><div><font size="1">      <objectSynchronization></font></div><div><font size="1">         <objectClass>ri:AccountObjectClass</objectClass></font></div><div><font size="1">         <kind>account</kind></font></div><div><font size="1">         <intent>default</intent></font></div><div><font size="1">         <enabled>true</enabled></font></div><div><font size="1">         <correlation></font></div><div><font size="1">            <q:description></font></div><div><font size="1"><span class="gmail-Apple-tab-span" style="white-space:pre">      </span>                    Correlation expression is a search query.</font></div><div><font size="1"><span class="gmail-Apple-tab-span" style="white-space:pre">    </span>                    Following search query will look for users that have "name"</font></div><div><font size="1"><span class="gmail-Apple-tab-span" style="white-space:pre">        </span>                    equal to the "name" attribute of the account. Simply speaking,</font></div><div><font size="1"><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>                    it will look for match in usernames in the IDM and the resource.</font></div><div><font size="1"><span class="gmail-Apple-tab-span" style="white-space:pre">     </span>                    The correlation rule always looks for users, so it will not match</font></div><div><font size="1"><span class="gmail-Apple-tab-span" style="white-space:pre">    </span>                    any other object type.</font></div><div><font size="1"><span class="gmail-Apple-tab-span" style="white-space:pre">                                       </span></q:description></font></div><div><font size="1">            <q:equal></font></div><div><font size="1">               <q:matching>PolyStringNorm</q:matching></font></div><div><font size="1">               <q:path>c:name</q:path></font></div><div><font size="1">               <expression></font></div><div><font size="1">                  <c:path>declare namespace ri='<a href="http://midpoint.evolveum.com/xml/ns/public/resource/instance-3">http://midpoint.evolveum.com/xml/ns/public/resource/instance-3</a>'; $account/attributes/ri:name</c:path></font></div><div><font size="1">               </expression></font></div><div><font size="1">            </q:equal></font></div><div><font size="1">         </correlation></font></div><div><font size="1">         <reaction></font></div><div><font size="1">            <situation>linked</situation></font></div><div><font size="1">            <action></font></div><div><font size="1">               <handlerUri><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#modifyUser">http://midpoint.evolveum.com/xml/ns/public/model/action-3#modifyUser</a></handlerUri></font></div><div><font size="1">            </action></font></div><div><font size="1">         </reaction></font></div><div><font size="1">         <reaction></font></div><div><font size="1">            <situation>deleted</situation></font></div><div><font size="1">            <action></font></div><div><font size="1">               <handlerUri><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#unlink">http://midpoint.evolveum.com/xml/ns/public/model/action-3#unlink</a></handlerUri></font></div><div><font size="1">            </action></font></div><div><font size="1">         </reaction></font></div><div><font size="1">         <reaction></font></div><div><font size="1">            <situation>unlinked</situation></font></div><div><font size="1">            <objectTemplateRef oid="e63e1118-cbe5-11e5-b08e-3c970e44b9e2"/></font></div><div><font size="1">            <action></font></div><div><font size="1">               <handlerUri><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#link">http://midpoint.evolveum.com/xml/ns/public/model/action-3#link</a></handlerUri></font></div><div><font size="1">            </action></font></div><div><font size="1">         </reaction></font></div><div><font size="1">         <reaction></font></div><div><font size="1">            <situation>unmatched</situation></font></div><div><font size="1">            <objectTemplateRef oid="e63e1118-cbe5-11e5-b08e-3c970e44b9e2"/></font></div><div><font size="1">            <action></font></div><div><font size="1">               <handlerUri><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#addUser">http://midpoint.evolveum.com/xml/ns/public/model/action-3#addUser</a></handlerUri></font></div><div><font size="1">            </action></font></div><div><font size="1">         </reaction></font></div><div><font size="1">      </objectSynchronization></font></div><div><font size="1">   </synchronization></font></div></div><div><br></div><div>What can be a problem? Thanks in advance.</div><div><br></div><div>Dilek.</div></div>