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.
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.
1. Set locale to English US.
2. Try to use SQLite DB engine.
SQLite is available starting from LR 11.51