[midPoint] SCRIPTEDSQL - ORG SYNC NOT WORKING

[Pálos Gustáv]

Hi Carlos,

I never tried liveSync over ScriptedRest, but I'm using for similar use
case in Oracle https://wiki.evolveum.com/display/midPoint/
DatabaseTable+Connector .
The only special think what I needed is parameter changeLogColumn set to DB
view column represented as string and calculated over to_char(MM_CHANGE_DATE,
'YYYY-MM-DD HH24:MI:SS')

Maybe try liveSync over this connector, compare log between these two and
you found a difference & the problem.

Some questions which maybe also help you to:
- Do you have liveSync task also with?

   1.          <objectClass>CustomOrganizationObjectClass</objectClass>
   2.          <kind>generic</kind>
   3.          <intent>default</intent>


In your livesync task XML the extension\token value is less then what you
sent over a connector?


Maybe other colleague can help you with this later, but all of them are too
busy now :(

Best regards,

Gustav


2016-11-09 14:43 GMT+01:00 Carlos Ferreira <carlos18619 at gmail.com>:

> Hi everybody,
>
> 1. I am trying do sync *Organization* objects defined in ORACLE tables.
> The resource snippet that deals with it is:
>
> http://pastebin.com/Jcht99mJ
>
> 2. The *ORACLE row *that I want do sync is represented, in midpoint, as
> the shadow:
>
> http://pastebin.com/yZBJX0Mp
>
>
> 3. The *groovy script* that deals with the synchronization is:
>
> http://pastebin.com/E4UaQ6C2
>
>
> 4. And, finaly, the output of the sync script is
>
> http://pastebin.com/PCcjq4NJ
>
> As you can see, the groovy script returns what it is intended to.
>
>
> 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 (*ORACLE*, in this case), the sync operation is not
> accomplished (even with groovy script returning what it must).
>
>
> Did I miss anything?
>
>
> Thks,
>
> Carlos
> Tribunal Regional do Trabalho da 3ª Região / Brasil
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
>


-- 
Gustáv Pálos
Identity Engineer
evolveum.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20161110/c5773d63/attachment.htm>