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
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.