If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report error

Started by dwsudheer, 14 Oct 2009 02:22:03 AM

Previous topic - Next topic

dwsudheer

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

cschnu

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.