Guest

Preview Tool

Cisco Bug: CSCvu60112 - Agent All Fields and Agent Sumary Report fail with Report Execution Failed for specific timeframe

Last Modified

Jul 21, 2020

Products (3)

  • Cisco Unified Contact Center Express
  • Cisco Unified Contact Center Express 12.5(1)
  • Cisco Unified IP Interactive Voice Response (IVR) 12.5(1)

Known Affected Releases

12.5(1)

Description (partial)

Symptom:
Agent All Fields and Agent Sumary Report fail with Report Execution Failed for specific timeframe
SQL Query Results in "Internal CLI Error: java.sql.SQLException: Value exceeds limit of SMALLINT precision"

We have 1 record with the below time frame:

select * from agentconnectiondetail where talktime> 32767;


sessionid 109000059293
sessionseqnum 0
nodeid 1
profileid 1
resourceid 2081
startdatetime 2020-06-08 16:29:50.581
enddatetime 2020-06-08 16:29:56.853
qindex 1
gmtoffset 0
ringtime 0
talktime 1591633794
holdtime 2
worktime 10
callwrapupdata
callresult 0
dialinglistid -1
rna f
contactid 121576999
loginsessionid 1591617388636_179
csqrecordid 86
consultsessionid

Conditions:
1) UCCX 12.5
2) if there is any call with total duration greater than 32767(SmallInt) seconds
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.