My Oracle Support Banner

Transaction Abort in dm_aq When Calling PCM_OP_PUBLISH_GEN_PAYLOAD from Custom Code (Doc ID 2568671.1)

Last updated on JULY 26, 2019

Applies to:

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

Symptoms

PCM_OP_PUBLISH_GEN_PAYLOAD publishes message to dm_aq and reports transaction abort in dm_aq when calling from custom code, but the user gets success response from PCM_OP_PUBLISH_GEN_PAYLOAD.

When the same flist is called from testnap for opcode, PCM_OP_PUBLISH_GEN_PAYLOAD is successful and dm_aq commits the message.

Sample input FLIST:

custom_fm_publish_order: final publish_flistp for PCM_OP_PUBLISH_GEN_PAYLOAD
# number of field entries allocated 20, used 6
0 PIN_FLD_PROGRAM_NAME STR [0] "ORDER"
0 PIN_FLD_ORDER_ID STR [0] "ORDER_ID"
0 PIN_FLD_TRANSACTION_ID DECIMAL [0] 998851
0 PIN_FLD_ACCOUNTS ARRAY [0] allocated 20, used 7
1 PIN_FLD_ERROR_CODE STR [0] "BRM_SUCCESS"
1 PIN_FLD_ERROR_DESCR STR [0] "BRM_SUCCESS"
1 PIN_FLD_PROCESS_END_T TSTAMP [0] (1563273314) Tue Jul 16 06:35:14 2019
1 PIN_FLD_POID POID [0] 0.0.0.1 /order_bill_to 6750961 0
1 PIN_FLD_ACTION STR [0] "ADD"
1 PIN_FLD_ACCOUNT_NO STR [0] "Account"
1 PIN_FLD_SUBORD_INFO ARRAY [0] allocated 20, used 7
2 PIN_FLD_ERROR_CODE STR [0] "BRM_SUCCESS"
2 PIN_FLD_ERROR_DESCR STR [0] "BRM_SUCCESS"
2 PIN_FLD_PROCESS_END_T TSTAMP [0] (1563273314) Tue Jul 16 06:35:14 2019
2 PIN_FLD_POID POID [0] 0.0.0.1 /order_ship_to 6753521 0
2 PIN_FLD_ACTION STR [0] "ADD"
2 PIN_FLD_ACCOUNT_NO STR [0] "Account"
2 PIN_FLD_SERVICES ARRAY [0] allocated 20, used 3
3 PIN_FLD_POID POID [0] 0.0.0.1 /account 6772750 0
3 PIN_FLD_BUNDLE_INFO ARRAY [0] allocated 20, used 7
4 PIN_FLD_POID POID [0] 0.0.0.1 /order_bundle_info 6751473 0
4 PIN_FLD_ERROR_CODE STR [0] "BRM_SUCCESS"
4 PIN_FLD_ERROR_DESCR STR [0] "BRM_SUCCESS"
4 PIN_FLD_PACKAGE_ID INT [0] 998851
4 PIN_FLD_ACTION STR [0] "ADD"
4 PIN_FLD_PROCESS_END_T TSTAMP [0] (1563273314) Tue Jul 16 06:35:14 2019
4 PIN_FLD_NAME STR [0] "<NAME>"
3 PIN_FLD_LOGIN STR [0] "<LOGIN>"
0 PIN_FLD_POID POID [0] 0.0.0.1 /event/order/status/employer -1 0
0 PIN_FLD_ACCOUNT_OBJ POID [0] 0

ERROR:

dm:82035  ../../ifw_sync_plugin.cpp:525 2:dm:82014:-147171584:0:1563091598:0::::
AbortTransaction called : pid = <PID>

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.