BPM Oracle2Tier script runs ok, but BPM reports no data and "Failed to start"

Dear experts,

I have installed right now the BPM 9.60 and migrated all the scripts previously running on a BPM 9.53

Suddenly unter BPM 9.60 no Oracle2Tier script runs anymore. Actually all ORACLE scripts run fine but the BPM reports "Failed to start" and send no data to APM.

Snippet of the BPM log:

18/02/2025 20:08:01 Action.c(68): server_detach: ServerHandle=OraSrv3 [MsgId: MMSG-61000]
18/02/2025 20:08:01 Action.c(79): Query Successfull. Result is 55 which is > 0 [MsgId: MMSG-17999]
18/02/2025 20:08:01 Action.c(88): Notify: Transaction "BMF_DASH_BackEnd" ended with a "Pass" status (Duration: 0,1140). [MsgId: MMSG-16873]
18/02/2025 20:08:01 NOTIFY BPM: on_transaction_end callback received for BMF_DASH_BackEnd [MsgId: MMSG0]
18/02/2025 20:08:01 NOTIFY BPM: Manipulating json creation mode to handle nested transaction -> BMF_DASH_BackEnd [MsgId: MMSG0]
18/02/2025 20:08:01 NOTIFY BPM: trial trying to see json creation for user transaction -> BMF_DASH_BackEnd [MsgId: MMSG0]
18/02/2025 20:08:01 NOTIFY BPM: Invoking dump_jsons -> after user transaction BMF_DASH_BackEnd [MsgId: MMSG0]
18/02/2025 20:08:01 NOTIFY BPM: inside dump_json_as_file_per_tx nested txn, so push json_fpath into m_json_file_names C:\\ProgramData\MF\BPM\workspace\Invocation\19\337_2\res\\BMF_Dashboard_0.jsonnew [MsgId: MMSG0]
18/02/2025 20:08:01 NOTIFY BPM: inside dump_json_as_single_file C:\\ProgramData\MF\BPM\workspace\Invocation\19\337_2\res\\BMF_Dashboard.json.unfiltered [MsgId: MMSG0]
18/02/2025 20:08:01 Notify: Transaction "Action_Transaction" ended with a "Pass" status (Duration: 0,1173). [MsgId: MMSG-16873]
18/02/2025 20:08:01 Ending action Action. [MsgId: MMSG-15918]
18/02/2025 20:08:01 Ending iteration 1. [MsgId: MMSG-15965]
18/02/2025 20:08:01 Ending Vuser... [MsgId: MMSG-15966]
18/02/2025 20:08:01 Starting action vuser_end. [MsgId: MMSG-15919]
18/02/2025 20:08:01 Notify: Transaction "vuser_end_Transaction" started. [MsgId: MMSG-16999]
18/02/2025 20:08:01 Notify: Transaction "vuser_end_Transaction" ended with a "Pass" status (Duration: 0,0000). [MsgId: MMSG-16873]
18/02/2025 20:08:01 Ending action vuser_end. [MsgId: MMSG-15918]
18/02/2025 20:08:01 Vuser Terminated. [MsgId: MMSG-15963]
18/02/2025 20:08:01 NOTIFY BPM: inside dump_json_as_single_file C:\\ProgramData\MF\BPM\workspace\Invocation\19\337_2\res\\BMF_Dashboard.json.unfiltered [MsgId: MMSG0]

Same in Vugen log:

Action.c(60): lrd_ora8_fetch: StmtHandle=OraStm5, 1 row(s) fetched (no more data)
Action.c(67): session_end: SvcCtxHandle=OraSvc3, SessionHandle=OraSes3
Action.c(68): server_detach: ServerHandle=OraSrv3
Action.c(79): Query Successfull. Result is 55 which is > 0
Action.c(88): Notify: Transaction "BMF_DASH_BackEnd" ended with a "Pass" status (Duration: 12,2970).

But the BPM sais no and reports no data to APM:

I am using vugen 2023.01 and also made a brand new script for testing. But nothing has changed.

Any suggestions on this?Thanks!

  • Verified Answer

    +1

    Hi twinge,

    check this out
      https://portal.microfocus.com/s/article/KM000002771?language=en_US

    I perform this configuration change with each BPM client I upgraded to version 9.60, as many if not all clients suffer from this issue after the upgrade, no matter what protocol is used.

    Greetings - Siggi

    P.S.

    In case you don't have access to the document:

    The problem was resolved by modifying / adding the below parameter in the file BPM_config\topaz_data_server.cfg:

    Update <BPM_config>\topaz_data_server.cfg
    under
    [general]
    update or add
    EnableSamplePerTxMechanism=false


    Setting this parameter to false disables the creation of one json file per transaction.

    The default is no entry, which means EnableSamplePerTxMechanism = true
    A BPM restart is required after performing this change.

  • 0 in reply to 

    Thanks Siggi, I have access to the document and your suggestion solved the issue.

    P.S.: I had the same problem with vuser scripts and as workaround I turned them in http/html scripts. This made the trick as well.