Unable To Edit Fields In Suspense Manager
(Doc ID 1592138.1)
Last updated on MARCH 23, 2019
Applies to:
Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]Information in this document applies to any platform.
Symptoms
Not able to edit fields in Suspense manager in schema 2.
However it can be seen that in Schema 1 it can be edited .
When one compares the logs of both schema 1 & 2.
It can be seen in schema 2, internally it is calling fm_bglock_make_template , but in schema 1, it is not calling that.
it tries to find below data from database and not able to find it, hence the following errors are seen
0 PIN_FLD_POID POID [0] 0.0.0.2 /account 2 0
0 PIN_FLD_LOCK_INFO SUBSTRUCT [0] allocated 20, used 2
1 PIN_FLD_TEMPLATE STR [0] "select X from /balance_group where F1 = V1 order by bal_grp_t.poid_id0 "
1 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
2 PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.2 /account 2 0
Query it executes in database : select * from bal_grp_t where account_obj_id0= 2 order by bal_grp_t.poid_id0;
But data that is present in database is select * from bal_grp_t where account_obj_id0= 1 order by bal_grp_t.poid_id0;
===
Cm log:
E Fri Jun 28 17:06:06 2013 <HOSTNAME> cm:14493 fm_suspense_edit_usage.c:733 1:<HOSTNAME>:UnknownProgramName:0:Thread-9:4451:1372433204:0
fm_suspense_update_suspended_usage error
E Fri Jun 28 17:06:06 2013 <HOSTNAME> cm:14493 fm_suspense_edit_usage.c:415 1:<HOSTNAME>:UnknownProgramName:0:Thread-9:4451:1372433204:0
fm_suspense_edit_usage error
E Fri Jun 28 17:06:06 2013 <HOSTNAME> cm:14493 fm_suspense_edit_usage.c:158 1:<HOSTNAME>:UnknownProgramName:0:Thread-9:4451:1372433204:0
op_suspense_edit_usage error
E Fri Jun 28 17:06:06 2013 <HOSTNAME> cm:14493 cm_child.c(119):4669 1:<HOSTNAME>:UnknownProgramName:0:Thread-9:4451:1372433204:0
op PCM_OP_SUSPENSE_EDIT_USAGE returned an error
DM log:
E Fri Jun 28 16:58:27 2013 testbrm dm:28301 dm_back.c(31):1440 1:<HOSTNAME>:UnknownProgramName:0:Thread-8:4451:1372432746:0
DMbe #15: process_op: op 5(PCM_OP_WRITE_FLDS), err 3(PIN_ERR_NOT_FOUND)
E Fri Jun 28 17:06:05 2013 testbrm dm:28301 dm_search.c(108):3725 1:<HOSTNAME>:UnknownProgramName:0:Thread-9:4451:1372433204:0
Lock tried on a non-existent object!
Lock Cmd-> select poid_DB, poid_ID0, poid_TYPE, poid_REV from bal_grp_t where bal_grp_t.account_obj_ID0 = :1 order by bal_grp_t.poid_id0 for update of bal_grp_t.poid_id0 ,BindValues-> :1=2,
E Fri Jun 28 17:06:06 2013 testbrm dm:28301 dm_ops.c(243):10497 1:<HOSTNAME>:UnknownProgramName:0:Thread-9:4451:1372433204:0
op_search_and_bulk_act: dm_search_rflds() failed: err=0(PIN_ERR_NONE)
W Fri Jun 28 17:06:06 2013 testbrm dm:28301 dm_do_ops.c(97):240 1:<HOSTNAME>:UnknownProgramName:0:Thread-9:4451:1372433204:0
do_lockobj_with_template: op_search_and_bulk_act failed
W Fri Jun 28 17:06:06 2013 testbrm dm:28301 dm_ops.c(243):4215 1:<HOSTNAME>:UnknownProgramName:0:Thread-9:4451:1372433204:0
op_wflds: do_lockobj_with_template failed
E Fri Jun 28 17:06:06 2013 testbrm dm:28301 dm_back.c(31):1440 1:<HOSTNAME>:UnknownProgramName:0:Thread-9:4451:1372433204:0
DMbe #15: process_op: op 5(PCM_OP_WRITE_FLDS), err 3(PIN_ERR_NOT_FOUND)
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 |
| Cause |
| Solution |
| References |