Reprocess SSAS tabular cube after failure

0
votes

So we process the SSAS tabular cubes every night and the other night the processing of the cube failed. Now what I want to do is implement a system that would trigger an automatic reprocess after failure.

Is there a way to do that in SSAS Tabular?

2
sqlssasssas-tabular
Nothing built into SSAS will do this. Where do you schedule or automate the processing? Detect an error there and retry on error. - GregGalloway
Right now we have an SSIS package that does that through sql server job agent. - Dennyc

2 Answers

0
votes

Nothing built into SSAS will automatically restart processing on error.

In SQL Agent, the Job Step Properties dialog has an Advanced tab with a Retry Attempts property. If you change that to 1, then it will automatically retry the step (the SSIS package) if it fails.

0
votes

If you are doing it in ssis then have a failure constraint looping back to the processing task?

The problem would be if you Have a data error that needs to be fixed.