CUIC85_Migrated Webview Reports custom caltyp31 error

Document created by cdnadmin on Jan 25, 2014
Version 1Show Document
  • View in full screen mode
This document was generated from CDN thread

Created by: Sergey Ivanov on 28-11-2012 02:37:54 AM
CUIC85_Migrated Webview Reports custom caltyp31 error
Dear colleagues, 
I changed caltyp31 report. In report definision field i just change string "DateTime,
"  
to string "DateDay= Convert(DateTime,(Convert(Varchar(20), Call_Type_Half_Hour.DateTime, 112))),
"
in two points.
About two month this report has worked well. But some times ago this report is fail with error "there are currently no parameters configured for this report"
When I delete, change report definition id and name (standart license), and import report, it work well about two-three days. When issue is repeated. 
 
LOGS:
005: 10.30.30.19: Nov 28 2012 11:09:31.628 +0400: %CCBU_CUIC_DATA_PROCESSING-3-EXCEPTION_INFO: %[build_date=Mar 16, 2012 10:17 PM][build_type=rel][exception=com.cisco.ccbu.cuic.businesslogic.datasource.CuicDbException: DbException: CuicDataSourceServiceManagerImpl.getDataSet() { Nested SQLException; SQLState: S0001 Vendor code: 102 Message: Incorrect syntax near ':'. }

at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:1013)
at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.runReport(CuicDataProcessingCenterWorkerRunnable.java:335)
at com.cisco.ccbu.cuic.businesslogic.engine.CuicDataProcessingCenterWorkerRunnable.run(CuicDataProcessingCenterWorkerRunnable.java:142)
at com.cisco.ccbu.infra.threads.InstrumentedRunnable.run(InstrumentedRunnable.java:88)
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: Incorrect syntax near ':'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:197)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1493)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:390)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:340)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4575)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1400)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:179)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:283)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at com.cisco.ccbu.cuic.businesslogic.datasource.CuicDataSourceServiceManagerImpl.getDataSetBuilder(CuicDataSourceServiceManagerImpl.java:976)
... 7 more
][product_name=CUIC][subsystem_exception_info=][version_number=CUIC_8_5_3_0_0_0_134]: Information associated with the following logged exception 
0000000048: 10.30.30.19: Nov 28 2012 11:09:48.924 +0400: %CCBU___CUIC_DISPLAY-3-EXCEPTION: %: There was an exception that occurred. 
0000000049: 10.30.30.19: Nov 28 2012 11:10:07.124 +0400: %CCBU___CUIC_DISPLAY-3-EXCEPTION: %: There was an exception that occurred. 
0000000050: 10.30.30.19: Nov 28 2012 11:10:25.359 +0400: %CCBU___CUIC_DISPLAY-3-EXCEPTION: %: There was an exception that occurred. 
0000000051: 10.30.30.19: Nov 28 2012 11:10:43.875 +0400: %CCBU___CUIC_DISPLAY-3-EXCEPTION: %: There was an exception that occurred. 
0000000052: 10.30.30.19: Nov 28 2012 11:11:02.096 +0400: %CCBU___CUIC_DISPLAY-3-EXCEPTION: %: There was an exception that occurred. 
0000000053: 10.30.30.19: Nov 28 2012 11:11:20.316 +0400: %CCBU___CUIC_DISPLAY-3-EXCEPTION: %: There was an exception that occurred. 
0000000054: 10.30.30.19: Nov 28 2012 11:11:38.569 +0400: %CCBU___CUIC_DISPLAY-3-EXCEPTION: %: There was an exception that occurred. 
0000000055: 10.30.30.19: Nov 28 2012 11:11:56.773 +0400: %CCBU___CUIC_DISPLAY-3-EXCEPTION: %: There was an exception that occurred. 

Attachments

    Outcomes