Hi,
After searching for the error logs cam across a TAC case reference:617010385
Which is pointing to below 2 defects which have a fix for this issue.
---------------------------------------------------------
CSCtj88620: run time error while generating agent related historical reports
Description: HRC throws run time error while generating some agent related reports. HRC log shows the error "A subquery has returned not exactly one row".
Following is seen in the RTMT for the same time frame.
Module Name : HISTORICAL_REPORTING_MANAGER
Module Failure Name : HISTORICAL_DATABASE
UNKNOWN_PARAMTYPE:Module Run-time Failure Cause : 3
Module Failure Message : Historical database queue is full. Historical data saved in files. Queue size= 0 Total number of lost records= 300 Please check d AppID : Cisco Unified CCX Engine
ClusterID : NodeID : uccx1a
TimeStamp : Wed Nov 03 08:02:16 EDT 2010.
The alarm is generated on Wed Nov 03 08:02:16 EDT 2010.
To Be fixed: 8.0(2)SU2 8.5(1)SU3
-------------------------------------------------------------
CSCtl93897: UCCX Engine tries to update missing table, which causes RTMT alerts
Description:
When running a historical report, the customer's system generates RTMT alerts such as:
Subject: [RTMT-ALERT-StandAloneCluster] HistoricalDataWrittenToFiles
Module Name : HISTORICAL_REPORTING_MANAGER Module Failure Name : HISTORICAL_DATABASE UNKNOWN_PARAMTYPE:Module Run-time Failure Cause : 3
Module Failure Message : Historical database queue is full. Historical data saved in files. Queue size= 0 Total number of lost records= 1 Please check dat AppID : Cisco Unified CCX Engine ClusterID :
After further investigations, the cause of this issue was found to be the UCCX engine, which tries to write data to a table from a previous version, called the WorkflowTask table. Given that there is no longer a table within the database by this name, this causes the system to generate RTMT alerts.
While there is no direct impact on the system in a critical way, such as core functionality or critical data loss, this still needs to be addressed, as it causes concerns for the customer who may see these errors.
To Be fixed: 8.5(1)SU3 8.0(2)SU4
--------------------------------------------------------------
As I see you are currently running on UCCX 8.5(1)SU2 with COP file on HA, need to come to 8.5(1)SU3.
As of now I can only see 8.5 SU2 posted in CCO.
http://www.cisco.com/cisco/software/release.html?mdfid=270569179&flowid=5217&softwareid=280840578&release=8.0%282%29_SU4&relind=AVAILABLE&rellifecycle=&reltype=latest
Please contact Cisco TAC for the ES or any other available COP file for this issue.
Hope it helps.
Anand
Please rate helpful posts by clicking on the stars below the right answers !!
