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.