Some Things to Check When OID Sync With OracleHRAgent Fails (Doc ID 351446.1)

Last updated on AUGUST 22, 2022

Applies to:

Goal

When synchronization using the OracleHRAgent profile is failing, it may be due to improper config or map files. This document provides the correct appearance of the files.

Errors in the $ORACLE_HOME/ldap/odi/log/OracleHRAgent.trc file may include any of the following:

• Executing Agent Command:odihragent OracleHRAgent connect=<TNS ALIAS login=apps pass=password date=20000101000000
  Return Status : 2
  writer context is null
  LDAP URL : (<hostname>.domain:5329 cn=odisrv+orclhostname=<hostname>,cn=registered instances,cn=directory integration platform,cn=products,cn=oraclecontext
  Specifying binary attributes: mpegvideo objectguid objectsid guid usercertificate orclodipcondirlastappliedchgnum
  LDAP Connection success
  Writer Initialised!!
  Writer proxy connection initialised!!
  Updated Attributes
  orclodipLastExecutionTime: 20051227132406
  orclodipConDirLastAppliedChgNum: 0
  orclOdipSynchronizationStatus: Agent Execution Failure, Aborting Mapping/IMPORT

• Change record : ChangeRecord : ----------
  Changetype: ADDRMODIFY
  ChangeKey: nonldap
  Attributes:
  Class: null Name: mail Type: null ChgType: REPLACE Value: [none@none.com]
  Class: null Name: description Type: null ChgType: REPLACE Value: [Test, IST]
  -----------
  Skipping Record: 1
  Change record : ChangeRecord : ----------
  Changetype: ADDRMODIFY
  ChangeKey: nonldap
  Attributes:
  Class: null Name: mail Type: null ChgType: REPLACE Value: [none@none.com]
  Class: null Name: description Type: null ChgType: REPLACE Value: [<DESCRIPTION>]
  -----------
  Skipping Record: 2
  ...
  Skipping Record: 191
  Change record : ChangeRecord : ----------
  Changetype: ADDRMODIFY
  ...

• MAPPING: getValues returning : null
  No value in entry for attribute specified in OID matching filter. Check if mapping rules in the profile are complete.
  Exception creating Entry : javax.naming.directory.SchemaViolationException: [LDAP: error code 65 - sn attribute not found. Mandatory Attribute missing.]; remaining name 'cn=<username>,cn=users,dc=<COMPANY>,dc=com'
  [LDAP: error code 65 - sn attribute not found. Mandatory Attribute missing.]
  javax.naming.directory.SchemaViolationException: [LDAP: error code 65 - sn attribute not found.
  Mandatory Attribute missing.]; remaining name 'cn=<username>,cn=users,dc=<COMPANY>,dc=com'
       at com.sun.jndi.ldap.LdapCtx.mapErrorCode(LdapCtx.java:3019)
       at com.sun.jndi.ldap.LdapCtx.processReturnCode(LdapCtx.java:2934)

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.