Correlating Oracle 2 tier protocol script (129 Views)
Reply
Occasional Contributor
jksrecko
Posts: 5
Registered: ‎02-04-2014
Message 1 of 4 (129 Views)

Correlating Oracle 2 tier protocol script

Hi,

 

We are evaluating LoadRunner (11.52 Patch1) for performance testing here at Croatia osiguranje d.d. and are having trouble replaying Oracle 2 tier scripts.

 

It seems that Correlation/Async studio isn't available for that protocol, and the approach suggested by the documentation (11.50 VuGen User Manual), i.e. using Snapshot Pane isn't very usable.

 

To illustrate the problem on a simple example, we have a SELECT statement on a sequence (for a primary key) prior to inserting new data. The actual retreival of the sequence value isn't recorded (no lrd_ora8_fetch call), and there is no data grid with the respective value in the Snapshot Pane (for manual correlation using GUI). However, the value is used for the next SQL statement (it's bound to a statement parameter). Of course, the script fails to replay due to unique constraint on the database.

We managed to correlate the script manually. This involved inserting lrd_ora8_bind_col, lrd_ora8_attr_set, lrd_ora8_save_col and lrd_ora8_fetch calls, and declaring additional variables in vdf.h (which by default isn't even visible in the Solution Explorer). While this proof-of-concept gives us hope, we feel that this should be much easier to accomplish in VuGen. Could we be doing something wrong?

 

We are using Oracle 11g database and the application is accessing the DB using 11g client.

 

Please use plain text.
HP Expert
vmanolova
Posts: 407
Registered: ‎05-24-2012
Message 2 of 4 (108 Views)

Re: Correlating Oracle 2 tier protocol script

Hi,

 

Do you have lrd_ora8_print generated instead of lrd_ora8_fetch function?


Looking forward to your replay.

 

Kind regards,

Vesela

HP Support
If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Please use plain text.
Occasional Contributor
jksrecko
Posts: 5
Registered: ‎02-04-2014
Message 3 of 4 (91 Views)

Re: Correlating Oracle 2 tier protocol script

No, we don't have lrd_ora8_print function calls in any of the recorded scripts...
Please use plain text.
HP Expert
vmanolova
Posts: 407
Registered: ‎05-24-2012
Message 4 of 4 (89 Views)

Re: Correlating Oracle 2 tier protocol script

Hi, 

 

The script is generated in accordance to initial Application under test activity. To be able to give you more specific answer we will need to review the script.

 

Kind regards,

 

 

HP Support
If you haven’t tried it yet, come and join us in our entitled forums at Support Customer Forums
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Please use plain text.
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