Actionable analytics to disable account shows one record during dry run but shows 0 records wen exec

[Brijit_mary]

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?

[rushikeshvartak]

• Keep base count as 1 in analytics configuration
• 

[Raghu]

@Brijit_mary,

1.Base Count value put as blank

2. still issue delete once a report, create once again ,put base count zero check again.

[Brijit_mary]

@Raghu  - Thanks for the response.. Added base count as 1 and executed again still no luck.

[Raghu]

@Brijit_mary  can you share entrire report screenshot please

[dgandhi]

Have seen this kind of behavior in past. Delete the analytics and create a new one with some different name.

[Brijit_mary]

@dgandhi  - Created a copy and tried still shows same result (one record during dry run but 0 wen executed).

[naveenss]

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. 

[rushikeshvartak]

• Please share screenshot of report
• also create report with different name.

[Brijit_mary]

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

[naveenss]

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. 

[rushikeshvartak]

Data needs to be stored in elastic search - tick on save data.

[Brijit_mary]

@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. 

[naveenss]

Add the below in your query SELECT. I believe there is a typo in the existing query.

'Disable Account' as Default_Action_For_Analytics

[rushikeshvartak]

Its for v1 @naveenss 

• Schedule from Run All V2 Analytics Job

SQL

select a.name,a.accountkey as acctKey, endpointkey, 'disableAccount' as Default_Action_For_Analytics from accounts a;

• Schedule from Run All V1 Analytics Job

SQL

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