Hi,
I managed to get to the point where lsc is connecting to the LDAP,
retrieving the data and trying to update instead of insert data in the
MySQL database.
This is the error message I'm getting:
...
Mar 01 21:07:00 - ERROR - java.sql.SQLException: Select statements cannot
be executed as an update.
java.sql.SQLException: Select statements cannot be executed as an update.
at
com.ibatis.sqlmap.engine.mapping.statement.SelectStatement.executeUpdate(SelectStatement.java:31)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.insert(SqlMapExecutorDelegate.java:393)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.insert(SqlMapSessionImpl.java:82)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.insert(SqlMapClientImpl.java:58)
~[ibatis-sqlmap-2.3.4.726.jar:na]
at
org.lsc.service.AbstractJdbcDstService.apply(AbstractJdbcDstService.java:89)
~[lsc-core-2.1.3.jar:na]
at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:795)
[lsc-core-2.1.3.jar:na]
at org.lsc.SynchronizeTask.run(AbstractSynchronize.java:707)
[lsc-core-2.1.3.jar:na]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[na:1.8.0_71]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[na:1.8.0_71]
at java.lang.Thread.run(Thread.java:745) [na:1.8.0_71]
Mar 01 21:07:00 - ERROR - Error caused by operation create, attributes
{uname=JDoe, last_name=Doe, title=Dr, first_name=John}
Mar 01 21:07:00 - ERROR - Error while synchronizing ID
uid=JDoe,ou=users,ou=people,dc=emergency,dc=lu: java.lang.Exception:
Technical problem while applying modifications to the destination
# Tue Mar 01 21:07:00 CET 2016
dn: uid=JDoe,ou=users,ou=people,dc=example,dc=com
changetype: add
uname: JDoe
last_name: Doe
title: Dr
first_name: John
...
Mar 01 21:07:01 - ERROR - All entries: 64, to modify entries: 64,
successfully modified entries: 0, errors: 64
I'm using lsc installed from the rpm on CentOS 7.
otrsadm@OTRSDEV2:~/hitec2mysql $ rpm -qif /usr/bin/lsc
Name : lsc
Version : 2.1.3
Release : 0.el5
Architecture: noarch
Install Date: Sri 10 Vel 2016 12:20:11
Can someone help me to find out what did I configure wrong? How do I log
what SQL statement did the lsc actually call?
Because according to the stack trace insert method of the ibatis engine is
being called, but maybe a wrong SQL is being mapped.
I have not used iBatis in a decade so I don't know what to look for...
Thank you!
_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org
lsc-users mailing list
[email protected]
http://lists.lsc-project.org/listinfo/lsc-users
