UCCX 8.5 Historical Report Data Missing

[Helmi Muzammil]

Hi All,

We Have UCCX 8.5 HA. I have a problem when generate any agent report Oct 28-31 ( Agent Summary, Agent Detail, Login Logout ) from Historical Report.

Error : There were no report data view in the date range selected. Please select a different date range by changing the start date/time or the end date/time and try again.

I also try to direct query from CLI by using this command :

run uccx sql db_cra call sp_agent_log_activity('2017-10-29 07:00:00','2017-10-29 21:00:00','0','NULL',null,null,null)

and reply with : No records found

What should i check?

Appreciate for your help.

[Vinod Patil]

Hi Helmi Muzammil,

I only suggest to narrow down the filter like Run for only one hour and check.

Never worked on 8.5 UCCX reporting tool but I know in new version from UCCX 10.5 Cisco has introduced new reporting tool called CUIC and it has limitations like we can have only 8000 rows for each run of historical report, if it exceeds the limitation we get the same error. so you narrow down the filter like run between 30/10/2017 07:00:00 to 30/10/2017 08:00:00, if it has option to filter the agents then select fewer agents, I am sure you will get some data.

I hope this was helpful

Best regards,

Vinod