[midPoint] Live Synchronization Task not Syncing
Pavol Mederly
mederly at evolveum.com
Fri Aug 26 10:40:27 CEST 2016
Martin,
a quick shot after looking at the files you sent:
1. your live sync task is suspended
2. your resource file doesn't contain <schemaHandling> (namely, inbound
mappings)
But probably this is only in file versions you've sent here.
Generally, I would suggest the following debug procedure:
1. Make your live sync task single-run (i.e. non recurring). So you
would execute it manually.
2. Manually execute live sync task the first time. Verify that the
token is set.
3. Change something in the database.
4. Manually execute live sync task again. Verify that the token is updated.
5. Also check the following:
1. "Progress" tab on the task
2. result of the task
3. midPoint log file; if needed, use the standard troubleshooting
procedure
<https://wiki.evolveum.com/display/midPoint/Usual+Troubleshooting+Steps>
Best regards,
Pavol Mederly
Software developer
evolveum.com
On 25.08.2016 21:46, Martin Marchese wrote:
> Gustav,
>
> Thanks for the advice. We were researching on this and we found a
> compatibility issue while using ojdbc14.jar driver.
>
> - When using ojdbc14.jar to connect to the database, the value type
> return by JDBC for a NUMBER column is INT.
> - The RAnyConverter class, casts this INT to Long. (Line 101)
> - Then it calls the extractValue method using a BigDecimal as property
> value and Long.class as return type. (Line 120)
> - This method (extractValue), if propertyValue is a BigDecimal, a
> String is returned
> - Finally, on line 234 we found this
> "returnType.isAssignableFrom(object.getClass())" (what, in this case
> would be Long.isAssignableFrom(String.getClass()) and it returns
> false, thus the task fails).
>
> We changed the driver to ojdbc6.jar. This version, returnes the NUMBER
> column as INTEGER. The RAnyConverter class, casts INTEGER to String,
> so in this case ths tasks finishes succesfully and it updates the Sync
> token value.
>
> However, it's still not syncing the changes from the database into
> midpoint. I'm attaching the resource and task XML so you can look if
> there's something missing there.
>
> Thanks in advance.
>
> *Ing. Martín Marchese*
> Identicum S.A.
> Jorge Newbery 3226
> Tel: +54 (11) 4552-3050
> mmarchese at identicum.com <mailto:mmarchese at identicum.com>
> www.identicum.com <http://www.identicum.com>
>
> On Thu, Aug 25, 2016 at 1:40 AM, Pálos Gustáv
> <gustav.palos at evolveum.com <mailto:gustav.palos at evolveum.com>> wrote:
>
> Hi Martin,
>
> can you try instead of VARCHAR2 using timestamp?
> from javadoc:
> https://github.com/Evolveum/openicf/blob/master/connectors/java/databasetable/src/main/java/org/identityconnectors/databasetable/DatabaseTableConfiguration.java
> <https://github.com/Evolveum/openicf/blob/master/connectors/java/databasetable/src/main/java/org/identityconnectors/databasetable/DatabaseTableConfiguration.java>
> /**
>
> * Change Log Column (should automatically add ORDER BY)
>
> * If the value is non empty, the SyncOp should be supported
>
> * *It could be nativeTimestamps.*
>
> */
>
> after changed VIEW structure, please delete old token from
> resource XML and try again
>
> Gustav
>
>
> 2016-08-24 19:06 GMT+02:00 Martin Marchese
> <mmarchese at identicum.com <mailto:mmarchese at identicum.com>>:
>
> The CHANGE_LOG is generated in the VIEW by using
> to_char(SYSDATE), so it's VARCHAR2.
>
> Thanks
>
> *Ing. Martín Marchese*
> Identicum S.A.
> Jorge Newbery 3226
> Tel: +54 (11) 4552-3050 <tel:%2B54%20%2811%29%204552-3050>
> mmarchese at identicum.com <mailto:mmarchese at identicum.com>
> www.identicum.com <http://www.identicum.com>
>
> On Wed, Aug 24, 2016 at 1:28 PM, Ivan Noris
> <Ivan.Noris at evolveum.com <mailto:Ivan.Noris at evolveum.com>> wrote:
>
> Hi Martin,
> this looks strange, as it is Oracle error...what is the
> CHANGE_LOG type in your database?
> Ivan
>
> ------------------------------------------------------------------------
>
> *From: *"Martin Marchese" <mmarchese at identicum.com
> <mailto:mmarchese at identicum.com>>
> *To: *"midPoint General Discussion"
> <midpoint at lists.evolveum.com
> <mailto:midpoint at lists.evolveum.com>>
> *Sent: *Wednesday, August 24, 2016 5:34:38 PM
> *Subject: *Re: [midPoint] Live Synchronization Task
> not Syncing
>
>
> Pálos / Ivan
>
> Thanks both for the help, unfortunately I had no luck
> yet.
>
> First I'd like to state that I'm using a VIEW and not
> a TABLE.
>
> I tried restarting midpoint, since I did change the
> database, but still no luck.
>
> I had the CHANGE_LOG column but it had not had any
> value, so to start testing I added the
> to_char(SYSDATE) into that column. Now I'm receiving
> the following errors:
>
>
> /Internal Error: DB error:
> java.sql.SQLException(ORA-01722: invalid number?) /
> /Operation/
> /operation.com
> <http://operation.com>.evolveum.midpoint.common.operation.liveSync/
> /Message/
> /Internal Error: DB error:
> java.sql.SQLException(ORA-01722: invalid number?)/
> / Synchronization error: generic connector framework
> error: DB error: java.sql.SQLException(ORA-01722:
> invalid number?) /
> /Operation/
> /operation.com
> <http://operation.com>.evolveum.midpoint.provisioning.api.ProvisioningService.synchronize/
> /Message/
> /Synchronization error: generic connector framework
> error: DB error: java.sql.SQLException(ORA-01722:
> invalid number?)/
> /Parameters/
> /oidjavax.xml.bind.JAXBElement at a039fa4/
> /taskjavax.xml.bind.JAXBElement at 5cd8d164/
>
>
> Any thoughts on this?
>
> Also, I'm working on getting the resource and task XML
> so I can send it over this thread.
>
> Thanks in advance
>
>
> *Ing. Martín Marchese*
> Identicum S.A.
> Jorge Newbery 3226
> Tel: +54 (11) 4552-3050 <tel:%2B54%20%2811%29%204552-3050>
> mmarchese at identicum.com <mailto:mmarchese at identicum.com>
> www.identicum.com <http://www.identicum.com>
>
> On Tue, Aug 23, 2016 at 4:54 PM, Ivan Noris
> <Ivan.Noris at evolveum.com
> <mailto:Ivan.Noris at evolveum.com>> wrote:
>
> Martin,
> can you check the Task in the repository, if there
> is a "token" element (don't remember the exact
> name as I don't have mp handy now) in the task
> extension? There should be date/time of the last
> modification from DB.
>
> What comes to my mind: have you recently changed
> the structure of the table? I mean, adding or
> removing columns after you have configured the
> resource? I remember to have this
> https://jira.evolveum.com/browse/MID-2046
> <https://jira.evolveum.com/browse/MID-2046> when I
> was playing with DBT connector and have added the
> "timestamp" column after the connection from mp to
> DB was already made... (Restarting either midpoint
> or the database to break the connection and
> restore it using Test connection helped).
>
> But it is just a guess now.
>
> Regards,
> Ivan
>
> ------------------------------------------------------------------------
>
> *From: *"Martin Marchese"
> <mmarchese at identicum.com
> <mailto:mmarchese at identicum.com>>
> *To: *"midPoint General Discussion"
> <midpoint at lists.evolveum.com
> <mailto:midpoint at lists.evolveum.com>>
> *Sent: *Tuesday, August 23, 2016 9:28:25 PM
> *Subject: *[midPoint] Live Synchronization
> Task not Syncing
>
>
> Hi all,
>
> I'm working with a DatabaseTable connector
> which has a LiveSync task assigned in order to
> sync users from the table into MidPoint and
> it's inbound mappings for each attribute set up.
>
> However, whenever I create a new user in the
> database table it does not sync into MidPoint
> even if the task is running. The only way I
> can create the user in MidPoint is manually
> importing it thru the Resource.
>
> Besides, once the user is created, the
> modifications that I do within the databse
> table, never sync into MidPoint.
>
> An INFO level log shows no error nor warnings.
>
> Is there any thing that needs to be enabled
> within the resource/task in order to do this?
>
> Thanks
> *Ing. Martín Marchese*
> Identicum S.A.
> Jorge Newbery 3226
> Tel: +54 (11) 4552-3050
> <tel:%2B54%20%2811%29%204552-3050>
> mmarchese at identicum.com
> <mailto:mmarchese at identicum.com>
> www.identicum.com <http://www.identicum.com>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
> <http://lists.evolveum.com/mailman/listinfo/midpoint>
>
>
>
>
> --
> Ivan Noris
> Senior Identity Engineer
> evolveum.com <http://evolveum.com>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
> <http://lists.evolveum.com/mailman/listinfo/midpoint>
>
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
> <http://lists.evolveum.com/mailman/listinfo/midpoint>
>
>
>
>
> --
> Ivan Noris
> Senior Identity Engineer
> evolveum.com <http://evolveum.com>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
> <http://lists.evolveum.com/mailman/listinfo/midpoint>
>
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
> <http://lists.evolveum.com/mailman/listinfo/midpoint>
>
>
>
>
> --
> Gustáv Pálos
> Identity Engineer
> evolveum.com <http://evolveum.com/>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com <mailto:midPoint at lists.evolveum.com>
> http://lists.evolveum.com/mailman/listinfo/midpoint
> <http://lists.evolveum.com/mailman/listinfo/midpoint>
>
>
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20160826/a133a64b/attachment.htm>
More information about the midPoint
mailing list