Common Report Execution Errors

previous page next page

Home > Report Manager > Troubleshooting the Report Manager > Common Report Execution Errors

Common Report Execution Errors

Sage Accpac Intelligence uses ODBC and OLEDB technologies for accessing data. Each ODBC driver or OLEDB provider has slight differences and limitations. This means that certain Sage Accpac Intelligence features may have problems or not work for certain Database Systems.

If you are receiving errors when running a report use this reference to try and identify if the problem is due to one of these limitations.

[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]The position you specified in the ORDER BY clause is invalid.

[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine] You cannot use the AVG or SUM functions on STRING, DATE, TIME, or TIMESTAMP data types.

[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]The data type is invalid for the expression.

[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]The column does not exist in the dictionary.

[Pervasive Software][ODBC Interface][Pervasive Software SQL Engine]A character in the numeric data is invalid.

[Microsoft][ODBC dBase Driver]ORDER BY clause ([TABLE].FIELD) conflicts with distinct.

[Microsoft][ODBC dBase Driver]You tried to execute a query that does not include the specified expression '[TABLENAME].[FIELDNAME]' as part of an aggregate function.

[Microsoft][ODBC dBase Driver] Data type mismatch in criteria expression.

[Microsoft][ODBC dBase Driver] Syntax error in query expression '([TABLENAME].[FIELDNAME] Like %<VALUE>)'.

[Microsoft][ODBC dBase Driver] Syntax error in date in query expression '([TABLENAME].[FIELDNAME] Like #<VALUE>%#)'.

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.