SAP Knowledge Base Article - Preview

2620980 - Error: SQLCODE=-204, SQLSTATE=42704, Failed to execute query, while doing data preview on transparent tables, SDI 2.x

Symptom

Error: Failed to execute query [SELECT "VT_...  com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=sapdae.T024E, DRIVER=4.14.146, while reading source data via an ECCadapter, while doing data preview.


Read more...

Environment

===SAP HANA===
Version/Revision: 1.00.122.12.1502962396 (fa/hana1sp12)
Platform (Linux/Windows): Linux (SLES 12, SP1)

On premis
Multi-tenant DB
SAP_BASIS 7.50 SP 8

===Data Provisioning Agent===
Version number: 2.2.2.0.0
Platform/OS (Linux or Windows): Linux (RHEL 7.2)

On premise or cloud: op premise
Db2 Client: DB2 v9.7.0.10

===Remote DB===
DB and client version : Db2 v9.7.0.11
Platform/OS: AIX 7.1

 

Product

SAP NetWeaver 7.3

Keywords

KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , 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.