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 laterInformation 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
# 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>
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 |