My Oracle Support Banner

DM_ORACLE Coredumps When Doing Search For /Invoice Objects (Doc ID 579899.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version to [Release 7.3.0]
Information in this document applies to any platform.
Checked for relevance on 17-Mar-2011
***Checked for relevance on 09-Nov-2012***


When PCM_OP_SEARCH is called with the following input flist, dm_oracle coredumps.

0 PIN_FLD_POID POID [0] /search -1 0
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1    PIN_FLD_ACCOUNT_OBJ POID [0] /account 496497 0
0 PIN_FLD_TEMPLATE STR [0] "select X from /invoice where F1 = V1 "

Not all invoice searches has this problem. All of the invoices for this account can be read using PCM_OP_READ_OBJ.

Step search with step 1 runs all the way through.
Step search with step size 2 or more core dumps.

System was upgraded from 6.2SP4 -> 7.0 -> 7.3.

The following patch is installed:
7.3 + 4489 + 5903622 + 6491208 + 6781036 + 6754098

The search returns some results but coredumps at some point. Some of the invoice objects doesn't
have PIN_FLD_FORMATS array as it's removed by PCM_OP_DELETE_FLDS because they are old.

dm_oracle.log has the following stack trace:


DDD op_robj dm_read_subrows_wild (invoice_formats_t) said 0
DDD do_robj: tip2 0x148e18 (invoice_formats_buf_t) ?= tip 0x148e08 (invoice_formats_t)
DDD do_robj: CHILD: tip2 0x148e18 (invoice_formats_buf_t) flags: 0x2
DM(21955) got SIGV...
Stack Trace (21955) :
/7.3/bin/dm_oracle:print_traceback+0x0(0x0, 0x0, 0x0, 0x0, 0x0, 0xffbffeff)
/7.3/bin/dm_oracle:sigsegv_handler+0x50(0x0, 0x0, 0x0, 0x0, 0x0, 0x0)
/lib/, 0x0, 0xffbe1bf0, 0x0, 0x0, 0x0)
??:??+0xefdb6508(0x0, 0x0, 0x148e08, 0xeedeb5f8, 0x4, 0xeedeb5f8)
/7.3/sys/dm_oracle/, 0x0, 0x0, 0x3846c75, 0x84000, 0x3ea80)
/7.3/sys/dm_oracle/, 0x0, 0xffbe9d84, 0x100,
0xfee6862c, 0xffbe9d84)
/7.3/sys/dm_oracle/, 0x0, 0xffbee170, 0x0, 0xff000000,
/7.3/sys/dm_oracle/, 0x1be0, 0x0, 0x0,
0xed1f3d5f, 0x1c00)
/7.3/sys/dm_oracle/, 0x0, 0xb, 0x55c3, 0x7, 0x459a8)

Opcode called: PCM_OP_INVALID
Opcode flags: 11

Steps To Reproduce:
Call PCM_OP_SEARCH from testnap with the input flist mentioned above.


To view full details, 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 a vibrant support community of peers and Oracle experts.