Buy or Renew
Buy or Renew
COMING SOON: Umbrella and Secure Access release notes are coming to Cisco Community. The community will be in read-only August 16 – 19. Learn more.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Start a conversation
1877
Views
0
Helpful
1
Replies

CUIC Error log

harageri1
Level 1
Level 1

‎07-23-2017 11:57 PM - edited ‎03-15-2019 06:30 AM

Hi,

I have a problem with undesrtanding this log - about error (may i please someone to explain it ?)

at com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
][product_name=CUIC][subsystem_exception_info=][tid=pool-1-thread-774-CUIC100-12449][version_number=CUIC_10_0_1_0_0_0_182]: Information associated with the following logged exception
0000002756: 172.27.139.180: Jun 14 2017 12:33:54.559 +0200: %CCBU___________CUIC-0-DEBUG:  It's an SQLException with SQL State = S0002 <- CuicDataSourceSwitchUtil.java:102 [com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceSwitchUtil.isSwitchableException]
0000000010: 172.27.139.180: Jun 14 2017 12:33:54.559 +0200: %CCBU_CUIC_DATA_PROCESSING-3-EXCEPTION: %[EXCEPTION=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: S0002 Vendor code: 208 Message: Invalid object name 'ucce_app.dbo.SG_Stats'. }]: There was an exception that occurred.
0000000011: 172.27.139.180: Jun 14 2017 12:33:54.560 +0200: %CCBU_CUIC_DATA_PROCESSING-3-EXCEPTION_INFO: %[build_date=Jan 01, 1970 3:13 AM][build_type=rel][exception=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: S0002 Vendor code: 208 Message: Invalid object name 'ucce_app.dbo.SG_Stats'. }
    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$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:619)
    at com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ucce_app.dbo.SG_Stats'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
    at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1065)
    at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:938)
    ... 8 more
][product_name=CUIC][subsystem_exception_info=][tid=pool-1-thread-774-CUIC100-12449][version_number=CUIC_10_0_1_0_0_0_182]: Information associated with the following logged exception
0000000012: 172.27.139.180: Jun 14 2017 12:33:54.560 +0200: %CCBU_CUIC_DATA_PROCESSING-3-RPT_WORKER_DBERROR: %[DATASET=[Report Definition Id: D47074801000013648A5519753EE19B0, Filter Id: D4A4F674100001367671342153EE19B0, User TimeZone: Europe/Warsaw]][EXCEPTION=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: S0002 Vendor code: 208 Message: Invalid object name 'ucce_app.dbo.SG_Stats'. }][RPTDEFFILTER_ID=D4A4F674100001367671342153EE19B0][RPTDEF_ID=D47074801000013648A5519753EE19B0]: Worker thread: Error running report. DataSourceServiceManager encountered a SQLException or other DB error while executing query to produce DataSet
0000000013: 172.27.139.180: Jun 14 2017 12:33:54.560 +0200: %CCBU_CUIC_DATA_PROCESSING-3-EXCEPTION_INFO: %[build_date=Jan 01, 1970 3:13 AM][build_type=rel][exception=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: S0002 Vendor code: 208 Message: Invalid object name 'ucce_app.dbo.SG_Stats'. }
    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$Worker.runTask(ThreadPoolExecutor.java:886)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
    at java.lang.Thread.run(Thread.java:619)
    at com.cisco.ccbu.infra.threads.ThreadPoolThread.run(ThreadPoolThread.java:164)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'ucce_app.dbo.SG_Stats'.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
    at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:989)
    at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.executeAndLoadDataset(CuicDataSourceServiceManagerImpl.java:1065)
    at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceMan

Labels:
0 Helpful
1 Reply 1

Chintan Gajjar
Level 8
Level 8

‎07-24-2017 05:26 AM

looks like "ucce_app.dbo.SG_Stats" is not been able to map to the correct table in the database.

when are you getting this error? while trying to create a report definition? if yes make sure the data source you selected is correct and has "ucce_app.dbo.SG_Stats".

0 Helpful
Customers Also Viewed These Support Documents