My Oracle Support Banner

Search On Object With REC_ID Greater Than 2GB Throws error (Doc ID 1681937.1)

Last updated on JUNE 29, 2018

Applies to:

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

Goal

On : BRM  7.3.1.0.0 version, DM

Issue :

    Search on object with rec_id greater than dedicated value (32 bit) does not work  

Scenario:

*  A custom class has been created with REC_ID as one of the column
*  After loading some data into the corresponding table, when we perform a search, it throws error

Input Flist:


0 PIN_FLD_POID           POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS           INT [0] 768
0 PIN_FLD_TEMPLATE        STR [0] "select X from /my/custom_class where F1 = V1 and F2 = V2 "
0 PIN_FLD_RESULTS       ARRAY [0] allocated 20, used 1
1     PIN_FLD_PRODUCTS      ARRAY [*] allocated 20, used 2
...
...


Output flist :

xop: opcode 7, flags 0
XOP "7" failed: err 43:PIN_ERR_STORAGE, field 0/0:0,
        loc 4:PIN_ERRLOC_DM, errclass 0:UNKNOWN, rec_id 0, resvd 0
# number of field entries allocated 20, used 2
0 PIN_FLD_POID           POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_ERR_BUF         ERR [0]
       

 


        
        

dm_oracle error :

E Wed Jul 02 10:33:01 2014  test  dm:29239  dm_subr.c(121):7810 1:test:testnap:18221:1:7:1402562783:1
        ORACLE error: do_sql_mr_select: PINStmtFetch: code 1455, op 0
        =ORA-01455: converting column overflows integer datatype
E Wed Jul 02 10:33:01 2014  test  dm:29239  dm_subr.c(121):6506 1:test:testnap:18221:1:7:1402562783:1
        dm_read_subrow_multi_select: do_sql_mr_select failed select rec_id, product_obj_DB, product_obj_ID0, product_obj_TYPE, product_obj_REV from mds_product_config_t where obj_id0 = :1
E Wed Jul 02 10:33:01 2014  test  dm:29239  dm_subr.c(121):6258 1:test:testnap:18221:1:7:1402562783:1
        dm_read_subrows_wild: dm_read_subrow_multiple_select failed



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.