<html><body><div style="font-family: times new roman, new york, times, serif; font-size: 12pt; color: #000000"><div>Hi Dilek,<br></div><div><br></div><div><span style="font-family: 'times new roman', 'new york', times, serif;">after quick look into your re</span>source configuration I suspect that the problem is in the correlation rule. In your filter you use <span style="font-family: monospace; font-size: 13px;" data-mce-style="font-family: monospace; font-size: 13px;">$account/attributes/ri:name</span>. Try to change it to <span style="font-family: monospace; font-size: 13px;" data-mce-style="font-family: monospace; font-size: 13px;">$account/attributes/<span style="color: rgb(255, 0, 0);"><strong>icfs</strong></span>:name. </span></div><div><span style="font-family: monospace; font-size: 13px;" data-mce-style="font-family: monospace; font-size: 13px;"><br></span></div><div><span style="font-family: 'times new roman', 'new york', times, serif; font-size: medium;">If this doesn't help, please enable TRACE logging for the package com.evolveum.midpoint.model.impl.sync and look into the logs what is happening.</span></div><div><span style="font-family: monospace; font-size: 13px;" data-mce-style="font-family: monospace; font-size: 13px;"><br></span></div><div><br></div><div><span name="x"></span>Best regards,<br><div><br></div>Katarina Valalikova<br>Java Developer<br>evolveum.com<span name="x"></span><br></div><div><br></div><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Dilek Gider" <dilek.gider@basistek.com><br><b>To: </b>"midPoint General Discussion" <midpoint@lists.evolveum.com><br><b>Sent: </b>Wednesday, March 8, 2017 8:49:29 AM<br><b>Subject: </b>Re: [midPoint] Reconciliation modify object gives an error<br><div><br></div><div dir="ltr">Hi Oskar,<div><br></div><div>Thank you for your response. Yes I think second reconciliation does not match but I dont know why.</div><div>I send you my resource xml and SearchScript.groovy. You can see on SerachScript.groovy, I concat two database column as "name".</div><div><br></div><div>I will appreciate for your help.</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Mar 7, 2017 at 5:38 PM, Oskar Butovič - AMI Praha a.s. <span dir="ltr"><<a href="mailto:oskar.butovic@ami.cz" target="_blank">oskar.butovic@ami.cz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Hello,<div><br></div><div>it seems like names which are created during first reconciliation are not matched by corelation rule during second reconciliation. What is your mapping which creates users name?</div><div><br></div><div>Best Regards</div><div><br></div><div>Oskar Butovič</div></div><div class="gmail_extra"><br><div class="gmail_quote">2017-03-07 12:52 GMT+01:00 Dilek Gider <span dir="ltr"><<a href="mailto:dilek.gider@basistek.com" target="_blank">dilek.gider@basistek.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><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><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;">Error processing focus(user:null(TR45187127836)): constraint violation: Found conflicting existing object with property {.../common/common-3}name = PP({.../common/common-3}name):[PPV(PolyString:TR45187127836, origin: INBOUND:resource:ef2bc59b-76e0-48e2-86d6-3d4f02d420db(TirsanScriptedSQLResource))]: user:96dd9828-e16f-4a7c-bebe-74c4d184b340(TR45187127836)</span><br></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"><br></span></div><div>Correlation rule has PolyStringNorm such as:</div><div><br></div><div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"><synchronization></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <objectSynchronization></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <objectClass>ri:AccountObjectClass</objectClass></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <kind>account</kind></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <intent>default</intent></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <enabled>true</enabled></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <correlation></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <q:description></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"><span class="m_-691441859128105076m_-7627896796955210813gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> Correlation expression is a search query.</span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"><span class="m_-691441859128105076m_-7627896796955210813gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> Following search query will look for users that have "name"</span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"><span class="m_-691441859128105076m_-7627896796955210813gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> equal to the "name" attribute of the account. Simply speaking,</span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"><span class="m_-691441859128105076m_-7627896796955210813gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> it will look for match in usernames in the IDM and the resource.</span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"><span class="m_-691441859128105076m_-7627896796955210813gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> The correlation rule always looks for users, so it will not match</span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"><span class="m_-691441859128105076m_-7627896796955210813gmail-Apple-tab-span" style="white-space:pre-wrap"> </span> any other object type.</span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"><span class="m_-691441859128105076m_-7627896796955210813gmail-Apple-tab-span" style="white-space:pre-wrap"> </span></q:description></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <q:equal></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <q:matching>PolyStringNorm</q:matching></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <q:path>c:name</q:path></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <expression></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <c:path>declare namespace ri='<a href="http://midpoint.evolveum.com/xml/ns/public/resource/instance-3" target="_blank">http://midpoint.evolveum.com/xml/ns/public/resource/instance-3</a>'; $account/attributes/ri:name</c:path></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </expression></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </q:equal></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </correlation></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <reaction></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <situation>linked</situation></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <action></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <handlerUri><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#modifyUser" target="_blank">http://midpoint.evolveum.com/xml/ns/public/model/action-3#modifyUser</a></handlerUri></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </action></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </reaction></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <reaction></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <situation>deleted</situation></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <action></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <handlerUri><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#unlink" target="_blank">http://midpoint.evolveum.com/xml/ns/public/model/action-3#unlink</a></handlerUri></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </action></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </reaction></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <reaction></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <situation>unlinked</situation></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <objectTemplateRef oid="e63e1118-cbe5-11e5-b08e-3c970e44b9e2"/></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <action></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <handlerUri><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#link" target="_blank">http://midpoint.evolveum.com/xml/ns/public/model/action-3#link</a></handlerUri></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </action></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </reaction></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <reaction></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <situation>unmatched</situation></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <objectTemplateRef oid="e63e1118-cbe5-11e5-b08e-3c970e44b9e2"/></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <action></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> <handlerUri><a href="http://midpoint.evolveum.com/xml/ns/public/model/action-3#addUser" target="_blank">http://midpoint.evolveum.com/xml/ns/public/model/action-3#addUser</a></handlerUri></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </action></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </reaction></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </objectSynchronization></span></div><div><span size="1" data-mce-style="font-size: xx-small;" style="font-size: xx-small;"> </synchronization></span></div></div><div><br></div><div>What can be a problem? Thanks in advance.</div><span class="m_-691441859128105076HOEnZb"><span color="#888888" data-mce-style="color: #888888;" style="color: #888888;"><div><br></div><div>Dilek.</div></span></span></div>
<br>_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="m_-691441859128105076gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><table style="font-family:Verdana,Arial,Helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px!important;border-style:solid!important;width:482px!important" class="mceItemTable"><tbody><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;width:160px;vertical-align:bottom;padding:0px;border:0px solid gray!important"><p><span style="font-size:14px;font-weight:bold">Oskar Butovič</span><br>solution architect<br></p><div><br></div>gsm: <a href="tel:+420%20774%20480%20101" target="_blank">[+420] 774 480 101</a><br>e-mail: <a href="mailto:oskar.butovic@ami.cz" target="_blank">oskar.butovic@ami.cz</a><p></p></td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray!important"> </td><td style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;width:123px;border:0px solid gray!important"><p>AMI Praha a.s.<br>Pláničkova 11<br>162 00 Praha 6<br>tel.: <a href="tel:+420%20274%20783%20239" target="_blank">[+420] 274 783 239</a><br>web: <a href="http://www.ami.cz/" target="_blank">www.ami.cz</a></p></td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray!important"> </td><td style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;margin:8px;border:0px solid gray!important;width:116px"><p><img alt="AMI Praha a.s." style="border:0px" src="http://www.ami.cz/images/podpis/ami_logo.gif"></p></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="7" style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;width:480px;border:0px solid gray!important"><br><a href="http://www.ami.cz/reseni-a-sluzby/bezpecnost-dat/identity-management" target="_blank"><img alt="AMI Praha a.s." style="border:0px;width:480px!important;height:82px!important" src="http://www.ami.cz/images/podpis/AMI-podpis-IdM_1.png"></a></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="7" style="color:rgb(128,128,128);font-family:Arial,sans-serif;font-size:11px;padding:0px;border:0px solid gray!important"><br>Textem tohoto e-mailu podepisující neslibuje uzavřít ani neuzavírá za společnost AMI Praha a.s.<br>jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně písemnou formu.<br><div><br></div></td></tr></tbody></table></div></div></div></div></div></div></div>
</div>
<br>_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
<br></blockquote></div><br></div>
<br>_______________________________________________<br>midPoint mailing list<br>midPoint@lists.evolveum.com<br>http://lists.evolveum.com/mailman/listinfo/midpoint<br></div><div><br></div></div></body></html>