报错：QE-DEF-0285 登陆失败
小弟用fm做了一个包，发布到Cognos系统中，用人report studio做表运行时，会出现这个错误：
请问下，要怎么解决？需要修改哪些文件才可以使Cognos系统连接数据库？我在本机上是可以连接数据库的。
QE-DEF-0285 登陆失败
QE-DEF-0325 由于以下原因导致登录失败：RQP-DEF-0068 对 oracle 中的 1 个数据库进行多项连接时，至少无法连接一个数据库。UDA-SQL-0432 无法找到“libcogudaor”网关。RSV-SRV-0042 回溯：RSReportService.cpp(771): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(787): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(837): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(606): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(277): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(176): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(300): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(173): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSAssembly.cpp(639): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(680): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(1003): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1076): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1241): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1555): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(187): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(167): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(264): QFException: CCL_RETHROW: RSQFSession:oRequestQFSSession.cpp(716): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSSession.cpp(714): QFException: CCL_CAUGHT: QFSSession:rocessDoRequest()QFSSession.cpp(659): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSSession.cpp(634): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSConnection.cpp(751): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(1897): QFException: CCL_RETHROW: QECoordinationQFSQuery.cpp(4088): QFException: CCL_RETHROW: CoordinationQFSQuery::CallProviderQFSQuery.cpp(246): QFException: CCL_RETHROW: QFSQuery::EXecute v3Source/RQP_QFSQuery.cpp(492): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3605): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3553): QFException: CCL_RETHROW: QESource/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE
请问下，要怎么解决？需要修改哪些文件才可以使Cognos系统连接数据库？我在本机上是可以连接数据库的。
QE-DEF-0285 登陆失败
QE-DEF-0325 由于以下原因导致登录失败：RQP-DEF-0068 对 oracle 中的 1 个数据库进行多项连接时，至少无法连接一个数据库。UDA-SQL-0432 无法找到“libcogudaor”网关。RSV-SRV-0042 回溯：RSReportService.cpp(771): QFException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265): QFException: CCL_RETHROW: RSReportServiceMethod::process(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(787): QFException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): QFException: CCL_CAUGHT: RSASyncExecutionThread::run(): asynchRunSpecification_RequestRSASyncExecutionThread.cpp(837): QFException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): asynchRunSpecification_RequestExecution/RSRenderExecution.cpp(606): QFException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(277): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77): QFException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(176): QFException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(300): QFException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(173): QFException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): QFException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): QFException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSAssembly.cpp(639): QFException: CCL_RETHROW: RSAssembly::createListIteratorAssembly/RSAssembly.cpp(680): QFException: CCL_RETHROW: RSAssembly::createListIteratorRSQueryMgr.cpp(1003): QFException: CCL_RETHROW: RSQueryMgr::getListIteratorRSQueryMgr.cpp(1076): QFException: CCL_RETHROW: RSQueryMgr::getResultSetIteratorRSQueryMgr.cpp(1241): QFException: CCL_RETHROW: RSQueryMgr::createIteratorRSQueryMgr.cpp(1555): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgr.cpp(1542): QFException: CCL_RETHROW: RSQueryMgr::executeRsapiCommandRSQueryMgrExecutionHandlerImpl.cpp(187): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQueryMgrExecutionHandlerImpl.cpp(167): QFException: CCL_RETHROW: RSQueryMgrExecutionHandlerImpl::execute()RSQFSession.cpp(264): QFException: CCL_RETHROW: RSQFSession:oRequestQFSSession.cpp(716): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSSession.cpp(714): QFException: CCL_CAUGHT: QFSSession:rocessDoRequest()QFSSession.cpp(659): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSSession.cpp(634): QFException: CCL_RETHROW: QFSSession:rocessDoRequest()QFSConnection.cpp(751): QFException: CCL_RETHROW: QFSConnection::ExecuteQFSQuery.cpp(213): QFException: CCL_RETHROW: QFSQuery::Execute v2CoordinationQFSQuery.cpp(1897): QFException: CCL_RETHROW: QECoordinationQFSQuery.cpp(4088): QFException: CCL_RETHROW: CoordinationQFSQuery::CallProviderQFSQuery.cpp(246): QFException: CCL_RETHROW: QFSQuery::EXecute v3Source/RQP_QFSQuery.cpp(492): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3605): QFException: CCL_RETHROW: QESource/QE_RsApi.cpp(3553): QFException: CCL_RETHROW: QESource/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE
9同行回答
我今天也遇到这个问题，在确认客户端版本、jar包、以及数据库连接性都没问题之后，发现环境变量里边，path里边多了一个oracle9i的路径，也就是我这同事有9i和11g的两个oracle环境变量，删掉就好了，希望可以帮住同志们（这个路径是由于安装一个了绿色版plsql造成的）收起
浏览3070
我碰到同样一个问题，
你需要配置数据源。例如oracle。
将ORACLE_HOME/jdbc/lib目录下的classes12.zip文件[ORACLE_HOME指ORACLE的安装目录]复制到Cognos8/webapps/p2pd/WEB-INF/lib目录下，并将classes12.zip文件重命名为classes12.jar。收起
你需要配置数据源。例如oracle。
将ORACLE_HOME/jdbc/lib目录下的classes12.zip文件[ORACLE_HOME指ORACLE的安装目录]复制到Cognos8/webapps/p2pd/WEB-INF/lib目录下，并将classes12.zip文件重命名为classes12.jar。收起
浏览3078
The application server (which has the tnsnames setup) needs to be in the access control lists for the database host.
access control list (ACL) is a list of permissions attached to an object. The list specifies who or what is allowed to access the object and what operations are allowed to be performed on the object. In a typical ACL, each entry in the list specifies a subject and an operation: for example, the entry (Alice, delete) on the ACL for file XYZ gives Alice permission to delete file XYZ.
收起浏览2849