SAP Knowledge Base Article - Preview

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

Symptom

Having a real-time repliation task with behaviour "initial+realtime+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 SUB_VT_TEST_ZWFBWT_XRSA: 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 , 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.