Azure Runbook fails on schedule but works fine for on demand refreh in Azure Portal

Question

Hello
One of my runbooks has been failing for scheduled refresh. When I do an on demand refresh, there is no error. On the recommendation of the Microsoft Support Technician, I had recently upgraded my SqlServer module for some other issue.

I fail to understand why I am able to refresh the model in SSMS and Azure Portal on demand but if fails on schedule refresh. This model is an older version of tabular model:1200

Invoke-ProcessASDatabase : Failed to save modifications to the server. Error returned: 'An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_DataSourceAccessError Received error payload from gateway service with ID 1879092: An exception encountered while accessing the target data source. An exception encountered while accessing the target data source Connection request timed out . Technical Details: RootActivityId: 208c3faf-d43b-4c32-b799-586559308bcf Date (UTC): 8/31/2020 11:01:51 AM An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_DataSourceAccessError Received error payload from gateway service with ID 1879092: An exception encountered while accessing the target data source. An exception encountered while accessing the target data source Connection request timed out . An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_DataSourceAccessError Received error payload from gateway service with ID 1879092: An exception encountered while accessing the target data source. An exception encountered while accessing the target data source Connection request timed out . An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_DataSourceAccessError Received error payload from gateway service with ID 1879092: An exception encountered while accessing the target data source. An exception encountered while accessing the target data source Connection request timed out . An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_CanceledError The operation failed due to an explicit cancellation. Exception: System.Threading.Tasks.TaskCanceledException: A task was canceled. at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.DataMovement.Pipeline.Dataflow.TDFHelpers.<>c__DisplayClass7_0`1.<<GetNextResponseAsync>b__0>d.M oveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.DataMovement.Pipeline.Dataflow.TDFHelpers.<>c__DisplayClass11_0.<<ExecuteBlockOperationAsync>b__ 0>d.MoveNext() A task was canceled. . An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_DataSourceAccessError Received error payload from gateway service with ID 1879092: An exception encountered while accessing the target data source. An exception encountered while accessing the target data source Connection request timed out . An error occurred during On-Premise Gateway related activity. Additional error details: DM_GWPipeline_Gateway_DataSourceAccessError Received error payload from gateway service with ID 1879092: An exception encountered while accessing the target data source. An exception encountered while accessing the target data source Connection request timed out . '. At line:37 char:11 + $result = Invoke-ProcessASDatabase -Server $ServerName -DatabaseName ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (Sub Prequal Search:String) [Invoke-ProcessASDatabase], OperationException + FullyQualifiedErrorId : Microsoft.AnalysisServices.PowerShell.Cmdlets.ProcessASDatabas

Answer 1

Hi

Just checking to see if you have got a chance to see my previous comment, if so could you please share the above requested details?

But from error message, it is clear that the gateway is failing to connect to the datasource.

"An exception encountered while accessing the target data source
Connection request timed out"

Perhaps the datasource is overloaded, or is throttled or the gateway is heavily loaded, something like that. This needs to be looked at from the gateway -> datasource.

Looking forward to your response.

Thank you