OID DIP 11g Provisioning Profile Fails with: DIP-20050 DIP-20345 Error initialzing ProvPLSQLWriter - ODI Exception while Initialising PLSQL Writer : DIP_GEN_SPACE_STR (Doc ID 2178282.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.

Symptoms

Setting up a Directory Integration Platform (DIP) 11g provisioning profile to synchronize, for example, Oracle Label Security (OLS) data from Oracle Internet Directory (OID) to a database.

Also following Document 1450227.1.

The profile fails with errors:

DIP-20050
DIP-20345
Error while initializing ProvPLSQLWriter

Log error stack example:

[2016-08-12T16:22:04.798+03:00] [wls_ods1] [ERROR] [DIP-20050] [oracle.dip.<profile>] [tid: <profile>] [userId: dip] [ecid: 0000KkDlYW3D4iL5IRw0yf1L0NdY000003,0] [APP: DIP#11.1.1.2.0] connecting as : URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=mydbhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MYDB))) , User : dip
...
[2016-08-12T16:22:04.798+03:00] [wls_ods1] [ERROR] [DIP-20345] [oracle.dip.<profile>] [tid: <profile>] [userId: dip] [ecid: 0000KkDlYW3D4iL5IRw0yf1L0NdY000003,0] [APP: DIP#11.1.1.2.0] Error while initializing ProvPLSQLWriter
...
Error initialzing ProvPLSQLWriter - ODI Exception while Initialising PLSQL Writer : DIP_GEN_SPACE_STR
at oracle.ldap.odip.prov.ProvPLSQLWriter_2_0.initialise(ProvPLSQLWriter_2_0.java:72)
at oracle.ldap.odip.prov.ProvOIDToAppSync_2_0.initialise(ProvOIDToAppSync_2_0.java:202)
at oracle.ldap.odip.web.DIPProvBean.runOldVersion(DIPProvBean.java:1068)
at oracle.ldap.odip.web.DIPProvBean.doOneIteration(DIPProvBean.java:627)
at oracle.ldap.odip.web.DIPProv_o70i40_EOImpl.__WL_invoke(Unknown Source)
at weblogic.ejb.container.internal.SessionRemoteMethodInvoker.invoke(SessionRemoteMethodInvoker.java:40)
at oracle.ldap.odip.web.DIPProv_o70i40_EOImpl.doOneIteration(Unknown Source)
at oracle.ldap.odip.web.ProvQuartzJobImpl.execute(ProvQuartzJobImpl.java:174)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

(There is no "caused by" follow up stack.)

Tried restarting the entire stack, including rebooting the server, but it did not help.

Able to successfully connect from a command prompt on the OID server, using the same connect string as in the profile:

 

Also verified the hostname in the connect string is not a SCAN listener.

 

Changes

 

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