SAP Knowledge Base Article - Preview

2414796 - Error: column not allowed: "<column_name>" in select clause​ - SAP HANA Smart Data Integration

Symptom

When you run a replication task based on the ABAPAdapter remote source with real-time mode, the task fails with some of the errors below:

  • Error: (dberror) 256 - sql processing error...Failed to optimize the subscription query string for remote subscription ..Error: column not allowed: "<column_name>" in select clause​
  • InternalError: dberror($.hdb.Connection.executeProcedure): 256 - SQL error, server error code: 256. sql processing error:  ...START_REPLICATION":  sql processing error exception: sql processing error: Failed to optimize the subscription query string for remote subscription  ...column not allowed: "<column_name>" in select clause at...


" in select clause​ - SAP HANA Smart Data Integration"> Read more...

Environment

  • SAP HANA Smart Data Integration
  • ABAPAdapter remote source

Product

SAP HANA smart data integration all versions

Keywords

ECC, ERP, S/4 Hana, initial load, realtime, real-time, change data capture data, CDC, delta, provisioning, dpagent, ABAPTABLES , 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.