PCM_OP_GLOBAL_SEARCH In Transaction Issue (Doc ID 1252625.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.1.0 [Release 7.4.0]
Information in this document applies to any platform.
***Checked for relevance on 10-May-2013***

Symptoms

Found an issue during the call of pcm_op_global_search inside read-write transaction. The environment is multi database one.
Here are the steps to reproduce the problem to get better description of the problem:-

Here is when the issue DOES NOT exist:
1) run testnap
2) run below opcode
===> database 0.0.0.1 from pin.conf "userid"
nap(3759)> r << EOF 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 0
0 PIN_FLD_TEMPLATE STR [0] "select X from /service/pcm_client where F1 = V1 "
0 PIN_FLD_RESULTS ARRAY [*] allocated 0, used 0
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /service/pcm_client -1 0
EOF
nap(3759)> xop 25 0 1

(25 = global search)

3) check output - for 3 schemas should be 3 objectes returned.

Here is when the issue DOES exist:
1) run testnap
2) open rw transaction
open rw - 0.0.0.1 / -1

3) run below opcode
===> database 0.0.0.1 from pin.conf "userid"
nap(3759)> r << EOF 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 0
0 PIN_FLD_TEMPLATE STR [0] "select X from /service/pcm_client where F1 = V1 "
0 PIN_FLD_RESULTS ARRAY [*] allocated 0, used 0
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1 PIN_FLD_POID POID [0] 0.0.0.1 /service/pcm_client -1 0
EOF
nap(3759)> xop 25 0 1

4) There is an issue - only one object is returned. There are ERROR entries connected with connection to dm2 and dm3. These is no issue withc such connection in case the transaction is not opened.


Expected solution: All objects should be returned. No error entries should be visible in cm pinlog

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