question

ChaviGupta-5309 avatar image
1 Vote"
ChaviGupta-5309 asked MattProtopapas-1511 commented

Synapse Analytics Event Trigger Activation Error

Storage event trigger activation fails with following error:
Forbidden. Role based access check failed for resource <storage-account>

Please help.

azure-synapse-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KranthiPakala-MSFT avatar image
0 Votes"
KranthiPakala-MSFT answered KranthiPakala-MSFT commented

Hi @ChaviGupta-5309,

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

After verifying with internal team, it is confirmed that this is a known issue with event based triggers in Synapse workspace. The product team is aware of this issue and working on fixing it. Unfortunately I don't have an ETA at the moment but will keep this thread updated once I receive further information from internal sources.

One possible workaround/alternate until the issue is fixed is to use a schedule trigger.

Hope the above info helps. Please do let us know if you have further query.

Thank you for your patience.



Thank you
Please do consider to click on "Accept Answer" and "Upvote" on the post that helps you, as it can be beneficial to other community members.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ChaviGupta-5309,

Following up to see if the above information was helpful. If you have any further query, please let us know.

Thank you

0 Votes 0 ·
ChaviGupta-5309 avatar image
0 Votes"
ChaviGupta-5309 answered KranthiPakala-MSFT commented

Since I needed event based triggers I moved my pipeline to data factory instead. It is working fine there.

· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ChaviGupta-5309,

Just heard back from internal team about the mitigation/workaround for this issue. Following is temporary mitigation until a permanent fix is applied, please follow below steps to activate event trigger in Synapse workspace.

  1. Append the feature flag(given below) to the Synapse Studio URL. This will enable the blocked feature.

     &feature.openSubscribeAndProgressAPIs=true
    
  2. Refresh the page

  3. Disable the trigger and publish the change.

  4. Enable the trigger and publish the change.


Please let us know how it goes.

Thank you

0 Votes 0 ·

Still doesn't work. Getting the error below.

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

0 Votes 0 ·

Hi
I am having the same issue so I added the &feature.openSubscribeAndProgressAPIs=true but I still get the same error when publishing:

Failed to subscribe to storage events for event trigger:...
Trigger activation failed for ....

Both have the same details: Forbidden. Role based access check failed for resource /subscriptions/e.../resourceGroups/.../providers/Microsoft.Storage/storageAccounts/...

Data Factory is working fine but I have everything in Synapse. Any other suggestions please?

0 Votes 0 ·

Hi @LiseParker-5809, anonymous user,

Sorry for your experience with this issue. I tried this again and noticed an issue and reached out to Product team. I have received a confirmation that there was another issue identified related to event triggers in Synapse. Because of which we are seeing this error message. Product team is actively working on fixing this. At the moment I do not have an ETA but will keep this thread posted as soon as I have the next update.

Until the fix is applied, it is recommended to use schedule trigger or ADF (GA'd product) based on the requirement.

Also please note that Azure Synapse workspace is still in Public preview, and Synapse product team is acknowledging these feedbacks and actively prioritizing them accordingly to provide the best experience.

We appreciate your patience and sincere apologies for the inconvenience caused because of this issue.

0 Votes 0 ·
FMSFT-4369 avatar image
1 Vote"
FMSFT-4369 answered MattProtopapas-1511 commented

61641-image.png



image.png (18.0 KiB)
· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This is the right answer. Thanks.

1 Vote 1 ·

did it work for anyone?

0 Votes 0 ·

Took me several hours, but I somehow got it to work, hehe.

0 Votes 0 ·

yes, the Data Factory resource provided was not registered in my subscription, although I had a Synapse workspace. After registering it, the error stopped appearing when publishing the (activated) trigger.

0 Votes 0 ·

This response successfully created the event subscription, and the subscription is correctly identifying the storage events. However, the associated event-based trigger in Synapse is still not firing.

0 Votes 0 ·