<div dir="ltr">Hi Carlos,<div><br></div><div>I never tried liveSync over ScriptedRest, but I'm using for similar use case in Oracle <a href="https://wiki.evolveum.com/display/midPoint/DatabaseTable+Connector" target="_blank">https://wiki.evolveum.<wbr>com/display/midPoint/<wbr>DatabaseTable+Connector</a> .</div><div>The only special think what I needed is parameter changeLogColumn set to DB view column represented as string and calculated over <span style="font-size:12.8px">to_char(</span><span class="gmail-il" style="font-size:12.8px">MM_CHANGE_DATE</span><span style="font-size:12.8px">, 'YYYY-MM-DD HH24:MI:SS')</span></div><div><div class="gmail_extra"><br></div><div class="gmail_extra">Maybe try liveSync over this connector, compare log between these two and you found a difference & the problem.</div><div class="gmail_extra"><br></div><div class="gmail_extra">Some questions which maybe also help you to:</div><div class="gmail_extra">- Do you have liveSync task also with?</div><div class="gmail_extra"><ol class="gmail-text" style="color:rgb(172,172,172);background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(247,247,247);margin:0px;padding:0px 0px 0px 55px;font-family:consolas,menlo,monaco,"lucida console","liberation mono","dejavu sans mono","bitstream vera sans mono",monospace,serif;font-size:12px"><li class="gmail-li1" style="background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(255,255,255)"><div class="gmail-de1" style="padding:0px 8px;vertical-align:top;color:rgb(51,51,51);border-left:1px solid rgb(221,221,221);background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial"> <objectClass>CustomOrganizationObjectClass</objectClass></div></li><li class="gmail-li2" style="background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(255,255,255)"><div class="gmail-de2" style="padding:0px 8px;vertical-align:top;color:rgb(51,51,51);border-left:1px solid rgb(221,221,221);background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial"> <kind>generic</kind></div></li><li class="gmail-li1" style="background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(255,255,255)"><div class="gmail-de1" style="padding:0px 8px;vertical-align:top;color:rgb(51,51,51);border-left:1px solid rgb(221,221,221);background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(248,248,248)"> <intent>default</intent></div></li></ol></div><div class="gmail_extra"><br></div><div class="gmail_extra">In your livesync task XML the extension\token value is less then what you sent over a connector?</div><div class="gmail_extra"> <br></div><div class="gmail_extra"><br></div><div class="gmail_extra">Maybe other colleague can help you with this later, but all of them are too busy now :(</div><div class="gmail_extra"><br></div><div class="gmail_extra">Best regards,</div><div class="gmail_extra"><br></div><div class="gmail_extra">Gustav </div><div class="gmail_extra"><br></div><div class="gmail_extra"><br><div class="gmail_quote">2016-11-09 14:43 GMT+01:00 Carlos Ferreira <span dir="ltr"><<a href="mailto:carlos18619@gmail.com" target="_blank">carlos18619@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div><div><div><div><div><div><div><div><div><div>Hi everybody,<br><br></div>1. I am trying do sync <b>Organization</b> objects defined in ORACLE tables. The resource snippet that deals with it is:<br><br><a href="http://pastebin.com/Jcht99mJ" target="_blank">http://pastebin.com/Jcht99mJ</a><br><br></div>2. The <b>ORACLE row </b>that I want do sync is represented, in midpoint, as the shadow:<br><br><a href="http://pastebin.com/yZBJX0Mp" target="_blank">http://pastebin.com/yZBJX0Mp</a><br><br><br></div>3. The <b>groovy script</b> that deals with the synchronization is:<br><br><a href="http://pastebin.com/E4UaQ6C2" target="_blank">http://pastebin.com/E4UaQ6C2</a><br><br><br></div>4. And, finaly, the output of the sync script is<br><br><a href="http://pastebin.com/PCcjq4NJ" target="_blank">http://pastebin.com/PCcjq4NJ</a><br><br></div>As you can see, the groovy script returns what it is intended to.<br><br></div><br></div>5.
One more information. When I select Generics->Resource, in the
resource GUI and change the desired object, the sync operation works and
the organization is changed. Nonetheless, when I change the object
directly on the resource (<b>ORACLE</b>, in this case), the sync operation is not accomplished (even with groovy script returning what it must).<br><br><br></div>Did I miss anything?<br><br><br></div><div>Thks,<br><br></div>Carlos<br></div>Tribunal Regional do Trabalho da 3ª Região / Brasil</div>
<br>______________________________<wbr>_________________<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/mail<wbr>man/listinfo/midpoint</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail-m_2559955836582860898gmail_signature"><div dir="ltr"><div>Gustáv Pálos</div><div>Identity Engineer</div><a href="http://evolveum.com/" rel="noreferrer" style="color:rgb(17,85,204);font-size:12.8px" target="_blank">evolveum.com</a><br></div></div>
</div></div></div>