Error “Failed with unknown error while parsing query”
This error occurs when running a data extract using a Principalm 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.