Dm_oracle Error: Cannot Create POID_ID Greater Than 2147483647 (2^31 - 1)
(Doc ID 1529855.1)
Last updated on FEBRUARY 15, 2024
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 dm:24573 dm_do_ops.c(87):2507 1:1359615014:20658
NOTICE OP_ROBJ: do_sql_select() NOTHING FOUND ("/reservation_list", 2149713882)
E Thu Jan 31 07:50:14 2013 dm:24573 dm_back.c(31):1440 1: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 dm:24573 dm_do_ops.c(87):2507 1:1359615014:20658
NOTICE OP_ROBJ: do_sql_select() NOTHING FOUND ("/reservation_list", 2149713882)
E Thu Jan 31 07:50:14 2013 dm:24573 dm_back.c(31):1440 1: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 dm:24573 dm_ops.c(228):1577 1:1359615014:20658
Cannot Create the poid_id greater than 2147483647
E Thu Jan 31 07:50:14 2013 dm:24573 dm_back.c(31):1440 1:1359615014:20658
DMbe #40: process_op: op 1(PCM_OP_CREATE_OBJ), err 4(PIN_ERR_BAD_ARG)
NOTICE OP_ROBJ: do_sql_select() NOTHING FOUND ("/reservation_list", 2149713882)
E Thu Jan 31 07:50:14 2013 dm:24573 dm_back.c(31):1440 1: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 dm:24573 dm_do_ops.c(87):2507 1:1359615014:20658
NOTICE OP_ROBJ: do_sql_select() NOTHING FOUND ("/reservation_list", 2149713882)
E Thu Jan 31 07:50:14 2013 dm:24573 dm_back.c(31):1440 1: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 dm:24573 dm_ops.c(228):1577 1:1359615014:20658
Cannot Create the poid_id greater than 2147483647
E Thu Jan 31 07:50:14 2013 dm:24573 dm_back.c(31):1440 1:1359615014:20658
DMbe #40: process_op: op 1(PCM_OP_CREATE_OBJ), err 4(PIN_ERR_BAD_ARG)
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |