DM_ORACLE Error Message: dm_read_subrow_multi_select: do_post_select_process failed (Doc ID 407860.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 6.2.0.1.1 and later
HP 9000 HP-UX 11.0 (32 bit)
HP-UX PA-RISC (32-bit)
Oracle Solaris on SPARC (32-bit)
***Checked for relevance on 04-Oct-2011***


Symptoms

Doing a step search with a step greater than 4 make the DM_ORACLE fail for: "do_post_select_process failed".

The following statement is shown (with DM_DEBUG flags set):

SQL_STMT dm_search_robj: cmd="select
event_t.poid_DB, event_t.poid_ID0, event_t.poid_TYPE, event_t.poid_REV, event_t.created_t, event_t.account_obj_DB, event_t.account_obj_ID0, event_t.account_obj_TYPE, event_t.account_obj_REV, event_t.service_obj_DB, event_t.service_obj_ID0, event_t.service_obj_TYPE, event_t.service_obj_REV
from event_t,mrg_event_com_t
where mrg_event_com_t.batch_no = :1
and event_t.poid_type = '/event/com'
and event_t.poid_id0 = mrg_event_com_t.obj_id0"


and these error is shown in the dm pinlog:


E Wed Jan 22 11:26:25 2003 s02f01 dm:20636 dm_subr.c(55.1.1):3105
dm_read_subrow_multi_select: do_post_select_process failed select obj_id0, type, media, email_address, data_str1, data_str2, data_int1, data_int2, data_date, data_amount, custom_data from mrg_event_com_t
where obj_id0 in (:1,:2,:3,:4,:5,:6,:7,:8,:9,:10)
E Wed Jan 22 11:26:25 2003 s02f01 dm:20636 dm_subr.c(55.1.1):2448
dm_read_subrow: dm_read_subrow_multiple_select failed


while in dm console logs the following messages are found:

DDD do_sql_mr_select: OCIStmtExecute (0x14efbc) to fetch a maximum of 4 rows
DDD do_sql_mr_select: rows this fetch (0x14efbc): 4, total 4, retval 0
DDD do_sql_mr_select: OCIStmtFetch (0x14efbc) to fetch a maximum of 4 rows
DDD do_sql_mr_select: rows this fetch (0x14efbc): 4, total 8, retval 0

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