1749940 - Error: You receive "A term expected, beginning with one of the following: identifier, constant, aggregate .." in Data Services

Symptom

Data Services job that uses an ODBC as source fails as follows:

SQL submitted to ODBC data source <Sym_Cache> resulted in error <[Cache ODBC][State : 37000][Native Code 12] [D:\SAP\Data Services\bin\al_engine.exe] [SQLCODE: <-12>:<A term expected, beginning with one of the following: identifier, constant, aggregate, $$, :, (, +, -,%ALPHAUP, %EXACT, %MVR, %SQLSTRING, %SQLUPPER, %STRING, or %UPPER>]

Environment

Data Services 12.2

Product

SAP Data Integrator XI R2

Keywords

BODI, BODS, DSXI, DI, DS, Cache Database , KBA , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.