I have tried right now that and returns me the same error. Could it be a problem with jdbc driver? I have linked tomcat-jdbc-7.0.52.jar in my tomcat/lib folder.
Regards. El Jueves 12 de junio de 2014 8:53, Francesco Chicchiriccò <[email protected]> escribió: Hi, I would say that it's better for you to start again from a clean situation, so 1. stop Tomcat 2. erase the MySQL database content 3. reset the CSV file 4. start Tomcat again 5. configure the CSV connector without full reconciliation - as suggested FYI, an issue was reported yesterday for the problem you encountered with the CSVDir connector using full reconciliation: https://connid.atlassian.net/browse/CSVDIR-8 Regards. On 11/06/2014 16:32, Javier Calvach Regidor wrote: I tried that other times, but it gives me an error of the kind: > > >org.quartz.JobExecutionException: While syncing on connector [See nested >exception: >org.identityconnectors.framework.common.exceptions.ConnectorException: >org.identityconnectors.framework.common.exceptions.ConnectorIOException: >java.sql.SQLException: Invalid argument in JDBC call] at >org.apache.syncope.core.sync.impl.SyncJob.executeWithSecurityContext(SyncJob.java:444) > at org.apache.syncope.core.sync.impl.SyncJob.doExecute(SyncJob.java:342) at >org.apache.syncope.core.quartz.AbstractTaskJob.execute(AbstractTaskJob.java:126) > at org.quartz.core.JobRunShell.run(JobRunShell.java:213) at >org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557) >This is getting complicated!! > > > >El Miércoles 11 de junio de 2014 15:03, Marco Di Sabatino Di Diodoro ><[email protected]> escribió: > > > >Hi, > > >Il giorno 11/giu/2014, alle ore 12:34, Javier Calvach Regidor ><[email protected]> ha scritto: > >I think so. Actually, there's 19 columns in the CSV and all values are loaded >in Syncope correctly. All capabilities are checked as well. > > > > >I just check your question. >In the Sync Task configuration, uncheck Full reconciliation property and run a >new synchronization. > > >Regards >Marco > > >> >> >>El Miércoles 11 de junio de 2014 12:27, Francesco Chicchiriccò >><[email protected]> escribió: >> >> >> >>On 11/06/2014 12:24, Javier Calvach Regidor wrote: >> >>Let's see the log: >>> >>> >>>==>Dry run only, no modifications were made<== Users [created/failures]: 0/0 >>>[updated/failures]: 9/0 [deleted/failures]: 0/0 Roles [created/failures]: 0/0 [updated/failures]: 0/0 [deleted/failures]: 0/0 Users created: Users updated: UPDATE SUCCESS (id/name): 1013/AH03002 UPDATE SUCCESS (id/name): 1014/AH03286 UPDATE SUCCESS (id/name): 1015/AH03383 UPDATE SUCCESS (id/name): 1016/AH03500 UPDATE SUCCESS (id/name): 1017/AH03783 UPDATE SUCCESS (id/name): 1018/AH04452 UPDATE SUCCESS (id/name): 1019/AH04521 UPDATE SUCCESS (id/name): 1020/AH06049 UPDATE SUCCESS (id/name): 1022/AH09304 Users deleted: Roles created: Roles updated: Roles deleted: >>>I have 10 users in the CSV I deleted the last one. No trace about it. >>It seems that the connector is seeing your "delete" as update: are you sure that the CSV connector configuration correctly reflects the CSV file structure? >> >> >> >>> >>>El Martes 10 de junio de 2014 13:51, Francesco Chicchiriccò >>><[email protected]> escribió: >>> >>> >>> >>>On 10/06/2014 13:43, Javier Calvach Regidor wrote: >>> >>>It's a new project from scratch. I have check it out, and all 5 options >>>(from Create new identities to Full reconciliation") are checked. >>>You need then to take a closer look then: >>> >>>1. Delete an user from CSV >>>2. Go to Synchronization Tasks on the admin console >>>3. Click the 'DryRun' icon next to the task for the CSV resource >>>4. Wait until the task has run (you can hit the refresh icon on top right until you see an updated last execution time) >>>5. Click the edit icon next to the task for the CSV resource >>>6. Go to the 'Executions' tab >>>7. Open the most recent execution - it should be the one just completed >>>8. The execution report should contain more insightful information to investigate your issue >>> >>> >>>Regards. >>> >>> >>>El Martes 10 de junio de 2014 13:22, Francesco Chicchiriccò >>><[email protected]> escribió: >>>> >>>> >>>>On 10/06/2014 13:13, Javier Calvach Regidor wrote: >>>> >>>>Hi again! >>>>> >>>>> >>>>>I have configured a CSV connector and, after a couple of tests, I noticed >>>>>that only "create" and "update" operations are propagated to the Syncope's >>>>>MySQL. If I delete an user in the CSV file, there is no change in the >>>>>database. Is there any way to change this? Should I modify the workflow? >>>> >>>>Hi, >>>>what kind of Syncope project are you working on? Have you downloaded some virtual machine or have you started a Maven project from scratch? >>>> >>>>A possible reason for not removing Syncope internal users (MySQL in you case) upon delete from CSV could be that you did not check the 'Delete matching entities' options for the Synchronization Task you created on your CSV resource. >>>> >>>>Regards. >>>> -- Francesco Chicchiriccò Tirasa - Open Source Excellence http://www.tirasa.net/ Involved at The Apache Software Foundation: member, Syncope PMC chair, Cocoon PMC, Olingo PMC http://people.apache.org/~ilgrosso/
