cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1841
Views
0
Helpful
3
Replies

CUIC Reports datas in blank

Cisco UCCX stayed for a period of 5 days with the database service out, we fixed this problem but the reports are blank in this period.
When we use the run command uccx sql db_cra {call sp_call_csq_agent ('2017-12-27 03:00:00', '2018-01-06 02:59:59', '0', null, null, null, null, null, null, null, null, null, null)} We received data from other days less the data for the period that the database was service out. This is normal?
3 Replies 3

Jonathan Schulenberg
Hall of Fame
Hall of Fame
How would you expect the database to have data from a time period that it was offline?

Jonathan, I figured this data was not written because the database was offline. But I expect a response from Cisco to the subject.

ricarlovesit
Cisco Employee
Cisco Employee

When the engine is unable to write into the database for some reason, the system writes the data into temp file. You may open a tac case to see if you have flat files. If you try to restore them and it fails for some reason the files will be deleted so they have to backup the files before restoring

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: