Highlighted
Absent Member.
Absent Member.
1270 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

Tags (1)
0 Likes
4 Replies
Highlighted
Absent Member.
Absent Member.

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
0 Likes
Highlighted
Contributor.
Contributor.

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

Based on the  Suggestion: try to use SQLIte or SQL Server (or SQL Server Express, it is free and DB size limit is 10GB)

 

@schernikov @Tareq_Hadid 

***Could you please explain how to convert Access to SQLLite or any other DBs?

 

Thanks in advance!

 

0 Likes
Highlighted
Contributor.
Contributor.

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

More details:
localhost_1.eve = 280MB (not sure what is this one)
output.mdb = 68MB

 

0 Likes
Highlighted
Trusted Contributor.. Trusted Contributor..
Trusted Contributor..

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

I think @schernikov meant to change db settings from Access to SQL lite in Analysis->Options.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.