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 deeh11edw201a
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 , 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.