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] <mailto:[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] <mailto:[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]> <mailto:[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/
