Re: BSM not recognising the transactions in Java JDBC API based VUGen script (275 Views)
Reply
Occasional Contributor
SharathC
Posts: 6
Registered: ‎01-27-2014
Message 1 of 5 (375 Views)

BSM not recognising the transactions in Java JDBC API based VUGen script

BSM ver. 9.22.131

LoadRunner VUGen ver. 11.51

 

We have a small VUGen script for making a simple test connection to the Teradata database server. We have used Java JDBC API for creating the scripts with proper transaction marker inside the script and needless to say, the entire script is handwritten in Java. The script is working fine in the VUGen. But, when the same script is uploaded into the BSM, the transaction names are not recognised in the BSM. Whenever we try to pull any kind of report, BSM says 'No data'. Please provide your suggestions to resolve this.

 

Here is the BPM 'Run Task' MDRV log which could be useful for analysis:

 

30/01/2014 00:05:32 Notify: Found jdk version: 1.6.0. [MsgId: MMSG-22986]  
30/01/2014 00:05:32 Notify: classpath=D:\ProgramData\HP\BPM\workspace\agent1\task_invoker\_uid_24_\Teradata_DB\res;d:\program files (x86)\hp\bpm\classes\srv;d:\program files (x86)\hp\bpm\classes;D:\Program Files (x86)\HP\BPM\classes;D:\Program Files (x86)\HP\BPM\classes\srv;C:\Program Files (x86)\Java\jdk1.6.0_38\jre\lib\rt.jar;C:\Users\nkumar\Downloads\custom.jar;C:\Users\nkumar\Downloads\pim-jar-with-dependencies.jar;;;D:\ProgramData\HP\BPM\workspace\agent1\task_invoker\_uid_24_\Teradata_DB\tdgssconfig.jar;D:\ProgramData\HP\BPM\workspace\agent1\task_invoker\_uid_24_\Teradata_DB\terajdbc4.jar;;d:\program files (x86)\hp\bpm\lib\xstream-1.3.jar;d:\program files (x86)\hp\bpm\lib\xpp3-1.1.4c.jar [MsgId: MMSG-22986]  
30/01/2014 00:05:33 Notify: Path=C:\Program Files (x86)\Java\jdk1.6.0_38\jre\bin\client;C:\Program Files (x86)\Java\jdk1.6.0_38\bin;D:\Program Files (x86)\HP\BPM\bin;C:\Program Files (x86)\Java\jdk1.6.0_38\jre\bin;C:\Program Files (x86)\HP\Virtual User Generator\strawberry-perl\perl\bin [MsgId: MMSG-22986]  
30/01/2014 00:05:33 Notify: VM Params: . [MsgId: MMSG-22986]  
30/01/2014 00:05:37 Virtual User Script started at : 1/30/2014 12:05:37 AM [MsgId: MMSG-15967]  
30/01/2014 00:05:37 Starting action vuser_init. [MsgId: MMSG-15919]  
30/01/2014 00:05:37 Notify: Transaction "Teradata-V1_BPM_T01_InitConnToTeradata" started. [MsgId: MMSG-16999]  
30/01/2014 00:05:44 Notify: Transaction "Teradata-V1_BPM_T01_InitConnToTeradata" ended with "Pass" status (Duration: 7.1397). [MsgId: MMSG-16873]  
30/01/2014 00:05:44 Non-registered transaction 'Teradata-V1_BPM_T01_InitConnToTeradata' was executed in the script. Continue... [MsgId: MWAR0]  
30/01/2014 00:05:44 Ending action vuser_init. [MsgId: MMSG-15918]  
30/01/2014 00:05:44 Running Vuser... [MsgId: MMSG-15964]  
30/01/2014 00:05:44 Starting iteration 1. [MsgId: MMSG-15968]  
30/01/2014 00:05:44 Notify: max connections per server : 4  
30/01/2014 00:05:44 Starting action Actions. [MsgId: MMSG-15919]  
30/01/2014 00:05:44 Notify: Transaction "Teradata-V1_BPM_T02_ExecQuery" started. [MsgId: MMSG-16999]  
30/01/2014 00:05:44 Username from parameter : [removed] [MsgId: MMSG-17999]  
30/01/2014 00:05:44 Username from the server: [removed] [MsgId: MMSG-17999]  
30/01/2014 00:05:44 INFO: Success [MsgId: MMSG-17999]  
30/01/2014 00:05:44 Notify: Transaction "Teradata-V1_BPM_T02_ExecQuery" ended with "Pass" status (Duration: 0.1709). [MsgId: MMSG-16873]  
30/01/2014 00:05:44 Non-registered transaction 'Teradata-V1_BPM_T02_ExecQuery' was executed in the script. Continue... [MsgId: MWAR0]  
30/01/2014 00:05:44 Ending action Actions. [MsgId: MMSG-15918]  
30/01/2014 00:05:44 Ending iteration 1. [MsgId: MMSG-15965]  
30/01/2014 00:05:44 Ending Vuser... [MsgId: MMSG-15966]  
30/01/2014 00:05:44 Starting action vuser_end. [MsgId: MMSG-15919]  
30/01/2014 00:05:44 Notify: Transaction "Teradata-V1_BPM_T03_ShutdownConnToTeradata" started. [MsgId: MMSG-16999]  
30/01/2014 00:05:44 Notify: Transaction "Teradata-V1_BPM_T03_ShutdownConnToTeradata" ended with "Pass" status (Duration: 0.0346). [MsgId: MMSG-16873]  
30/01/2014 00:05:44 Non-registered transaction 'Teradata-V1_BPM_T03_ShutdownConnToTeradata' was executed in the script. Continue... [MsgId: MWAR0]  
30/01/2014 00:05:44 Ending action vuser_end. [MsgId: MMSG-15918]  
30/01/2014 00:05:44 Vuser Terminated. [MsgId: MMSG-15963]

Esteemed Contributor
haytham_hosny
Posts: 665
Registered: ‎04-21-2008
Message 2 of 5 (352 Views)

Re: BSM not recognising the transactions in Java JDBC API based VUGen script

Try to use the same username and password to connect to teradata database inside BPM.

I means to open BPM portal and then add run with specific username and password and put them all.
Thank you
Haytham Hosny
Occasional Contributor
SharathC
Posts: 6
Registered: ‎01-27-2014
Message 3 of 5 (345 Views)

Re: BSM not recognising the transactions in Java JDBC API based VUGen script

Could you please be more specific?

 

Just to elaborate more on the issue am facing:

Am using the same credentials in the script and BPM/BSM. In the script, I have parameterised only the username and password. I can able to see the BSM reading the parameters successfully in the CI properties. But, BSM fails to recognise the transactions I have created inside the VUGen script.

 

The outline of the script is like this:

 

public class Actions

{

    ...

    public int init() throws Throwable {

        lr.start_transaction("T01_SomeName");

        do_something;

        lr.end_transaction("T01_SomeName", lr.AUTO);

        return 0;

    }

 

    public int action() throws Throwable {

        lr.start_transaction("T02_SomeName");

        do_something;

        lr.end_transaction("T02_SomeName", lr.AUTO);

        return 0;

    }

 

    public int end() throws Throwable {

        lr.start_transaction("T03_SomeName");

        do_something;

        lr.end_transaction("T03_SomeName", lr.AUTO);

        return 0;

    }

}

 

BSM fails to recognise the transactions T01_SomeName, T02_SomeName & T03_SomeName. It says there are no transactions in the added script.

 

Any further suggestions are welcome.

 

Thanks for your reply.

Occasional Advisor
Chandan_Kumar
Posts: 9
Registered: ‎05-05-2010
Message 4 of 5 (288 Views)

Re: BSM not recognising the transactions in Java JDBC API based VUGen script

We are also facing same issue. 

 

Anyone please help.

HP Expert
PatWest
Posts: 832
Registered: ‎03-06-2008
Message 5 of 5 (275 Views)

Re: BSM not recognising the transactions in Java JDBC API based VUGen script

Do you use BPM 9.23 (what is your BPM version, please) ?

Please ask for this error in the Loadrunner forum:

"Non-registered transaction was executed in the script"

http://h30499.www3.hp.com/t5/LoadRunner-Support-Customer/bd-p/loadrunner-support-customer-forum#.Uyr...
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.