Hello Team,
I have a issue to get a custom report: Contact Service Queue Call Distribution Summary 20
Times ago it was working correctly, but now it stopped working and I have this error:
[product_name=CUIC][subsystem_exception_info=][tid=pool-1-thread-70-CUIC1-70][version_number=CUIC_10_0_1_0_0_0_182]: Information associated with the following logged exception
0000117824: 10.99.88.12: Sep 02 2019 14:50:40.195 -0400: %CCBU_CUIC_DATA_PROCESSING-3-MSG_REPORT_EXECUTION_CRITICAL: %[RAISING_ALERT=Raising snmp alert to alert execution failure]: Worker thread: Error running report. Encountered a critical error trying to produce DataSet. Please check logs for more info
0000117825: 10.99.88.12: Sep 02 2019 14:50:40.199 -0400: %CCBU_CUIC_DATA_PROCESSING-3-RPT_WORKER_DBERROR: %[DATASET=[Report Definition Id: 3B87F8EF5C3E42E5BE6264A6F943E443, Filter Id: B4AE21631000016C000001960AA2180C, User TimeZone: America/Asuncion]][EXCEPTION=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: IX000 Vendor code: -674 Message: Routine (sp_csq_call_distribution) can not be resolved. }][RPTDEFFILTER_ID=B4AE21631000016C000001960AA2180C][RPTDEF_ID=3B87F8EF5C3E42E5BE6264A6F943E443]: Worker thread: Error running report. DataSourceServiceManager encountered a SQLException or other DB error while executing query to produce DataSet
0000117826: 10.99.88.12: Sep 02 2019 14:50:40.200 -0400: %CCBU_CUIC_DATA_PROCESSING-3-EXCEPTION_INFO: %[build_date=Dec 31, 1969 10:13 PM][build_type=rel][exception=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: IX000 Vendor code: -674 Message: Routine (sp_csq_call_distribution) can not be resolved. }
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: Routine (sp_csq_call_distribution) can not be resolved.
at com.informix.jdbc.IfxSqli.a(IfxSqli.java:3643)
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.executePrepare(IfxSqli.java:1410)
at com.informix.jdbc.IfxPreparedStatement.f(IfxPreparedStatement.java:326)
at com.informix.jdbc.IfxCallableStatement.<init>(IfxCallableStatement.java:141)
at com.informix.jdbc.IfxSqliConnect.i(IfxSqliConnect.java:6965)
at com.informix.jdbc.IfxSqliConnect.prepareCall(IfxSqliConnect.java:2842)
at sun.reflect.GeneratedMethodAccessor959.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at com.mchange.v2.c3p0.stmt.GooGooStatementCache$1StmtAcquireTask.run(GooGooStatementCache.java:525)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
When I select my custom report I get this message from CUIC: there are currently no parameters configured for this reports.
Please, Can someone help me :(
