Issue in running the Report

[saimeghana]

Hi Team,

We found an issue in Analytics, when we are trying to run the reports in DRY Run we can see "records found" if we try to run the Reports in RUN Now "No record found" 

Attaching the screen shot for reference.

DRY Run:

Run Now:

Thanks,

Saimeghana

[rushikeshvartak]

Please share query or recreate report it will work

[saimeghana]

Hi,

Please find the attached query.

SELECT USERNAME as 'Saviynt Username', case when customproperty3 ='89' then 'AITS' when customproperty3='65' then 'AMS' end AS 'BU in Saviynt',FIRSTNAME,LASTNAME,EMPLOYEETYPE,CASE WHEN STATUSKEY=1 then 'Active' else 'Inactive' end as 'Saviynt Identity Status',STARTDATE as 'Contract Start Date',ENDDATE as 'Contract End Date',CUSTOMPROPERTY4 AS 'MANAGER EMPLOYEE ID' FROM USERS WHERE (DATEDIFF(CURDATE(), DATE(CREATEDATE)) < 30 AND DATEDIFF(CURDATE(), DATE(CREATEDATE)) > 0 OR CURDATE()=DATE(CREATEDATE) OR CREATEDATE IS NULL) AND STATUSKEY=1 AND customproperty3 in ('65','89') AND (CUSTOMPROPERTY6 IS NULL AND CUSTOMPROPERTY36 IS NULL)

Thanks,

Saimeghana

[rushikeshvartak]

Query is correct. Try recreating report

[saimeghana]

Hi,

Okay, but not only one reports most of the reports are behaving same before these reports are running correctly.

Thanks,

saimeghana

[rushikeshvartak]

Can you share logs while running report

[saimeghana]

Hi,

Attaching the logs for reference.

Thanks,

Saimeghana

[rushikeshvartak]

Does Elastic Server is running ?

Also please point to log time from above file.