Dm_oracle Error: Cannot Create POID_ID Greater Than 2147483647 (2^31 - 1) (Doc ID 1529855.1)

Last updated on NOVEMBER 08, 2016

Applies to:

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

Symptoms

On a 7.4  system the following issue was observed :
DM_Oracle throws error while trying to create /reservation_list object for newly created accounts if value of POID_IDS2 sequence is greater than 2147483647 (this is 2^31 - 1).

In the system the user has AAA – cm – dm_oracle.

Sequence POID_IDS2 with last value 2153518836.

Log dm_oracle:

W Thu Jan 31 07:50:14 2013 appomv3p dm:24573 dm_do_ops.c(87):2507 1:tavap2p:UnknownProgramNa9:1359615014:20658
   NOTICE OP_ROBJ: do_sql_select() NOTHING FOUND ("/reservation_list", 2149713882)
E Thu Jan 31 07:50:14 2013 appomv3p dm:24573 dm_back.c(31):1440 1:tavap2p:UnknownProgramNa9:1359615014:20658
   DMbe #40: process_op: op 3(PCM_OP_READ_OBJ), err 3(PIN_ERR_NOT_FOUND)
W Thu Jan 31 07:50:14 2013 appomv3p dm:24573 dm_do_ops.c(87):2507 1:tavap2p:UnknownProgramNa9:1359615014:20658
   NOTICE OP_ROBJ: do_sql_select() NOTHING FOUND ("/reservation_list", 2149713882)
E Thu Jan 31 07:50:14 2013 appomv3p dm:24573 dm_back.c(31):1440 1:tavap2p:UnknownProgramNa9:1359615014:20658
   DMbe #40: process_op: op 3(PCM_OP_READ_OBJ), err 3(PIN_ERR_NOT_FOUND)
E Thu Jan 31 07:50:14 2013 appomv3p dm:24573 dm_ops.c(228):1577 1:tavap2p:UnknownProgramNa9:1359615014:20658
   Cannot Create the poid_id greater than 2147483647
E Thu Jan 31 07:50:14 2013 appomv3p dm:24573 dm_back.c(31):1440 1:tavap2p:UnknownProgramNa9:1359615014:20658
   DMbe #40: process_op: op 1(PCM_OP_CREATE_OBJ), err 4(PIN_ERR_BAD_ARG)

 

Changes

 

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