and more in a single search tool across platforms. Read the announcement here. |
03/27/2024 11:11 AM
We are trying to execute this actionable analytic and receiving the error below when executing the analytics job. The accounts are identified in the analytic report but updateaccount tasks are not created. How can we resolve this issue?
SELECT a.accountID as 'DN', a.accountkey as 'acctKey', u.username, 'updateAccount' as 'Default_Action_For_Analytics' FROM users u left join user_accounts ua on u.userkey=ua.userkey left join accounts a on ua.accountkey=a.accountkey WHERE a.endpointkey=86 and a.accountID not like "OU=Users,OU=IdentityManagement,DC=TESTING,DC=net"
Results from Job History:
AnalyticESFIMStub Test Account Update | Success [ 218 violations saved ] |
Error:
Failure : Cannot invoke method split() on null object |
Solved! Go to Solution.
03/27/2024 11:55 AM
When you are getting error after taking action ?
03/27/2024 11:58 AM
If you mean after the analytic job has run yes. But the updateaccount task are not created
03/27/2024 12:01 PM - edited 03/27/2024 12:35 PM
Try query without single quote
SELECT a.accountid AS DN,
a.accountkey AS acctKey,
u.username,
'UpdateAccount' AS Default_Action_For_Analytics
FROM users u
LEFT JOIN user_accounts ua
ON u.userkey = ua.userkey
LEFT JOIN accounts a
ON ua.accountkey = a.accountkey
WHERE a.endpointkey = 86
AND a.accountid NOT LIKE
'OU=Users,OU=IdentityManagement,DC=TESTING,DC=net';
03/27/2024 11:58 AM
Can you try below query?
SELECT a.accountID as 'DN', a.accountkey as 'acctKey', u.username, 'updateAccount' as 'Default_Action_For_Analytics' FROM users u left join user_accounts ua on u.userkey=ua.userkey left join accounts a on ua.accountkey=a.accountkey WHERE a.endpointkey=86 and a.accountID not like "%Users,OU=IdentityManagement,DC=TESTING%"
03/27/2024 12:06 PM
Same error. The additional "%" didnt change anything.
03/27/2024 12:22 PM
Paste screenshot of your query and analytics config and also exact error.
03/27/2024 12:28 PM
03/27/2024 12:32 PM
In Allowed Action dropdown, select update account.
03/27/2024 12:33 PM - edited 03/27/2024 12:35 PM
03/27/2024 12:40 PM
Thanks!!