PC analysis hangs on generating complete result data

  • KM01035531
  • 11-Jul-2014
  • 28-Jul-2016

Summary

PC analysis hangs on generating complete result data. The root cause of the issue is that the result data size too large to be handled by MS Access database. The issue is resolved by using SQL lite database directly with Analysis.

Error

When generating complete analysis data process, Performance Center Analysis hangs after 70% and nothing happens.

Cause

The root cause of the issue is that the result data size too large to be handled by MS Access database.

One may see the following warning message before the result data is generated. Please find the snapshot of the warning message as below:

image text

Fix

Automatic analysis is not designed to work with big results. PC analysis generates complete result data based on the size of the analysis session file. One may need to select the recommended format based on the analysis session file size.

Please find the screenshot with the details as follows:

image text

In order to process huge result data faster, one needs to use SQL database with Analysis.

However one has this option only when using the Analysis directly and not via Performance center.

Please follow the below steps to set-up SQL lite database with Analysis:

1) Open the HP LoadRunner Analysis

2) Go to Tools -> Options

3) Click the Database tab

4) Choose SQLite option

5) Click OK

Please find below screenshot of the <Options> dialogbox for reference:

image text