Unable To Populate Data In Queue On A Third DB Using Account Sync DM Component (Doc ID 1086786.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.1]
Information in this document applies to any platform.
Checked for relevance on 04-Jan-2012.

***Checked for Relevance on 4th August 2014***

Goal

 

Below is a problem scenario :

  1. Installed Account Synch DM on one HP-UX instance, on which BRM is installed.
  2. Installed Pipeline on another HP-UX instance.
  3. Installed Database Queues on a third instance.
  4. Created the Database link from DB instance 1) to DB instance 2) so as to populate data in queues through the account synch DM.
  5. Set enable_publishing entry in cm pin.conf to '1'.
  6. Populated the /config/notify object with all the account synch opcodes.

When a new account is created in BRM, below error is thrown :

dm_ifw_sync.pinlog snippet

E Wed Mar 3 15:16:20 2010 BRMXX dm:28808 ../../ifw_sync.cpp:981 1:BRMXX :Custome1301:1267611380:37
At line 679: Error - OCI_ERROR ORA-06550: line 1, column 7:
PLS-00352: Unable to access another database 'PINDEVDB2'
ORA-06550: line 1, column 7:
PLS-00201: identifier 'ACCT_SYNC@PINDEVDB2' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

E Wed Mar 3 15:16:20 2010 BRMXX dm:28808 ../../ifw_sync.cpp:703 1:BRMXX:Custome1301:1267611380:37
Enqueueing. Event: CustCreate, flist length: 83, Call Seq#: 1
E Wed Mar 3 15:16:20 2010 BRMXX dm:28808 ../../ifw_sync.cpp:716 1:BRMXX:Custome1301:1267611380:37
Failed While En-queuing:
Event: CustCreate
Flist Buffer: 0 40 7 0 0.0.0.1 /account 18103114 0
0 1893 5 0 "CustCreate"
0 62 8 0 (1267611376)

Solution

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