Error "Failed with unknown error while parsing query"

This error occurs when running a data extract using a Data Extractor.

This error is a general error indicating that the query to your database has failed.

This occurs for different reasons. It is best to contact support so we can help determine exactly what the problem is.

For SchoolMAX

If this problem occurs on the SchoolMAX bridge, please consult the user manual "Chapter 1 - Preparing the Connection to SchoolMAX" on Page 5, under "Default SchoolMAX ODBC Connection, using Oracle Driver".

Make sure "Enable Query Timeout" is unchecked

The Notes section may have a suggestion that will help you fix this problem.

For Skyward

If this problem occurs on the Skyward data extractor, please consult the user manual "Chapter 1 - Preparing the Connection to Skyward" on Page 3, under "Configuring an ODBC Connection In Skyward".

At the end of this section there is a setting on the advanced tab that you need to make sure is set to: READ_UNCOMMITTED

This error will appear as: "Error number: 80004005 [DataDirect-Technologies][ODBC PROGRESS driver]Error in row" in the Extract Log file.