LoadRunner Practitioners Forum
Showing results for 
Search instead for 
Do you mean 

The SQL Query produced by the Analysis server is invalid - issue

Occasional Advisor

The SQL Query produced by the Analysis server is invalid - issue

Hi All,

 

I have this "The SQL Query produced by the Analysis server is invalid" error message when I tried to analyze the results after 17 hours duration of a load test execution.

 

The SQL Query produced by the Analysis server is invalid

Cannot open database ''.  It may not be a database that your application recognizes, or the file may be corrupt.

 

Any suggestion?

 

Thanks,

Tareq Hadid

1 REPLY
Highlighted
Occasional Advisor

Re: The SQL Query produced by the Analysis server is invalid - issue

What DB type do you use?

I assume this is Access.

I see 2 possible reasons:

1. Access DB reached 2 GB file size limit. 
  Suggestion: try to use SQLIte or SQL Server (or SQL Server Express, it is free and DB size limit is 10GB)

2. There is some issues with the locale settings. What is your locale?

    Analysis imports data to Access and SQL server using .csv files. This operation may be sensitive to the decimal point separator and list separator in regional settings.

   Suggestions:

  1. Set locale to English US.

  2. Try to use SQLite DB engine.

 

Note:

SQLite is available starting from LR 11.51

Sergey Chernikov
HP LoadRunner R&D