{"id":1161,"date":"2009-05-14T14:59:34","date_gmt":"2009-05-14T18:59:34","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2009\/05\/14\/error-adding-new-user-11i-unable-to-call-fnd_ldap_wrappercreate_user\/"},"modified":"2009-05-21T13:41:20","modified_gmt":"2009-05-21T17:41:20","slug":"error-adding-new-user-11i-unable-to-call-fnd_ldap_wrappercreate_user","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2009\/05\/14\/error-adding-new-user-11i-unable-to-call-fnd_ldap_wrappercreate_user\/","title":{"rendered":"Error adding new User (11i) – unable to call fnd_ldap _wrapper .create_user"},"content":{"rendered":"

Issue<\/strong> : Error while creating new User in 11i system integrated with OID\/SSO “ORA-20001 unable to call fnd_ldap_wrapper.create_user due to folowing reason : An unexpected error occurred. Please contact System Administrator<\/strong>”<\/p>\n

Instance Configuration<\/strong> : Apps 11i with OID\/SSO Integration (one way Integration<\/strong> from Apps 11i to OID)<\/p>\n

Looking at error message “unable to call fnd_ldap_wrapper<\/strong>” its clear that issue is with LDAP (L<\/strong>ightweight D<\/strong>irectory A<\/strong>ccess P<\/strong>rotocol) i.e. OID (Oracle Internet Directory<\/strong>) to know more about OID click here<\/a><\/p>\n

User Provisioning & Synchronization<\/strong> :\u00a0 For those who are new to OID or integration of Apps (11i\/R12) <\/strong>with OID\/SSO –\u00a0 ODISRV<\/strong> (Oracle Directory Integration Service) is service\/sub component in\u00a0 OID (Oracle Internet Directory<\/strong>) which is responsible for User Provisioning<\/strong> and Synchronization<\/strong> between Oracle Internet Directory<\/strong> (Oracle’s implementation of LDAP <\/strong>Server) and Oracle E-Business Suite<\/strong> (11i\/R12) + other Oracle Application like Portal, Collaboration Suite here<\/a> and here<\/a><\/p>\n

There are three servers\/processes in OID
\na) oidldapd<\/strong> – LDAP daemon
\nb) oidrepld<\/strong> – OID replication Server
\nc) odisrv<\/strong> – Directory Integration Server
\n.<\/p>\n

Looking at error message fnd_ldap_wrapper.create_user <\/strong>its easy to guess that We need to focus on LDAP (OID in our case)<\/p>\n

1.<\/strong> First thing to do is check if OID (Oracle Internet Directory) is up and running<\/p>\n

“opmnctl status<\/strong>”\u00a0 If OID is up and running, next step is to check if ODI<\/strong> Server (Directory Integration) is up and running. There are two ways to check itCheck 1 from log files : Check ODI Server (Oracle Directory Integration Server)
\n$ORACLE_HOME\/ldap\/log\/odisrvXX.log (OID Home)
\n$ORACLE_HOME\/ldap\/odi\/log\/AppsName<\/strong>_cn=Common,cn=Products,cn=OracleContext_I.aud
\n$ORACLE_HOME\/ldap\/odi\/log\/AppsName<\/strong>_cn=Common,cn=Products,cn=OracleContext_I.trc<\/p>\n

<\/strong>where AppsName<\/strong> is name you used during Apps Integration with OID<\/p>\n

Check 2 from Process table<\/strong> :\u00a0 Check OID process in process table ODS.ODS_PROCESS<\/p>\n

SQL> select instance, pid, serverid, configset, state from ODS.ODS_PROCESS;<\/strong><\/p>\n

INSTANCE\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 PID\u00a0\u00a0 SERVERID\u00a0 CONFIGSET\u00a0\u00a0\u00a0\u00a0\u00a0 STATE
\n———- ———- ———- ———- ———-
\n1\u00a0\u00a0\u00a0\u00a0\u00a0 19061\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2
\n1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/p>\n

Server ID <\/strong>2 means LDAP Server
\nServer ID<\/strong> 7 with config set 0 means ODI(or DIP – Directory Integration and Provisioning) Server for Provisioning<\/strong>
\nServer ID<\/strong> 7 with config set 1 means ODI (or DIP- Directory Integration and Provisioning) Server for Synchronization<\/strong><\/p>\n

State<\/strong>
\n0 = stop<\/strong>, 1 = start<\/strong>, 2 = running<\/strong>, 3 = restart<\/strong>, 4 = shutdown<\/strong> 5= failed over<\/strong> (if using HA)<\/p>\n

This clearly indicates that there is some problem during start of ODI Server in above example.<\/font><\/p>\n

.<\/font><\/p>\n

Fix <\/strong>:
\n1)<\/strong> Shutdown OID using : opmnctl stopall <\/strong>(O<\/strong>racle P<\/strong>rocess M<\/strong>anager and N<\/strong>otification Server, OPMN strat OIDMON<\/strong> which in turn calls OIDCTL <\/strong>to start\/stop OID Processes)
\n2)<\/strong> Take backup of existing ods_process <\/strong>table
\nSQL>create table ods.ods_process_bkp as select * from ods.ods_process;
\n3)<\/strong> Truncate table ods_process
\nSQL>truncate table ods.ods_process;
\n4)<\/strong> Restart OID ; opmnctl startall
\n5)<\/strong> Check logs $ORACLE_HOME\/ldap\/log\/odisrvXX.log<\/strong><\/p>\n

If you don’t see any updates in $ORACLE_HOME\/ldap\/log\/odisrvXX.log
\nthen start ODI Server manually<\/strong> using OIDCTL<\/strong> (OID Control utility)<\/p>\n

oidctl<\/strong> connect=<tns_alias_for_db> server=ODISRV instance=1\u00a0 host=<hostname> configset=0 flags=”port=oid_port” start<\/p>\n

oidctl<\/strong> connect=<tns_alias_for_db> server=ODISRV instance=2\u00a0 host=<hostname> configset=1 flags=”port=oid_port” start<\/p>\n

Note*\u00a0There could be\u00a0other reasons for above error message and above example is one of them.<\/font><\/p>\n

References<\/u><\/strong><\/p>\n