Enable Account via analytics

[Sekhar]

Hi,

Iam trying to enable the account via analytics, when start date & current date have 1 day difference.

Query:

select u.username,a.accountkey acctKey,'enableAccount' as Default_Action_For_Analytics FROM USERS U, USER_ACCOUNTS UA, ACCOUNTS A, ENDPOINTS E WHERE U.USERKEY = UA.USERKEY AND UA.ACCOUNTKEY = A. ACCOUNTKEY AND A.ENDPOINTKEY = E.ENDPOINTKEY and e.ENDPOINTKEY=21 and a.status NOT IN (1,'active', 'manually suspended', 'suspended from import service')and date(u.startdate)=date(curdate())+1

 I created Job as well, analytics is not running even if job was success.

Pending task is not triggering if i run the analytics manually.

Could you please help me in this issue.

Thanks,

Sekhar

[Saathvik · Accepted solution]

@Sekhar : Can you remove Analytics Application and then run the job to see if that works?

[Sekhar]

Hi @Saathvik 

Enable task was triggering now, after removed the analytics application in the job.

Thanks,

Sekhar.

[rushikeshvartak]

• Select Base count =1 
• Try running report manually 
• Does query works from Data analyzer ?