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