2013/7/18 Martin Geisenhof <[email protected]>: > Hi Everbody, > i have a running configuration with lsc 2.0.2 from a informix database to > openldap. Everything works fine except the option to delete entries in the > destination. maybe i have the same problem like described in this thread > (http://www.mail-archive.com/[email protected]/msg01468.html). > My goal is to delete people in openldap who are not in database anymore. > > My configuration looks like this: > > lsc.xml (just a part): > > <task> > <name>syncStudenten-full</name> > <bean>org.lsc.beans.SimpleBean</bean> > <databaseSourceService> > <name>sospos-quelle</name> > <connection reference="quelle-informix-sospos" /> > <requestNameForList>getStudentenIDs-full</requestNameForList> > <requestNameForObject>getStudentenIdentities-full</requestNameForObject> > <requestNameForClean>getStudentenClean</requestNameForClean> > </databaseSourceService> > <ldapDestinationService> > <name>openldap-studenten</name> > <connection reference="ziel-studenten-openldap" /> > <baseDn>ou=people,dc=hoke,dc=idm</baseDn> > <pivotAttributes> > <string>cn</string> > </pivotAttributes> > <fetchedAttributes> > <string>objectClass</string> > <string>cn</string> > <string>sn</string> > <string>givenName</string> > <string>displayname</string> > <string>uid</string> > <string>userPassword</string> > <string>mail</string> > </fetchedAttributes> > <getAllFilter>(objectClass=*)</getAllFilter> > <getOneFilter>(cn={cn})</getOneFilter> > </ldapDestinationService> > > My SQL-Statements are: > > <select id="getStudentenIDs-full" resultClass="java.util.HashMap"> > SELECT cn > FROM idmstudview > </select> > <select id="getStudentenIdentities-full" resultClass="java.util.HashMap" > parameterClass="java.util.Map"> > SELECT > > 'top;person;organizationalperson;inetorgperson;inetLocalMailRecipient;eduperson;hisperson' > AS objectclass, > cn, > sn, > givenname, > displayname, > : > : > FROM idmstudview > WHERE cn = #cn# > </select> > > <select id="getStudentenClean" resultClass="java.util.HashMap" > parameterClass="java.util.Map"> > SELECT cn > FROM idmstudview > WHERE cn = #cn# > </select> > > To sync i run: > /etc/lsc/prod/lsc-stud/bin/lsc -f /etc/lsc/prod/lsc-stud/etc -c > syncStudenten-full -s syncStudenten-full > > Then i get this error: > > Jul 16 15:40:38 - INFO - All entries: 608, to modify entries: 608, > successfully modified entries: 608, errors: 0 > Jul 16 15:40:38 - INFO - Starting clean for syncStudenten-full > Jul 16 15:40:39 - WARN - Error while looking for a specific entry with > id=ou=people,dc=hoke,dc=idm > (com.ibatis.common.jdbc.exception.NestedSQLException: > --- The error occurred in > file:///etc/lsc/prod/lsc-stud/etc//sql-map-config.d/studenten.xml. > --- The error occurred while applying a parameter map. > --- Check the getStudentenClean-InlineParameterMap. > --- Check the parameter mapping for the 'cn' property. > --- Cause: java.sql.SQLException: Unknown object type) > Jul 16 15:40:39 - ERROR - Error while synchronizing ID {}: > org.lsc.exception.LscServiceException: javax.naming.CommunicationException: > --- The error occurred in > file:///etc/lsc/prod/lsc-stud/etc//sql-map-config.d/studenten.xml. > --- The error occurred while applying a parameter map. > --- Check the getStudentenClean-InlineParameterMap. > --- Check the parameter mapping for the 'cn' property. > --- Cause: java.sql.SQLException: Unknown object type > Jul 16 15:40:39 - ERROR - Connection lost! Aborting. > > I don't know whats wrong, i think my clean phrase (getStudentenClean) looks > fine. any ideas? >
How is defined your main identifier? Clément. _______________________________________________________________ Ldap Synchronization Connector (LSC) - http://lsc-project.org lsc-users mailing list [email protected] http://lists.lsc-project.org/listinfo/lsc-users
