Cuic reporting issue.

[Sonam]

Dear All,

I have uccx and cuic 11.5 . I could not generate cuic report for previous one month. then i restarted uccx servers and it is working now.  what could cause this? Is there a way to generate report for that month.? I still cannot generate report for that month. Is it because no report in db? or Is there a way out? Please comment!!

[Aseem Anand]

Hi.

if its an HA setup, can you check the dbreplication on the CCX by running:

utils dbreplication runtimestate

utils uccx dbreplication

Run the below command on both the nodes and check if the count is same or not:

run uccx sql db_cra select max(sessionid) from contactcalldetail

Also, share the screenshot of:

UCCX admin >>>> Tools >>> Historical reporting >>>> Purge Now

we can also check if the data still exists in the UCCX or not by doing the following:

a. Browse to the CUIC and run the stock report for which you are unable to find the data using the custom interval.

b. After you get the output or if you get a blank screen, get the SQL query for the stored procedure by clicking on the SQL and make a note of it in the notepad.

c. Once you have got the SQL query, run the query by appending "run uccx sql db_cra" ahead of the SQL output you got in step 2.

Example:

run uccx sql db_cra call sp_call_csq_agent('2018-07-14 18:30:00','2018-07-19 18:29:59','0',null,null,null,null,null,null,'Aseem Anand,Gayatri Kumari',null,null,null)

Note: Remove the bracket from the SQL query before running on the putty.

Thanks,

Aseem Anand

(Please rate if usefyul)