Synapse Analytics: Trigger activation error. I can't activate any scheduled Trigger.

Danilo Tascone 21 Reputation points
2020-09-17T08:02:57.337+00:00

I'm working on Azure Synapse Analytics. It was working fine till yesterday when I decided to create a new Scheduled Trigger.
I can create a new trigger and associate it with an existing pipeline.
When I try to activate it by hitting the publish button, the trigger get's published but without being active. I also get a Trigger Activation Error with the following error message: 

    System.NullReferenceException : Object reference not set to an instance of an object. at Microsoft.Analytics.Common.PartnerApi.DataFactoryResourceProviderClientBase.CreateActionRequest(HttpMethod requestMethod, String subscriptionId, String resourceGroup, String workspaceName, Nullable`1 resourceType, String resourceName, String resourcePathPrefix, String action, IEnumerable`1 queryParameters, Tuple`2 requestBody) in S:\src\common\Microsoft.Analytics.Common\PartnerApi\DataFactoryResourceProviderClientBase.cs:line 118 


at Microsoft.Analytics.Common.PartnerApi.UserAuthBasedDataFactoryResourceProviderClient.<Microsoft-Analytics-Common-PartnerApi-IUserAuthBasedDataFactoryResourceProviderClient-StartTrigger>d__4.MoveNext() in S:\src\common\Microsoft.Analytics.Common\PartnerApi\UserAuthBasedDataFactoryResourceProviderClient.cs:line 127 --- End of stack trace from previous location where exception was thrown ---

 at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult() at Microsoft.Analytics.WorkspaceApiSvc.Controllers.TriggerManagementController.<>c__DisplayClass8_0.<<StartTrigger>b__0>d.MoveNext() in S:\src\services\workspace\Microsoft.Analytics.WorkspaceApiSvc\Controllers\TriggerManagementController.cs:line 144 --- End of stack trace from previous location where exception was thrown --- 

at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.Analytics.WorkspaceApiSvc.Controllers.WorkspaceApiBaseController.<>c__DisplayClass16_0.<<HttpWrapOperationAsync>b__0>d.MoveNext() in S:\src\services\workspace\Microsoft.Analytics.WorkspaceApiSvc\Controllers\WorkspaceApiBaseController.cs:line 81 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 

at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.Analytics.Common.Http.BaseController.<HttpWrapOperationAsync>d__9.MoveNext() in S:\src\common\Microsoft.Analytics.Common\Http\BaseController.cs:line 53

Of course the error stack trace doesn't help much. I don't understand where the System.NullReferenceException comes from.

I get this error with any new trigger and I've also verified that it happens regardless of which pipeline I associate the trigger.
The same feature seems to work fine on azure data factory.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,631 questions
0 comments
Accepted answer
  1. KranthiPakala-MSFT 46,437 Reputation points Microsoft Employee
    2020-09-17T23:24:43.253+00:00

    Hi @Danilo Tascone ,

    Welcome to Microsoft Q&A forum and sorry you are experiencing this.

    Could you please confirm if you are still experiencing the issue? I tried to reproduce the issue on my end, but was unsuccessful. I was able to create and publish a Scheduled trigger as well as associate it with a pipeline. And the trigger is working as per the configuration.

    25721-image.png

    25722-image.png

    Could you please try clearing your browser cache and retry again, also please validate the same in another browser too. If you still experience the issue consistently, please do email us at AzCommunity[at]microsoft[dot]com with below details for further investigation.

    • Email subject: <Attn - Kranthi : Synapse Analytics: Trigger activation error. I can't activate any scheduled Trigger>
    • Thread URL: <https://video2.skills-academy.com/answers/questions/98006/index.html>
    • Subscription ID:  <your subscription id>
    • Your Synapse workspace location?
    • Your Synapse workspace URL?

    Please let us know how it goes clearing your cache.
    Looking forward to your response.

    Thank you

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Danilo Tascone 21 Reputation points
    2020-09-18T09:05:05.457+00:00

    I'm not sure what happened. I reopened synapse today, I haven't touched it since my post here and now triggers are perfectly working. The error that was randomly appearing is no more present. By the way, thanks for your answer. I'll let you know if it happens again.