My Oracle Support Banner

Suspense Manager Not Working On Second Node In Multi-Schema Environment (Doc ID 1090315.1)

Last updated on AUGUST 08, 2023

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

1) Recycling through Suspense manager and PCM_OP_SUSPENSE_RECYCLE_USAGE fails with the error message ERR_TRANS_ALREADY_OPEN. This error occur only when recycling /suspended_usage object is loaded into secondary schema.

cm.pinlog: 
-------------------------------------------------------------------- 
 D Sat Feb 20 17:54:40 2010  cm_batch:1123  cm_child.c(106):4357 
 1:UnknownProgramName:0:Thread-27:4450:1270666874:0 
CMAP: op_custom() past op_decode, opcode: PCM_OP_SUSPENSE_RECYCLE_USAGE 
D Sat Feb 20 17:54:40 2010    cm_batch:1123   
fm_suspense_recycle_usage.c:131 
1:UnknownProgramName:0:Thread-27:4450:1270666874:0 
op_suspense_recycle_usage input flist 
# number of field entries allocated 20, used 5 
0 PIN_FLD_POID           POID [0]<IP>
/admin_action/suspended_usage/recycle -1 0 
0 PIN_FLD_OVERRIDE_REASONS    STR [0] "" 
0 PIN_FLD_MODE           ENUM [0] 1 
0 PIN_FLD_PROGRAM_NAME    STR [0] "Suspense Management Center" 
0 PIN_FLD_SUSPENDED_USAGE_OBJS  ARRAY [0] allocated 20, used 1 
1     PIN_FLD_SUSPENDED_USAGE_OBJ   POID [0] 0.0.0.2 
/suspended_usage/telco/gsm 1152921504923268021 0 

 

2) Also suspense manager center GUI displays entries which represent /suspended_usage objects from both schemas. Is there a way to avoid this behavior? E.g: logging under 0.0.0.1 would show only events for DB2 and logging under 0.0.0.2 would show only suspended events for DB2

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.