Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

UCCX Historical Report runtime error occurred while executing the query. Please check log for more details

Hi all

I have a problem with a Historical Report. When I run the report this give a message: "A runtime error occurred while executing the query. Please check log for more details"

 

- UCCX version 9.0.2.10000-71

- UCCX not have HA

More detail log:

 

7: 09-09-2017 12:18:55 %CHC-LOG_SUBFAC-3-UNK:TraceDBError #1:(ADO Error# -2147467259|Description EIX000: (-1265) Overflow occurred on a datetime or interval operation.|Source Ifxoledbc|SQLState |NativeError -1265)
8: 09-09-2017 12:18:55 %CHC-LOG_SUBFAC-3-UNK:Error de base de datos | Error de tiempo de ejecución al ejecutar la consulta. Vea el archivo de registro para obtener más detalles
9: 09-09-2017 12:18:57 %CHC-LOG_SUBFAC-3-UNK:Failed to run Interpreted SQL Command(call sp_call_csq_agent ('2017-09-09 12:00:00', '2017-09-09 13:00:00', 0, 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', -1, -1 ))
10: 09-09-2017 12:19:53 %CHC-LOG_SUBFAC-3-UNK:0 :Final Font Size=$rptFontSize
11: 09-09-2017 12:21:07 %CHC-LOG_SUBFAC-3-UNK:0 :Final Font Size=$rptFontSize
12: 09-09-2017 12:22:48 %CHC-LOG_SUBFAC-3-UNK:The following SQL Command failed due to ()SQL Command=[call sp_call_csq_agent ('2017-09-09 12:00:00', '2017-09-09 13:00:00', 0, 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', 'NULL', -1, -1 )]

 

TIA
Cristian 

1 REPLY
New Member

Re: UCCX Historical Report runtime error occurred while executing the query. Please check log for more details

Hi Cristian,

 

We faced the similar issue and installed a stored procedure COP file in the UCCX setup.

 

Please check the below Bug for more details.

 

CSCud75545

 

Regards,

Anto

192
Views
0
Helpful
1
Replies
CreatePlease to create content