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

Prompt page Query issue

Started by shaik.dba, 02 Jul 2015 03:11:13 PM

Previous topic - Next topic

shaik.dba

Hi All,

Am new to cognos reporting application. while validating a Query(executes function in MySQL) in cognos 8.4, we are getting
an error mentioned below (data-source is replication). The same query Validates fine when Production data-source is given.
Please help.

Query:-
SELECT ocsales.rpt_display_range(#prompt('StartDateTime')#,'S',#prompt('DateRangeInd')#,#prompt('DaysToRun')#)  AS startdate
          , ocsales.rpt_display_range(#prompt('EndDateTime')#,'E',#prompt('DateRangeInd')#,#prompt('DaysToRun')#) AS enddate


UDA-SQL-0397 The server on "prepare" for user "{1}" has timed out.
[MySQL][ODBC 3.51 Driver][mysqld-5.6.22]Incorrect date value: 'testValue' for column 'varDate' at row 1

RSV-SRV-0042 Trace back:
RSReportService.cpp(805): UDASQLException: CCL_CAUGHT: RSReportService::process()
RSReportServiceMethod.cpp(265): UDASQLException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_Request
RSASyncExecutionThread.cpp(787): UDASQLException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(224): UDASQLException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_Request
RSASyncExecutionThread.cpp(837): UDASQLException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_Request
RSQueryMgr.cpp(1555): UDASQLException: CCL_RETHROW: RSQueryMgr::executeRsapiCommand
QFSSession.cpp(716): UDASQLException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(714): UDASQLException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(659): UDASQLException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSConnection.cpp(1957): UDASQLException: CCL_RETHROW: QFSConnection::DescribeDataSourceQuery
QFSQuery.cpp(555): UDASQLException: CCL_RETHROW: QFSQuery::DescribeDataSourceQuery
QFSQuery.cpp(555): UDASQLException: CCL_RETHROW: QFSQuery::DescribeDataSourceQuery
Source/AQE_UDAFacade.cpp(1692): UDASQLException: CCL_RETHROW:
apidyn.cpp(248): UDASQLException: CCL_RETHROW: sqlPrepareWithOptions

shaik.dba

Hi All,

If you need more details regarding this i can provide please let me know.