Allowed/Default action (Provision Access) not getting triggered for Analytic Report

[sukoor]

Hi Team,

We have created analytic control with Provision Access as action. We are triggering the analytic control from Job with execute default action checked but add access task is not getting triggered.

From Run history also,  we are not able to triggering the Add Access task.

Please find the Query below

Select 'XXXXXXXXXXXXXXXXX' as 'entvaluekey',a.accountkey as 'acctKey',a.name as 'accName',A.userKey as 'userKey','Provision Access' as 'Default_Action_For_Analytics' from account_entitlements1 ae join accounts a on a.accountkey=ae.accountkey join entitlement_values ev on ev.entitlement_valuekey=ae.entitlement_valuekey,(Select u.userkey,ae.accountkey ak,ae.entitlement_valuekey aek from users u join user_accounts ua on ua.userkey=u.userkey join accounts a on a.accountkey=ua.accountkey join account_entitlements1 ae on ae.accountkey=a.accountkey join entitlement_values ev on ev.entitlement_valuekey=ae.entitlement_valuekey and a.endpointkey=xxx and a.status in (1,'Active','Manually Provisioned') group by ae.accountkey having count(ae.accountkey)=1) A where ae.accountkey=A.ak and ae.entitlement_valuekey='xxxxx'

Please assist if i am missing something here.

Regards,

[rushikeshvartak]

Select 'XXXXXXXXXXXXXXXXX' as entvaluekey,a.accountkey as acctKey,a.name as accName,A.userKey as userKey from account_entitlements1 ae join accounts a on a.accountkey=ae.accountkey join entitlement_values ev on ev.entitlement_valuekey=ae.entitlement_valuekey,(Select u.userkey,ae.accountkey ak,ae.entitlement_valuekey aek from users u join user_accounts ua on ua.userkey=u.userkey join accounts a on a.accountkey=ua.accountkey join account_entitlements1 ae on ae.accountkey=a.accountkey join entitlement_values ev on ev.entitlement_valuekey=ae.entitlement_valuekey and a.endpointkey=xxx and a.status in (1,'Active','Manually Provisioned') group by ae.accountkey having count(ae.accountkey)=1) A where ae.accountkey=A.ak and ae.entitlement_valuekey='xxxxx'

[sukoor]

Changed the query as suggested, but still same issue.

No Add access task is created when the Action is manually changed to Provision Access

[rushikeshvartak]

Is it ES analytics ?

[sukoor]

Its not ES ,it is normal SQl query

[Manu269]

does the user has account?

[sukoor]

Yes user has an account ,  it is fetching user details in reports

[Manu269]

Anything you see in logs?

I just validated in 23.11 and it does create a task

[sukoor]

There is user data error, so it was not creating the task.

Now i have corrected it and it was working.

Thank you for support.

[rushikeshvartak]

Try with correct user.

if it worked you can close thread