Minimize/Maximize
Idea Details
 Points:1
 Votes:1
 Rank:13
 Unique Views:10
 Total Views:41
 Comments:1
 Favorited:0
Linked Submissions:
This Idea is hidden. Change Visibility
Direct load materialization - Failed create subscription resume option
(D40174)
1
Points
Submitted:
1 month ago
Status: 
Submitted

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 Projections
Record Projection
Current Projection
Projection History
Recorded Outcomes
Record an Outcome