CUIC Reports creation

[ganeshv10]

I am creating an Relative dates and along with the Stock reports Agent Historical All Fields UCCE 8.5(4).

Query Type: Anonymous Block

Data source: UCCE Historical

1. Created parameters and fields.

2. Set values of Relative dates to Decimal and Start & End date to DateTime.

No error from Report Definition.

I have created an report and mapped to this Report Definition, while running the report it gives as Dataset status is failed(Database error).

Please help

[Aaron Harrison]

Hi

Clicking the 'show errors' button near the database error will give you more clues as to the reason for the failure.

Regards

Aaron

[Vuong Ngoc Trac]

Hi,

I just got the same "Dataset Status is Failed" error when running some reports on CUIC (other reports works fine). The error details are as below. Please advise what I should do to fix this issue. Thank you.

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

[Chintan Gajjar]

Might be hitting below:

https://bst.cloudapps.cisco.com/bugsearch/bug/CSCvb27878

Regards

Chintan

[Mcneiby345]

Hello Arron 

We are running 

CISCO please review this bug: CSCur39984

The listed bug we are unable to open and do not have privilege to open, this is a CISCO internal bug : CSCvb27878

We are running Versions:

Cisco Unified CCX Administration

System version: 10.6.1.11001-31

=========

 Cisco Unified CM Administration

 System version: 10.5.2.12901-1

 Workaround is not completely working , some reports still fail 

CUIC receiving error Dataset status is Unknown no reporting

Action Plan:

This error is due to BUG CSCur39984 and the workaround is the following:

Please open CLI for node 1 and 2 using putty/secureCRT and run the following queries –

run sql delete from cuic_data:cuicdataset

run sql delete from cuic_data:cuicstatisticsdatasets

run sql delete from cuic_data:cuicstatisticsviews

run sql delete from cuic_data:cuicdatasetreplicated

please restart CUIC services using :

utils service restart Cisco Unified Intelligence Center Reporting Service

utils service restart Cisco Unified Intelligence Center Serviceability Service

Perform this process on Node 1 first and then on Node 2.

[Mcneiby345]

Hello 

Wanted to update , Cisco development team have resolved the issue related to bug 

CSCvb27878 UCCX/CUIC: Overflow occurred on a datetime or interval

Operation

Please contact CISCO at this time it is in Tac Assist mode until release of the bug ID

If your error details have (Overflow occurred on a datetime or interval

Operation) it would be a simple cop file update with no interruption in service.  

[Mcneiby345]

Have we obtain a fix for this issue , it was supposed to be fixed in 10.5 we are running 10.6

Error detail

Error detail:

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 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

[Chintan Gajjar]

Can you please also attach the error details (the entire content of show error detail button)?

[ganeshv10]

[ganeshv10]

Can you see the errors and let me know.

[Chintan Gajjar]

looks like some syntax error, can you also attach the Report Definition. may be some thing wrong there.

[rikardkrvaric]

It appears to be happening to everyone.

There is a fix on this thread:

https://supportforums.cisco.com/discussion/13118806/cuic-uccx-dataset-status-failed-database-error