Hi Clement, I have done as per your suggestion but still it gives below error.
Jan 19 14:46:12 - INFO - Starting sync for adGroup Jan 19 14:46:13 - ERROR - Error while adding entry cn=demogrp1,dc=testrjil,dc=net in directory :javax.naming.NameAlreadyBoundException: [LDAP: error code 68 - 00000526: UpdErr: DSID-031A119B, problem 6005 (ENTRY_EXISTS), data 0 ]; remaining name 'cn=demogrp1' Jan 19 14:46:13 - ERROR - Error while synchronizing ID cn=demogrp1,dc=testrjil,dc=net: java.lang.Exception: Technical problem while applying modifications to the destination # Mon Jan 19 14:46:13 IST 2015 dn: cn=demogrp1,dc=testrjil,dc=net changetype: add sAMAccountName: demotestgrp1 objectClass: group objectClass: top Jan 19 14:46:13 - ERROR - Error while adding entry cn=sqlgrp,dc=testrjil,dc=net in directory :javax.naming.NameAlreadyBoundException: [LDAP: error code 68 - 00000526: UpdErr: DSID-031A119B, problem 6005 (ENTRY_EXISTS), data 0 ]; remaining name 'cn=sqlgrp' Jan 19 14:46:13 - ERROR - Error while synchronizing ID cn=sqlgrp,dc=testrjil,dc=net: java.lang.Exception: Technical problem while applying modifications to the destination # Mon Jan 19 14:46:13 IST 2015 dn: cn=sqlgrp,dc=testrjil,dc=net changetype: add sAMAccountName: sqltestgrp objectClass: group objectClass: top Jan 19 14:46:13 - ERROR - All entries: 2, to modify entries: 2, successfully modified entries: 0, errors: 2 Jan 19 14:46:13 - INFO - Starting clean for adGroup Jan 19 14:46:13 - ERROR - Empty or non existant destination (no IDs found) [root@hardik-test-vm lsc]# vim sql-map-config.d/InetOrgPerson.xml <?xml version="1.0" encoding="UTF-8" standalone="no"?> <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd";> <sqlMap namespace="InetOrgPerson"> <select id="getInetOrgPerson" resultClass="java.util.HashMap" parameterClass="java.util.Map"> Select groupname,samaccountname FROM group_info WHERE groupname LIKE #groupname# </select> <select id="getInetOrgPersonClean" resultClass="java.util.HashMap" parameterClass="java.util.Map"> Select groupname FROM group_info WHERE groupname LIKE #cn# </select> And lsc is having below configuration. <databaseSourceService> <name>databaseConnectionService</name> <connection reference="mySQL" /> <requestNameForList>getInetOrgPersonList</requestNameForList> <requestNameForObject>getInetOrgPerson</requestNameForObject> <requestNameForClean>getInetOrgPersonClean</requestNameForClean> </databaseSourceService> <ldapDestinationService> <name>testad-dst-service</name> <connection reference="testAD" /> <baseDn>dc=testrjil,dc=net</baseDn> <pivotAttributes> <string>cn</string> </pivotAttributes> <fetchedAttributes> <string>cn</string> <string>sAMAccountName</string> <string>objectClass</string> </fetchedAttributes> <getAllFilter><![CDATA[(objectClass=inetOrgPerson)]]></getAllFilter> <getOneFilter><![CDATA[(&(objectClass=inetOrgPerson)(cn={cn}))]]></getOneFilter> </ldapDestinationService> <propertiesBasedSyncOptions> <mainIdentifier>"cn=" + srcBean.getDatasetFirstValueById("groupname") + ",dc=testrjil,dc=net"</mainIdentifier> <defaultDelimiter>;</defaultDelimiter> <defaultPolicy>FORCE</defaultPolicy> Your help will be really appreciated. -Hardik "Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s). are confidential and may be privileged. If you are not the intended recipient. you are hereby notified that any review. re-transmission. conversion to hard copy. copying. circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient. please notify the sender immediately by return email. and delete this message and any attachments from your system. Virus Warning: Although the company has taken reasonable precautions to ensure no viruses are present in this email. The company cannot accept responsibility for any loss or damage arising from the use of this email or attachment."
_______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
