Difference between revisions of "ITrack/IDispatch error 31826"

Revision as of 14:57, 7 February 2010

"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:

The ODBC driver is pointed at the wrong server.
Correct parameters were not passed in to the report
Something wrong with the report you are trying to print (it is not up to date, or the user's database is not up to date).

@@ Line 1: / Line 1: @@
+"Failed to retrieve data from the database."
 [[Image:IDispatchError31826.JPG|400px|thumb|left]]
-Possible solutions for this error message:
+== Cause ==
+This error occurs when Crystal was able to connect to a MySQL database, but the report query returned with an error.
-# The ODBC driver is pointed at the wrong server.
+== Solution ==
-# The user has not entered all of the required parameters for the report to run.
+Possible reasons the query would fail:
-# 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.
+* The ODBC driver is pointed at the wrong server.
+* Correct parameters were not passed in to the report
+* Something wrong with the report you are trying to print (it is not up to date, or the user's database is not up to date).
 [[Category:Printing Error Messages (ITrack)]]
 [[Category:ITrack/Support]]