SAP Knowledge Base Article - Preview

2601559 - SDI Exception : DP_ReplicationSchemaChangeProcessor::applySchemaChangeToTargetTable: feature not supported: table must be empty to add NOT NULL column

Symptom

  • Real-time replication task with behaviour "initial+realtime with structure" and adding NOT NULL column with default value to the source table will run into below exception.
  • Alert Name : Remote Subscription exception
    Rating     : Error
    Details    : Exception number 153102 in REMOTE SUBSCRIPTION <SUBSCRIPTION NAME>: exception 153102: Applier failed in index server
    DP_ReplicationSchemaChangeProcessor::processSchemaChange: exception 153102: Applier failed in index server
    DP_ReplicationSchemaChangeProcessor::applySchemaChangeToTargetTable: feature not supported: table must be empty to add NOT NULL column


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration all versions

Keywords

Applier failed in index server, initial+realtime+structure,adding NOT NULL column with default value, Replication, SDI, Structure Change , KBA , sdi_improve , 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.