Idea Details
 Points:1
 Votes:1
 Rank:12
 Unique Views:14
 Total Views:157
 Comments:3
 Favorited:0
Linked Submissions:
This Idea is hidden. Change Visibility
Direct load materialization - Failed create subscription resume option
(D40174)
1
Points
Submitted:
Jan 24 2017
Status: 
Acknowledged

We need a feature in SRS to resume a failed/interrupted create subscription...direct load.

 

Currently if a table is real big (e.g., takes around 40 hours to materialize) and for some reason if DSI thread goes down while direct_load materialization is going on; catch up queue also go away and we need to re-start direct load subscription all over again by truncating data in target table.

 

It consumes huge amount of DBA time and again there is possibility of next interruption.

 

So need a way to resume subscription from where it failed/interrupted.

 

Promotes

Demotes

No evaluations ready
Recorded Outcomes
Record an Outcome