Hi,
When i tried to run the report in report studio i got the the login error.i did the odbc connection and i tested it was sucess but while running the report i am getting the error. please find below the error for reference.
Waiting for quick response.
QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
OCC_ODS1
UDA-SQL-0031 Unable to access the "OCC_ODS1" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.UDA-SQL-0532 Data Source is not accessible: "OCC_ODS".[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedRSV-SRV-0042 Trace back:RSReportService.cpp(724): QFException: CCL_CAUGHT: RSReportService::processImpl()RSReportServiceMethod.cpp(258): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(857): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(311): QFException: CCL_CAUGHT: RSASyncExecutionThread::runImpl(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(914): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestRSRequest.cpp(1705): QFException: CCL_THROW: RSRequest::executeInteractivePrompting()RSQueryMgr.cpp(530): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(602): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(710): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgrBasic.cpp(289): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrBasic.cpp(278): QFException: CCL_RETHROW: RSQueryMgrBasic::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(174): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(165): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(1108): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1084): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSConnection.cpp(800): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(2041): QFException: CCL_RETHROW: QECoordinationQFSQuery.cpp(4378): QFException: CCL_RETHROW: CoordinationQFSQuery::CallProviderQFSQuery.cpp(246): QFException: CCL_RETHROW: QFSQuery::EXecute v3Source/RQP_QFSQuery.cpp(492): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3692): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3631): QFException: CCL_RETHROW: QESource/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE
Thanks,
sekhar
And what have you checked beyond the ODBC connection?
Thanks for your reply,
i checked sign-on beyond the odbc connection, i tested data in framework manager the data getting fine but in report studio only i am getting error.
Thanks,
sekhar
Quote from: sekhar1988 on 19 Aug 2015 06:32:51 AM
Thanks for your reply,
i checked sign-on beyond the odbc connection, i tested data in framework manager the data getting fine but in report studio only i am getting error.
Thanks,
sekhar
Hi,
Is Framework Manager on a different machine from your BI server instance? If so, FM will be using an ODBC definition on the machine it is installed on, and your BI server will be using an ODBC connection defined on that machine. make sure they are set up in exactly the same way.
Cheers!
MF.
thanks MFGF for quick reply,
Both,the framework manager and BI sever installed in same machine(windows server).
Thanks,
sekar