when i ran the report i am getting below error can anyboby plz suggest me.
An error occurred while performing operation 'sqlScrollBulkFetch' status='-9'.
UDA-SQL-0107 A general exception has occurred during the operation "fetch".
[IBM][CLI Driver][DB2/AIX64] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007
RSV-SRV-0025 Unable to execute this request.
Trace back:
WPBIBusMethod.cpp(197): QSException: CCL_CAUGHT: WPBIBusMethod::runRequest
WPReportExecutionMethod.cpp(181): QSException: CCL_RETHROW: WPReportExecutionMethod::checkRequestForExceptions
WPExecuteRequestThread.cpp(169): QSException: WPExecuteRequestThread::checkException
WPEngine.cpp(1036): QSException:
WPController.cpp(263): QSException: CCL_RETHROW: WPController::executeRendering()
LWDataRetrievalEngine.cpp(756): QSException: CCL_RETHROW: LWDataRetrievalEngine::iterateResultSets
Source/QEDmResultSet.cpp(76): QSException: CCL_THROW: QE
Thanks in advance
Quote from: dwsudheer on 14 Oct 2009 02:22:03 AM
[IBM][CLI Driver][DB2/AIX64] SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007
Looks like it is a problem with a datetime field in your query, either you are trying to convert a string to a datetime or a datetime to string and aren't using the proper syntax. The correct syntax will be unique to the database you are trying to connect to.