3344903 - Error 'Remote source has existing exceptions' while enabling Real-Time Access for CDC enabled CDS views - Datasphere

In Datasphere, while enabling Real-Time Access for CDC enabled CDS views, the following error is reported:

Operation failed:  Remote source 'XXXX' has existing exceptions.

No logging table entries in DHCDCMON.

In the SLT system you see these errors in the Application Log:

• Triggers for table XXXX do not exist
• Logging table for table XXXX does not exist
• Subscriber logging table for table XXXX does not exist

• SAP Datasphere
• SAP Data Intelligence (DI)

sql processing error PREPARE_REMOTE_TABLE_REPLICATION QUEUE Operation failed Remote source has existing exceptions "subscription interface error" Error while creating logging table Could not create table Triggers for table do not exist Logging table for table does not exist Subscriber logging table for table does not exist , KBA , CA-DI-IS-ABA-CDC , ABAP Integration - Change Data Capture , DS-DI-RT , Remote Tables , CA-DI , Data Intelligence , How To