SAP Knowledge Base Article - Preview

3373665 - Failed to create a real time replication task due to "Failed to add the first subscription".

Symptom

Trying to create a Real Time Replication Task using WebIDE, and getting following error.

1. Error

[10:25:33] Package /XXX_RT_TEST2 created successfully.
[10:26:08] File /XXX_RT_TEST2/RT_TEST2.hdbreptask created successfully.
[10:29:19] File /XXX_RT_TEST2/RT_TEST2.hdbreptask saved & activated successfully.
[10:29:37] Start executing RT_TEST2....
[10:30:08] Executing task plan failed:Error executing SQL command in task.;Error executing ALTER_REMOTE_SUBSCRIPTION_QUEUE with command: 'ALTER REMOTE SUBSCRIPTION "SYSTEM"."XXX_RT_TEST2::RT_TEST2.SUB_VT_dbo_SALES" QUEUE'. ,exception 71000129: SQLExceptionexception 71000256: QUEUE: XXX_RT_TEST2::RT_TEST2.SUB_VT_dbo_SALES: Failed to add subscription for remote subscription XXX_RT_TEST2::RT_TEST2.SUB_VT_dbo_SALES[id = 19668983] in remote source RS_LOGREADER_TEST1[id = 19668904]. Error: exception 151050: CDC add subscription failed: RS[RS_LOGREADER_TEST1]: Failed to add the first subscription. Error: SQL Server is not initialized. Please run server initialization script first.


Read more...

Environment

  • SAP HANA Smart Data Integration
  • MSSQL

 

Product

SAP HANA smart data integration all versions

Keywords

SDI, replication, subscription, Failed to add the first subscription, SQL Server is not initialized. Please run server initialization script first , 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.