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

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 for Me (Login required).

Search for additional results

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