Custom Outbound Provisioning Profile Throws Exception [DIP-20364] and Does Not Propagate Events (Doc ID 1907372.1)

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

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

orclODIPProfileName=<PROVISIONING_PROFILE_NAME>, cn=Provisioning Profiles, cn=Changelog Subscriber, cn=Oracle Internet Directory
orclodipprofilemetric;failure_count=0
orclodipprofilemetric;success_count=0
orclsubscriberdisable=0
orclodipprovisioningeventsubscription=USER:dc=<COMPANY>,dc=com:ADD(usr_xxx,usr_xxx)
orclodipprovisioningeventsubscription=USER:dc=<COMPANY>,dc=com:MODIFY(usr_xxx,usr_xxx)
orclodipprovisioningeventsubscription=USER:dc=<COMPANY>,dc=com:DELETE(usr_xxx,usr_xxx)
orclodipprovisioningorgguid=xxxxxxxxxxxxxxxxx
orclversion=1.0
orclstatus=ENABLED
orclodipprofileinterfacename=<APP NAME>
orclodipprofilename=<PROVISIONING_PROFILE_NAME>
orclodipprovisioningappguid=xxxxxxxxxxxxxxxxxxx
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:

DIP # 11.1.1.2 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)

The connection to the remote database is successful. Example from Log:

[2014-07-09T16:33:55.689-06:00] [wls_ods1] [NOTIFICATION] [] [oracle.dip.<EXPORT_PROFILE_NAME>] [tid: <EXPORT_PROFILE_NAME>] [userId: <anonymous>]
[ecid: <ECID>] [APP: DIP#11.1.1.2.0] Using Service Name to connect - URL : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<DB_HOST>)(PORT=<DB_PORT>))(CONNECT_DATA=(SERVICE_NAME=<SERVICE_NAME>))),user : MYAPP
[2014-07-09T16:33:55.749-06:00] [wls_ods1] [NOTIFICATION] [DIP-20051] [oracle.<EXPORT_PROFILE_NAME>] [tid: <EXPORT_PROFILE_NAME>] [userId: <anonymous>] [ecid: <ECID>] [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

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