SAP Knowledge Base Article - Preview

2823194 - DB6: SQL0104N during data load from DSO into InfoCube

Symptom

The following error can be found in the dev trace:

ERROR in prepareStatement[/bas/753_REL/src/dbs/db6/dbdb6.c, 14906] CON = 0 CACHEID = 92 (BEGIN)
DbSlBegReadDB6( SQLExtendedPrepare ): [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token ""C_0", "C_1
", "C_2", "C_3", "C_4", "C_5"" was found following "INTEGER ) GROUP BY (". Expected tokens may include: "<values>". SQLSTATE=42601

The SQL statement in error are something like following:

SELECT .... FROM TABLE( SAPTOOLS.MEMORY_TABLE( CAST( ? AS BLOB( 2G )) ) CARDINALITY 1 )  ....

GROUP BY ( "C_0", "C_1",... ) ) AS "t_00" ....



Environment

 SAP on IBM Db2 for Linux, UNIX, and Windows

Product

SAP NetWeaver 7.5

Keywords

SQL0104N; SAPTOOLS.MEMORY_TABLE; GROUP BY; , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , Problem

About this page

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

Search for additional results

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