Re: The SQL Query produced by the Analysis server is invalid - issue (184 Views)
Reply
Occasional Advisor
Tareq_Hadid
Posts: 12
Registered: ‎12-02-2013
Message 1 of 2 (226 Views)

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

Occasional Advisor
schernikov
Posts: 10
Registered: ‎08-19-2011
Message 2 of 2 (184 Views)

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
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.