Problem Description
When CUIC Agent Report is run, the agent report fails with the error that contains the following line:
Overflow occurred on a datetime or interval operation
Complete Error will be similar to as as follows:
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
com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.executeQueryUsingDatasetBuilder(CuicReportEngineWorker.java:80)
at
com.cisco.ccbu.cuic.businesslogic.engine.CuicReportEngineWorker.runReport(CuicReportEngineWorker.java:37)
at
com.cisco.ccbu.cuic.businesslogic.enginebase.Worker.run(Worker.java:329)
at
com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:92)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:724) at
com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
Caused by: java.sql.SQLException: Overflow occurred on a datetime or
interval operation. at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413) at
com.informix.jdbc.IfxSqli.a(IfxSqli.java:3647) at
com.informix.jdbc.IfxSqli.E(IfxSqli.java:3974) at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2695) at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2611) at
com.informix.jdbc.IfxSqli.a(IfxSqli.java:1830) at
com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1768) at
com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1699) at
com.informix.jdbc.IfxResultSet.a(IfxResultSet.java:210) at
com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:1237) at
com.informix.jdbc.IfxPreparedStatement.executeQuery(IfxPreparedStatement.java:401)
at
com.informix.jdbc.IfxCallableStatement.executeQuery(IfxCallableStatement.java:241)
at
com.mchange.v2.c3p0.impl.NewProxyCallableStatement.executeQuery(NewProxyCallableStatement.java:2131)
at
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1072)
at
com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:938)
... 8 more Caused by: java.sql.SQLException at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:413) at
com.informix.jdbc.IfxSqli.E(IfxSqli.java:3979) ... 20 more
So far, the issue has been reported on UCCX Versions 11.X, 10.X, 9.X, 8.X and can potentially impact HRC reporting as well.
The issue is filed as a defect already:
CSCvb27878 UCCX/CUIC: Overflow occurred on a datetime or interval operation
Since the defect is newly filed, it may not be visible externally at the moment. However, the fix for the defect is already available and can be installed on the affected UCCX servers without requiring any downtime.
The fix for the defect involves installing "ciscouccx.ReportFix.10.cop.sgn" file on both the UCCX Nodes. Installation of this file does not require any service restart and hence can be performed without requiring any reboot.
This should resolve your CUIC reporting issue mentioned above.
Frequently Asked Questions
Q. I have a UCCX HA environment. Do I need to install the cop file on both the nodes?
Ans: Yes, you need to install the cop file on both the nodes.
Q. Does the installation of this cop file require any downtime or does it have any impact on service?
Ans: The cop file installation does not require any restart of service or reboot of server. Thus, it does not require any downtime and does not have any impact on service.
Q. Are there different cop files for different UCCX versions?
Ans: No, the same cop file work for any UCCX version equal to or higher than 8.x
Q. Can this cop file be installed on ES or SU version of UCCX?
Ans: Yes, it can be installed on ES or SU versions too.
Q. Can I install this cop file from GUI?
Ans: No. This cop file installation is only supported when done through the UCCX command line interface (CLI).
Q. Is there any UCCX Version available that has the fix for the defect CSCvb27878?
Ans: There is no UCCX version available at the moment that has the fix for the defect: CSCvb27878
Hope this helps!
Regards,
Saurabh
