Real Time Replication

408 Views

Hi,

I want to replicate data residing in my SQL Database to HANA.

For this I created a hdb replication task in Web IDE and added the table I wanted to replicate.

I am able to replicate by checking the option of initial load only.

I assume that if I uncheck this initial load only option, real time replication will be achieved. i.e, Any new entries in the table residing in SQL DB will be automatically reflected in copied table in HANA DB.

Please correct me if I am wrong.

When I try to execute the replication task after unchecking this initial load only option, an error is being thorwn

(dberror) 256 - sql processing error: "TRAINING"."R_Export_SCM::RealTReplicationChk.START_REPLICATION": line 4 col 0 (at pos 248): [256] (range 3) sql processing error exception: sql processing error: QUEUE: R_Export_SCM::RealTReplicationChk.SUB_VT_"dbo"."Employee": Failed to add subscription for remote subscription R_Export_SCM::RealTReplicationChk.SUB_VT_"dbo"."Employee".Error: exception 151050: CDC add subscription failed: Cannot call addSubscription method because the adapter is in FIRST_ADD_SUBSCRIPTION_FAILED state.

: line 1 col 1 (at pos 0)

Please help me in this.

Thanks in advance