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]]
-Possible solutions for this error message:
+Failed to retrieve data from the database.
-# The ODBC driver is pointed at the wrong server.
+== Cause ==
-# The user has not entered all of the required parameters for the report to run.
+This error occurs when Crystal was able to connect to a MySQL database, but the report query returned with an error.
-# This error occurs because there is something wrong with the report you are trying to print. You will need to edit the report, submit it to SVN, and put the updated report in the customer's reports directory.
-[[Category:Printing Error Messages (ITrack)]]
+== Solution ==
+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.
+[[Category:ITrack/Printing Error Messages]]
 [[Category:ITrack/Support]]