THIS FIELD NOTICE IS PROVIDED ON AN "AS IS" BASIS AND DOES NOT IMPLY ANY KIND OF GUARANTEE OR WARRANTY, INCLUDING THE WARRANTY OF MERCHANTABILITY. YOUR USE OF THE INFORMATION ON THE FIELD NOTICE OR MATERIALS LINKED FROM THE FIELD NOTICE IS AT YOUR OWN RISK. CISCO RESERVES THE RIGHT TO CHANGE OR UPDATE THIS FIELD NOTICE AT ANY TIME.
Revision | Publish Date | Comments |
---|---|---|
1.0
|
20-Sep-16
|
Initial Release
|
10.0
|
13-Oct-17
|
Migration to new field notice system
|
Affected OS Type | Affected Release | Affected Release Number | Comments |
---|---|---|---|
NON-IOS
|
10
|
10.6(1),10.5(1),10.0(1)
|
|
NON-IOS
|
9
|
9.0(2),9.0(1)
|
|
NON-IOS
|
11
|
11.5(1),11.0(1)
|
|
NON-IOS
|
8
|
8.5(1)
|
Defect ID | Headline |
---|---|
CSCvb27878 | UCCX/CUIC: Overflow occurred on a datetime or interval operation |
For Unified Contact Center Express (UCCX) only, when the Agent related reports summary is run for dates later than 8 September, 2016 the report fails with this error:
1265: Overflow occurred on a datetime or interval operation.
An error can also appear in the Cisco Agent Desktop (CAD) Supervisor Real Time Reports.
In order to validate further, use the platform CLI and run this command and observe the output:
run uccx sql db_cra call sp_agent_all_fields('2016-09-09
01:45:00','2016-09-10 15:46:40','0',null,null,'
Internal CLI Error: java.sql.SQLException: Overflow
occurred on a datetime or interval operation.
Command failed.
Cisco wrote a utility library in order to calculate a time delta between two dates.
Due to the code, dates later than 8 September, 2016 generate a negative value and the report generation fails.
Unable to run Agent Reports and receive this error:
Error information:
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: IX000 Vendor code: -1265 Message: Overflow occurred on a datetime or interval operation. } at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:952) at
CAD email reports as well as specific reports are also impacted
Follow the instructions provided in the Read-me document of the COP file in order to apply the COP file released for the defect.
The reports between the time when this issue occurred and this fix is applied will not be available because those records are written in the database (date and time field) with null values. For CAD Email Reports, reports will fail if there are any unhandled emails that came in between 9/8/2016 and when the COP file was installed. If none of these emails are in a CSQ folder or Agent's mailbox, the report should run. This is because these emails are still marked with a null date.
If you require further assistance, or if you have any further questions regarding this field notice, please contact the Cisco Systems Technical Assistance Center (TAC) by one of the following methods:
Cisco Notification Service—Set up a profile to receive email updates about reliability, safety, network security, and end-of-sale issues for the Cisco products you specify.
Unleash the Power of TAC's Virtual Assistance