OID DIP 11g HR DB To OID Import Sync Using odihragent Fails With Log Error: Exception encountered in forming agent execution command. java.lang.NullPointerException (Doc ID 1305946.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Internet Directory - Version 11.1.1 and later
Information in this document applies to any platform.
***Checked for relevance on 20-aug-2013***

Symptoms

Oracle Internet Directory (OID) 11g with Directory Integration Platform (DIP) Human Resources (HR) import synchronization.

HR database (DB) to OID DIP import sync fails with $MW_HOME/user_projects/domains/<Domain _Name>/servers/<Managed_Server>/logs/wls_ods1-diagnostic.log log file exception:

[2010-12-22T08:00:46.084-06:00] [wls_ods1] [TRACE] [] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [SRC_CLASS: oracle.ldap.odip.util.DirUtils] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] [SRC_METHOD: getOIDContext] DirUtils : cn=odisrv,cn=Registered Instances,cn=Directory Integration Platform,cn=products,cn=oraclecontext
[2010-12-22T08:00:46.147-06:00] [wls_ods1] [TRACE] [] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [SRC_CLASS: oracle.ldap.odip.util.DirUtils] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] [SRC_METHOD: getOIDConnector] Entering getOIDConnector
[2010-12-22T08:00:46.147-06:00] [wls_ods1] [TRACE:32] [] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [SRC_CLASS: oracle.ldap.odip.engine.Profile] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] [SRC_METHOD: initialise] Entry: Profile.initialise
[2010-12-22T08:00:46.147-06:00] [wls_ods1] [NOTIFICATION] [] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] SEARCH_TIME_SET
[2010-12-22T08:00:46.147-06:00] [wls_ods1] [NOTIFICATION] [DIP-10040] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] [arg: 500] Search Delta Size set to: 500.
[2010-12-22T08:00:46.147-06:00] [wls_ods1] [NOTIFICATION] [DIP-10042] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] [arg: false] SkipErrorToSyncNextchange attribute is set to: false.
[2010-12-22T08:00:46.147-06:00] [wls_ods1] [NOTIFICATION] [DIP-10043] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] [arg: 100] Update search count is set to: 100.
[2010-12-22T08:00:46.150-06:00] [wls_ods1] [ERROR] [DIP-10077] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] Exception encountered in forming agent execution command.[[
java.lang.NullPointerException

at oracle.ldap.odip.engine.Profile.initExeCommand(Profile.java:1133)
at oracle.ldap.odip.engine.Profile.initialise(Profile.java:334)
at oracle.ldap.odip.engine.Profile.initProfile(Profile.java:736)
at oracle.ldap.odip.engine.Profile.initProfile(Profile.java:750)
at oracle.ldap.odip.web.DIPSyncBean.initialize(DIPSyncBean.java:233)
at oracle.ldap.odip.web.DIPSync_2r3ocw_EOImpl.initialize(DIPSync_2r3ocw_EOImpl.java:270)
at oracle.ldap.odip.web.SyncQuartzJobImpl.execute(SyncQuartzJobImpl.java:175)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

]]
[2010-12-22T08:00:46.150-06:00] [wls_ods1] [NOTIFICATION] [] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] Mapping init successful
[2010-12-22T08:00:46.154-06:00] [wls_ods1] [ERROR] [DIP-10078] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] Exception in initializing profile.
[2010-12-22T08:00:46.155-06:00] [wls_ods1] [TRACE] [DIP-10078] [oracle.dip] [host: myoidhost] [nwaddr: <IP address>] [tid: HRAgent] [userId: <anonymous>] [ecid: 0000InYrp4kD0jPqucQ5UH1D1i20000008,0] [SRC_CLASS: oracle.ldap.odip.engine.Profile] [APP: DIP#11.1.1.2.0] [dcid: c34d1582000cd519:-805b47d:12ce2ddcf7e:-8000-0000000000000897] [SRC_METHOD: initialise] Exception in initializing profile.[[
ODIException: Profile Initialization Failure

at oracle.ldap.odip.engine.Profile.initExeCommand(Profile.java:1148)
at oracle.ldap.odip.engine.Profile.initialise(Profile.java:334)
at oracle.ldap.odip.engine.Profile.initProfile(Profile.java:736)
at oracle.ldap.odip.engine.Profile.initProfile(Profile.java:750)
at oracle.ldap.odip.web.DIPSyncBean.initialize(DIPSyncBean.java:233)
at oracle.ldap.odip.web.DIPSync_2r3ocw_EOImpl.initialize(DIPSync_2r3ocw_EOImpl.java:270)
at oracle.ldap.odip.web.SyncQuartzJobImpl.execute(SyncQuartzJobImpl.java:177)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)
Caused by: java.lang.NullPointerException
at oracle.ldap.odip.engine.Profile.initExeCommand(Profile.java:1133)
at oracle.ldap.odip.engine.Profile.initialise(Profile.java:334)
at oracle.ldap.odip.engine.Profile.initProfile(Profile.java:736)
at oracle.ldap.odip.engine.Profile.initProfile(Profile.java:750)
at oracle.ldap.odip.web.DIPSyncBean.initialize(DIPSyncBean.java:233)
at oracle.ldap.odip.web.DIPSync_2r3ocw_EOImpl.initialize(DIPSync_2r3ocw_EOImpl.java:270)
at oracle.ldap.odip.web.SyncQuartzJobImpl.execute(SyncQuartzJobImpl.java:175)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
... 1 more

]]


Tried switching the connect=<value> argument to have a simple/single tnsnames.ora servicename for the HR DB, and hardcoding the HR DB user password in the odihragent line as well, but same problem persits.

The command line odihragent works, does not produce any errors, and successfully creates the odiHRAgent.dat in the import directory, i.e.:

$ ./odihragent odiHRAgent connect=HRDB login=apps pass=<password> date=20051227132406
$



As a workaround, another simlar HR to OID import sync profile works fine as long as it is not associated with / does not use the odihragent command, i.e., it works when using JDBC Profile Type set in the DIP 11g Enterprise Manager (EM) Fusion Middleware (FMW) Control console.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms