SAP Knowledge Base Article - Preview

3375546 - Error: "Dropping column is not supported on sql subscription" - SAP HANA Smart Data Integration

Symptom

  • Subscription failed with error "Dropping column is not supported on sql subscription"
  • Error in the Indexserver and dpserver trace
    1) Indexserver trace
    [146111]{-1}[-1/-1] 2023-09-05 10:18:35.748537 e DPApplier        dp_replicationSchemaChangeProcessor.cpp(01824) : Dropping column is not supported on sql subscription
    [146111]{-1}[-1/-1] 2023-09-05 10:18:35.748931 e DPApplier        dp_replicationManager.cpp(02081) : Applier failed in DP_Applier::processCDRTxn: exception  1: no.153102  (DPServer/Applier/dp_indexserver/dp_replicationSchemaChangeProcessor.cpp:1825) TID: 146111
    Applier failed in index server DP_ReplicationSchemaChangeProcessor::validate: Dropping column is not supported on sql subscription
    exception throw location:
    1: 0x00007f48843a24ce in DPApplier::DP_ReplicationSchemaChangeProcessor::validate(DPAdapterSDK::SchemaChange&)+0xa1a at dp_replicationSchemaChangeProcessor.cpp:1825 (libhdbrskernel.so)
    2) dpserver trace
    [39800]{-1}[-1/-1] 2023-09-05 10:18:36.003372 e DPApplier        ApplierCommon.cpp(00385) : ApplierCommon[48494858] got applier error: ApplierCommon::handleError(): errorNo=153102 errorMsg=exception 153102: Applier failed in index server DP_ReplicationSchemaChangeProcessor::validate: Dropping column is not supported on sql subscriptionisSubscription=true processingInBatchMode=true
    [39800]{-1}[34/-1] 2023-09-05 10:18:36.061404 i TraceContext     TraceContext.cpp(01269) : UserName=
    [39800]{-1}[34/-1] 2023-09-05 10:18:36.061371 e DPApplier        ApplierCommon.cpp(00566) : Applier[48494858]: Exception: exception 153102: Applier failed in index server DP_ReplicationSchemaChangeProcessor::validate: Dropping column is not supported on sql subscription


Read more...

Environment

SAP HANA Smart Data Integration

Product

SAP HANA smart data integration 2.0

Keywords

SDI, drop column, supported, Dropping column is not supported on sql subscription , 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.