My Oracle Support Banner

Unable to Populate Data in Queue on a Third DB Using Account Sync DM Component (Doc ID 1086786.1)

Last updated on MARCH 01, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 to 7.3.1.0.0 [Release 7.3.0]
Information in this document applies to any platform.

Goal

Below is the 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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