For most of these you will need to recycle the report service
Method not found
This will usually be error along these lines as soon as you try to run the report:
"An error occured generating the document. Method not found"
This can also sometimes show as different errors eg.
"FileNotFoundException: Could not load file or assembly"
Check that the report service AppPool is running with 32bit disabled
The File Exists
If after running the report you see an error along the lines of
"An error occured generating the document. The file exists"
Also in the report service logs you will see something along the lines of:
2019-10-10 05:00:25.0366 Error System.IO.IOException: The file exists.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Path.InternalGetTempFileName(Boolean checkHost)
at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.FormatEngine.ExportToStream(ExportRequestContext reqContext)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportOptions options)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.ExportToStream(ExportFormatType formatType)
at ReportWebServices.Domain.Services.ReportService.GetReport(Guid guid, String& fileName)
at ReportWebServices.Web.Api.ReportController.GetReport(Guid guid)
This is most likely due to C:\Windows\Temp exceeding 65,000 files, clearing the temp folder will resolve the issue
Failed to Open the Connection
After running the report you receive an error along these lines, also on some (but not all) reports won't load the prompts.
An error occured generating the document. Failed to open the connection. Details: [Database Vendor Code: 17 ] Failed to open the connection.
You may also see an error along these lines in backend jobs for user reports:
Message: Cannot create PDF from [....] for message System.Exception: Unable to retreive stream from guid:[.....]
System.Net.WebException: The remote server returned an error: (500) Internal Server Error.
- Check the report validation entries are setup for the correct database
- Check the ClickHome.Reporting.RepServerURL setting
- If this is a large report you may have to increase the report service timeout window:
Something went wrong
When trying to load the report you get an error along these lines, the technical message will be as follows
This is a more generic error, there are a few known causes:
- The report itself is inaccessible, check that the report exists and is accessible by the reports service
- Can't connect to report service DB, check the connection string to the report service database is correct
- Check the setting ClickHome.Reporting.RepServerAPIKey exists and the key is correct