Cognos analysis studio + Vertica datasource error [RESOLVED]

[sdf]

encountering the following error :

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

Details :

UDA-SQL-0107 A general exception has occurred during the operation "prepare".
[Vertica][VerticaDSII] (10) An error occurred during query preparation: no connection to the server
RSV-SRV-0042 Trace back:
RSReportService.cpp(722): QFException: CCL_CAUGHT: RSReportService::process()
RSReportServiceMethod.cpp(263): QFException: CCL_RETHROW: RSReportServiceMethod::process(): reportEditAnalysisSpecification_Request
RSASyncExecutionThread.cpp(808): QFException: RSASyncExecutionThread::checkException
RSASyncExecutionThread.cpp(260): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): reportEditAnalysisSpecification_Request
RSASyncExecutionThread.cpp(864): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): reportEditAnalysisSpecification_Request
PPSAnalysis.cpp(180): QFException: CCL_RETHROW: PPSAnalysis::executeAnalysis
PPSAnalysis.cpp(172): QFException: CCL_CAUGHT: PPSAnalysis::executeAnalysis
core/RequestContext.cpp(547): QFException: CCL_RETHROW: RequestContext::handleRequest
core/RequestContext.cpp(540): QFException: CCL_CAUGHT: RequestContext::handleRequest
core/RequestContext.cpp(799): QFException: CCL_RETHROW: RequestContext::interpretActions
core/RequestContext.cpp(794): QFException: CCL_CAUGHT: RequestContext::interpretActions
scmd/QuerySessionProxy.cpp(59): QFException: CCL_RETHROW: CFaultSavvyProxy::DoRequest
scmd/QuerySessionProxy.cpp(57): QFException: CCL_CAUGHT: CFaultSavvyProxy::DoRequest
QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1102): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1078): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSConnection.cpp(788): QFException: CCL_RETHROW: QFSConnection::Execute
QFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2
DmMaProvider.cpp(954): QFException: CCL_RETHROW: DmMaProvider::MemberQuery::Execute
QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(1102): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1078): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()



Steps :

In Cognos Analysis Studio, when selecting any measure or dimension and dragging/droping to the work area results to error above.

Vertica datasource connection testing from cognos server is successful.

[sdf]

issue was resolved.

After series of search thru web. We came to the conclusion that the error was caused by joins and sql select statements established in Framework manager. Also this can be cause by unmatched data types. in our case some data types in Vertica doesnt match that of SQL.