Actionable Analytic Error: Failure : Cannot invoke method split() on null object

[ram81]

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

[rushikeshvartak]

When you are getting error after taking action ?

[ram81]

If you mean after the analytic job has run yes. But the updateaccount task are not created

[rushikeshvartak]

• Please share logs in file and
• provide screenshot of analytics config
• take action manually and check if error exists

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'; 

[dgandhi]

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%"

[ram81]

Same error. The additional "%" didnt change anything. 

[dgandhi]

Paste screenshot of your query and analytics config and also exact error.

[dgandhi]

In Allowed Action dropdown, select update account.

https://docs.saviyntcloud.com/bundle/EIC-Admin-v24x/page/Content/Chapter17-EIC-Analytics/Managing-An...

[rushikeshvartak · Accepted solution]

• Allowed Action is not selected in report
• Also Action name in query 'UpdateAccount' not updateAccount

[ram81]

Thanks!!