cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Lansweeper
Lansweeper Tech Support
Lansweeper Tech Support

If you install the Lansweeper database under Microsoft SQL Server or Microsoft SQL LocalDB, any built-in or custom reports seen in the Reports tab of the web console are added as views to your SQL instance. Report views are called "web40rep..." or "web50rep...".

If someone deletes report views from your SQL instance, or if your Lansweeper database is moved without moving the report views as well, you will encounter one of the errors below when opening the affected reports in the Reports tab of the web console. The exact error message depends on the Lansweeper version used. The name of the missing report view can be seen in the web console URL.

Error: ExecuteReader: CommandText property has not been initialized
executereader-commandtext-property-has-not-been-initialized-1.jpg
Error: Report cannot be found
executereader-commandtext-property-has-not-been-initialized-3.jpg
executereader-commandtext-property-has-not-been-initialized-2.jpg

To resolve these errors and regain access to the affected reports, do one of the following:

  • If you previously created one, restore a database backup that still contains the report views. More info on restoring database backups can be found in this knowledge base article.
  • If the reports were built-in, retrieve the faulty reports' original SQL queries from our report center and use these queries to recreate the reports in Lansweeper. Our report center stores all built-in reports.  Instructions for importing a report from a SQL query can be found in this knowledge base article.
Was this article helpful? Yes No
No ratings

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now
Version history
Last update:
‎06-05-2024 09:17 AM
Updated by: