Hi Guys,
Currently, I'm dealing with the following situation with the view report (Common Skills CSQ Activity):
An error message was obtained when trying to view the report on the CUIC website.
Spoiler (Highlight to read) "The execution of the report failed. Attempt to run the report again, and if the problem persists, contact the administrator."
"The execution of the report failed. Attempt to run the report again, and if the problem persists, contact the administrator."
The present UCCX system operates in a high-availability environment. I workaround the report view on UCCX -subscriber and it returned regular data. Only UCCX-publisher has the error message.
I double-checked the query from CLI UCCX in publisher it still returns the results.
However when I check CUIC log I saw the following message:
Spoiler (Highlight to read) [product_name=CUICJava][subsystem_exception_info=][tid=pool-2-thread-186][version_number=CUICJava_11_6_1_0_1_0_1121]: Information associated with the following logged exception 0020785192: (IP-UCCX-publisher): Sep 24 2021 17:35:02.851 +0700: %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 0020785193: (IP-UCCX-publisher): Sep 24 2021 17:35:02.853 +0700: %CCBU_CUIC_DATA_PROCESSING-3-RPT_WORKER_DBERROR: %[DATASET=[Report Definition Id: DCF8B4D41000017B000004DE0AA0B619, Filter Id: 175061231000017C0002A2280AA9B614, User TimeZone: Asia/Ho_Chi_Minh]][EXCEPTION=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: IX000 Vendor code: -958 Message: Temp table (informix.t_presented) already exists in session . }][RPTDEFFILTER_ID=175061231000017C0002A2280AA9B614][RPTDEF_ID=DCF8B4D41000017B000004DE0AA0B619]: Worker thread: Error running report. DataSourceServiceManager encountered a SQLException or other DB error while executing query to produce DataSet 0020785194: (IP-UCCX-publisher): Sep 24 2021 17:35:02.853 +0700: %CCBU_CUIC_DATA_PROCESSING-3-EXCEPTION_INFO: %[build_date=Jan 19, 1970 1:45 AM][build_type=rel][exception=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: IX000 Vendor code: -958 Message: Temp table (informix.t_presented) already exists in session . }
[product_name=CUICJava][subsystem_exception_info=][tid=pool-2-thread-186][version_number=CUICJava_11_6_1_0_1_0_1121]: Information associated with the following logged exception0020785192: (IP-UCCX-publisher): Sep 24 2021 17:35:02.851 +0700: %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 info0020785193: (IP-UCCX-publisher): Sep 24 2021 17:35:02.853 +0700: %CCBU_CUIC_DATA_PROCESSING-3-RPT_WORKER_DBERROR: %[DATASET=[Report Definition Id: DCF8B4D41000017B000004DE0AA0B619, Filter Id: 175061231000017C0002A2280AA9B614, User TimeZone: Asia/Ho_Chi_Minh]][EXCEPTION=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: IX000 Vendor code: -958 Message: Temp table (informix.t_presented) already exists in session. }][RPTDEFFILTER_ID=175061231000017C0002A2280AA9B614][RPTDEF_ID=DCF8B4D41000017B000004DE0AA0B619]: Worker thread: Error running report. DataSourceServiceManager encountered a SQLException or other DB error while executing query to produce DataSet0020785194: (IP-UCCX-publisher): Sep 24 2021 17:35:02.853 +0700: %CCBU_CUIC_DATA_PROCESSING-3-EXCEPTION_INFO: %[build_date=Jan 19, 1970 1:45 AM][build_type=rel][exception=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: IX000 Vendor code: -958 Message: Temp table (informix.t_presented) already exists in session. }
how to check the process or which session was utilized
I would really appreciate some help here if this is possible.
More information : UCCX version 11.6
UCCX HA environment