Custom Outbound Provisioning Profile Throws Exception [DIP-20364] and Does Not Propagate Events (Doc ID 1907372.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

A custom outbound DIP provisioning profile was created with the following attributes:

orclODIPProfileName=EB234F0682A9F858E0301490D5A208E8_FC1AC66E49E5E9D8E0404598C34862AD, cn=Provisioning Profiles, cn=Changelog Subscriber, cn=Oracle Internet Directory
orclodipprofilemetric;failure_count=0
orclodipprofilemetric;success_count=0
orclsubscriberdisable=0
orclodipprovisioningeventsubscription=USER:dc=oracle,dc=com:ADD(usr_elecsubs,usr_cmemb)
orclodipprovisioningeventsubscription=USER:dc=oracle,dc=com:MODIFY(usr_elecsubs,usr_cmemb)
orclodipprovisioningeventsubscription=USER:dc=oracle,dc=com:DELETE(usr_elecsubs,usr_cmemb)
orclodipprovisioningorgguid=EB234F0682A9F858E0301490D5A208E8
orclversion=1.0
orclstatus=ENABLED
orclodipprofileinterfacename=MYAPP.LDAP_INCOMING_NOTIFICATION
orclodipprofilename=eb234f0682a9f858e0301490d5a208e8_fc1ac66e49e5e9d8e0404598c34862ad
orclodipprovisioningappguid=FC1AC66E49E5E9D8E0404598C34862AD
orclodipprofileschedule=60
orclodipprofiledebuglevel=63
orclodipprofilemaxretries=5
orclodipprovisioningappname=OID_Subscription
orclodipprofileinterfaceversion=1.0
orclodipprofileexecgroupid=default
orcllastappliedchangenumber=109695387
objectclass=top
objectclass=orclODIPProvisioningIntegrationProfile
objectclass=orclChangeSubscriber
objectclass=orclODIPIntegrationProfile
orclodipprovisioningorgname=oracle
orclodipprofileinterfacetype=PLSQL
orclodipprofileprocessingstatus=Event Propagation Error
orclodipprofileprocessingerrors=DIP_GEN_SPACE_STR
orclodipprofilelastprocessingtime=20140708132800

The DIP managed server logs (eg wls_ods1-diagnostic-0000.log) shows that the provisioning fails with:

2014-07-09T16:23:00.825-06:00 wls_ods1 ERROR DIP-20364 http://oracle.dip.OID_Subscription_oracle_E tid: OID_Subscription_oracle_E userId: <anonymous> ecid: 7074efe8b941a9bd:3b029044:1468a872d30:-8000-0000000000000003,0 APP: DIP#11.1.1.2.0 Exception in user group lookup or event propagation[[java.sql.SQLException: ORA-06550: line 1, column 48:
PLS-00302: component 'USER_EXISTS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at oracle.ldap.odip.prov.ProvWriter.entryExists(ProvWriter.java:361)
at oracle.ldap.odip.prov.ProvWriter.writeChanges(ProvWriter.java:291)
at oracle.ldap.odip.web.DIPProvBean.mapExecute(DIPProvBean.java:1236)
at oracle.ldap.odip.web.DIPProvBean.execMapping(DIPProvBean.java:1097)
at oracle.ldap.odip.web.DIPProvBean.runOldVersion(DIPProvBean.java:1082)
at oracle.ldap.odip.web.DIPProvBean.doOneIteration(DIPProvBean.java:628)
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:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:529)

]]

 

The connection to the remote database is successful.for example, we can see this in the logs as:

[2014-07-09T16:33:55.689-06:00] [wls_ods1] [NOTIFICATION] [] [oracle.dip.OID_Subscription_oracle_E] [tid: OID_Subscription_oracle_E] [userId: <anonymous>]
[ecid: 7074efe8b941a9bd:3b029044:1468a872d30:-8000-0000000000000003,0] [APP: DIP#11.1.1.2.0] Using Service Name to connect - URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myoidhost-vip.oracle.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=oid1.oracle.com))),user : MYAPP
[2014-07-09T16:33:55.749-06:00] [wls_ods1] [NOTIFICATION] [DIP-20051] [oracle.dip.OID_Subscription_oracle_E] [tid: OID_Subscription_oracle_E] [userId: <anonymous>] [ecid:7074efe8b941a9bd:3b029044:1468a872d30:-8000-0000000000000003,0] [APP: DIP#11.1.1.2.0] Database Connection is successful.


The LDAP_INCOMING_NOTIFICATION package on the remote database compiles successfully. It makes no reference to 'USER_EXISTS'.



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