[lsc-users] delete entries in destination - requestNameForClean

[Martin Geisenhof]

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/lsc-users@lists.lsc-project.org/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?

 

_______________________________________________________________
Ldap Synchronization Connector (LSC) - http://lsc-project.org

lsc-users mailing list
lsc-users@lists.lsc-project.org
http://lists.lsc-project.org/listinfo/lsc-users