CUIC85_Migrated Webview Reports custom caltyp31 error

Version 1
    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.