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/ >> >> >> > > > >-- 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/ > > -- Dott. Marco Di Sabatino Di Diodoro Tel. +39 3939065570 Tirasa S.r.l. Viale D'Annunzio 267 - 65127 Pescara Tel +39 0859116307 / FAX +39 0859111173 http://www.tirasa.net Apache Syncope PMC Member http://people.apache.org/~mdisabatino/
