1427362 - Error: 'Exception: 'DBD, [NCR][ODBC Teradata Driver][Teradata RDBMS] Syntax error: expected something between the 'QUALIFY' keyword and the 'ORDER' keyword'

SAP Knowledge Base Article - Public

1427362 - Error: 'Exception: 'DBD, [NCR][ODBC Teradata Driver][Teradata RDBMS] Syntax error: expected something between the 'QUALIFY' keyword and the 'ORDER' keyword'

Symptom

  • Around 20 WebI reports are giving an error 'Exception: DBD, [NCR][ODBC Teradata Driver][Teradata RDBMS] Syntax error: expected something between the 'QUALIFY' keyword and the 'ORDER' keyword' while refreshing.
  • The Teradata database has been recently upgraded from Teradata 6 to Teradata 12.
  • Similar kind of reports are working in BOE XI 3.1 with Teradata 12 and Teradata ODBC 12 however not in BOE XIR2 SP2.

Environment

BusinessObjects Enterprise XI Release 2 SP2
Server OS: Linux
Database: TERADATA 12
Middleware: ODBC 12

Cause

Teradata V12 and Teradata ODBC 12 are not supported with BusinessObjects XI R2 SP2.

Resolution

Teradata V12 and Teradata ODBC 12 are supported from BusinessObjects XIR2 SP4 onwards and in BusinessObjects XI 3.1

Keywords

Unable to refresh, error while refreh, Teradata error. , KBA , BI-RA-WBI , Web Intelligence , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008