Difference between revisions of "ITrack/IDispatch error 31826"

Latest revision as of 15:37, 12 May 2016

Failed to retrieve data from the database.

This error occurs when Crystal was able to connect to a MySQL database, but the report query returned with an error.

Possible reasons the query would fail:

Something wrong with the report you are trying to print.
- Report isn't up-to-date
- User's database is not up to date
- Correct parameters were not passed in to the report.
The ODBC driver is pointed at the wrong server.
The wrong report may be referenced in Edit > Options > Reports tab, causing ITrack to think that incorrect parameters are being passed in.
If you are able to successfully run the report query in SQLYog, but the report still won't print, try checking on the definers for the functions related to files/attachments.

@@ Line 1: / Line 1: @@
-[[Image:IDispatchError31826.JPG|400px|thumb|left]]
+[[Image:IDispatchError31826.png]]
-This error occurs because there is something wrong with the report you are trying to print.
+Failed to retrieve data from the database.
-You will need to edit the report, submit it to SVN, and put the updated report in the customer's reports directory.
+== Cause ==
+This error occurs when Crystal was able to connect to a MySQL database, but the report query returned with an error.
-------------------------
+== Solution ==
+Possible reasons the query would fail:
-Another possibility is that this error appears because the ODBC driver is pointed at the wrong server.
+* Something wrong with the report you are trying to print.
+** Report isn't up-to-date
+** User's database is not up to date
+** Correct parameters were not passed in to the report.
+* The ODBC driver is pointed at the wrong server.
+* The wrong report may be referenced in Edit > Options > Reports tab, causing ITrack to think that incorrect parameters are being passed in.
+* If you are able to successfully run the report query in SQLYog, but the report still won't print, try checking on the definers for the functions related to files/attachments.
-[[Category:Printing Error Messages (ITrack)]]
+[[Category:ITrack/Printing Error Messages]]
 [[Category:ITrack/Support]]