Click HERE to see how Saviynt Intelligence is transforming the industry. |
07/05/2024 11:44 AM
I created a actionable analytics that will pic users with certain condition and has 'disableAccount' as Default_Action_For_Analytics. Query shows one record (expected result) during dry run but shows 0 records wen exececuted or triggerred from job.
Checked logs and it doesnt have any errors. Could someone please help?
07/05/2024 12:09 PM - edited 07/05/2024 01:23 PM
07/05/2024 12:52 PM
1.Base Count value put as blank
2. still issue delete once a report, create once again ,put base count zero check again.
07/08/2024 02:46 AM
@Raghu - Thanks for the response.. Added base count as 1 and executed again still no luck.
07/08/2024 04:04 AM
@Brijit_mary can you share entrire report screenshot please
07/05/2024 01:08 PM
Have seen this kind of behavior in past. Delete the analytics and create a new one with some different name.
Thanks,
Devang Gandhi
If this reply answered your question, please Accept As Solution and give Kudos to help others who may have a similar problem.
07/08/2024 02:47 AM
@dgandhi - Created a copy and tried still shows same result (one record during dry run but 0 wen executed).
07/08/2024 03:21 AM - edited 07/08/2024 03:22 AM
Hi @Brijit_mary when you execute the report, do you see any error in the logs? Also, please share the analytics configurations along with the query.
07/08/2024 07:57 PM
07/09/2024 02:42 AM
@rushikeshvartak - Tried but still issue persists.
@naveenss - Here is the query and config screenshot
select a.name, a.accountkey as acctKey, a.endpointkey, 'disableAccount' as Default_Action_For_Analytics from accounts a, user_accounts ua, users u WHERE ( a.accountkey = ua.accountkey AND ua.userkey=u.userkey) AND a.status ='1' AND a.endpointkey = 4 AND a.customproperty19='LOA' AND a.customproperty39='8388608';
07/09/2024 04:27 AM
Hi @Brijit_mary is there any reason you're using "Save to File" option?
Please also select "Save Data" option and re-run the report.
07/09/2024 10:55 PM
Data needs to be stored in elastic search - tick on save data.
07/11/2024 03:51 AM
@rushikeshvartak @naveenss - Thanks, that helped. Am able to run the analytics successfully and trigger default action manually from run history. However, the default action is not getting triggered from Job even though trigger default action for analytics option is checked.
07/11/2024 03:54 AM
Add the below in your query SELECT. I believe there is a typo in the existing query.
'Disable Account' as Default_Action_For_Analytics
07/11/2024 07:02 AM
Its for v1 @naveenss
Schedule from Run All V2 Analytics Job
select a.name,a.accountkey as acctKey, endpointkey, 'disableAccount' as Default_Action_For_Analytics from accounts a;
Schedule from Run All V1 Analytics Job
select a.name,a.accountkey as acctKey, endpointkey, 'Disable Account' as Default_Action_For_Analytics from accounts a;
@Brijit_mary share job configuration screenshot may be you have missed checkbox to take default action in job