3633416 - Error "CDC begin marker failed" during real-time replication of Datasphere Remote Table

Real-time replication of Datasphere Remote Table failed with error:

Error: {"timestamp":"<timestamp>", "origin":"prepare", "code":256, "message":"sql processing error: "<space>$TEC"."$$PREPARE_REMOTE_TABLE_REPLICATION$$": line 136 col 9 (at pos 4608): QUEUE: <table>$RS: Failed to send Begin Marker for remote subscription <table>$RS[id = XXXX] in remote source <space>.<connection>[id = XXXX] and triggerID XXXX. Error: exception 151054: CDC begin marker failed: RS[<space>.<connection>]: ""ABAP_CDS"".""<ODP>"":DWCD2PJU9.<space>.<table>: Failed to initialize delta process in ODP Remote source = XXXXX : line 1 col 1 (at pos 0)"}

Error also happens if you run RODPS_REPL_TEST program in source system for the corresponding ODP:

Error while accessing
Subscription interface error
Creating trigger of type UPD2 for table <table> failed
A database error occured. The error message in the database was: "SQL command is the empty string".

And error message can be found in Transaction DHCDCMON -> Application log by searching with "Object = DHCDC":

Subscription interface error
Creating trigger of type UPD2 for table <table> failed
A database error occured. The error message in the database was: "SQL command is the empty string".

• SAP Datasphere

KBA , DS-DI-RT , Remote Tables , BC-DB-CDC , ABAP CDC Engine (Change Data Capture) , Problem