Product:
StreamSets Control Hub
Issue:
Subscriptions are not getting triggered due to below error
2020-08-31 09:08:43,714 [requestId:] [app:notification] [componentId:notification001] [user:notification001] [thread:scheduler-executor-2] ERROR EventUtil - Cann
ot process event: '06cab6e6-f5ac-4b91-87a5-ffff8e7128e8'::'10700'::'{"orgId":"humad","pipelineId":"100fc012-3901-456a-a884-56592794bd2f:humad","pipelineName":"Te
sting sub","pipelineCommitId":"7331d71d-dbc1-4635-9a79-9de25802d8e7:humad","pipelineCommitVersion":"v2","jobId":"fb1f2a3c-dec4-4629-9ed8-de9ec1b6aefe:humad","job
Name":"Job for Testing sub","sdcId":"7bf91659-831e-11e9-8521-f1166f6f1bab","fromStatus":"STOPPED","toStatus":"DELETED"}' due to 'java.lang.RuntimeException: Erro
r while filtering acls for event subs: [77784ab4-b5a9-46e3-b83b-95539f415cef:humad, 2776edce-1ad5-4b74-9a79-18ae559fe715:humad, 2f13358e-0f7f-417c-84d2-db2ba96d2
Solution:
The above error comes when the subscription is present but the owner is not the part of the organization or doesn't have appropriate permissions.
In the above logs we can see event subscriptions with ids 77784ab4-b5a9-46e3-b83b-95539f415cef:humad, 2776edce-1ad5-4b74-9a79-18ae559fe715:humad, 2f13358e-0f7f-417c-84d2-db2ba96d2 070:humad has ACL issue, So to resolve the issue we need to follow below steps
1. First, we need to get the name of the subscription from the Database using ID's
$ use notification;
$ select * from EVENT_SUBSCRIPTION where ID='<>';
- Then we need to go to the subscription tab in the control hub UI and simply we need to select problematic Subscriptions with the checkbox on the left-hand side then click the 'Share' button at that top of the list. Inside this popup, you can add a user, then click the Set As Owner button on the right-hand side. It is recommended that an Org Admin user is assigned as the owner of these subscriptions, in order to ensure that the events trigger the subscriptions. If the subscription is assigned a lesser privileged user the subscription may not trigger.
- The other solution is we can add the subscription owner user back to the organization
- We can get more information from the below doc link
