当前位置:首页 > 开发 > 行业应用 > 正文

Cognos 新建数据源报错(原创)

发表于: 2015-01-01   作者:czmmiao   来源:转载   浏览次数:
摘要: Cognos 新建数据源报错 软件环境Cognos 10.2 Linux 64bit, Oracle 11.2.0 server 64bit, Oracle 11.2.0 client 64bit, Apache 2.2 报错如下 QE-DEF-0285 The logon failed.QE-DEF-0325 The logon failed for the following reaso

Cognos 新建数据源报错

软件环境Cognos 10.2 Linux 64bit, Oracle 11.2.0 server 64bit, Oracle 11.2.0 client 64bit, Apache 2.2

报错如下

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
    testDataSourceConnection

UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(2028): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2070): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE

Script Stack Trace

Action No=1   Action Name=TestDataSourceConnection

以上报错有如下2种可能
解决方式,

  1. 使用了Oracle 11.2.0 client 64bit,应使用Oracle 11.2.0 Client 32bit 
  2. 没有正确设置$LD_LIBRARY_PATH,应在cognos用户的.bash_profile文件中包含如下信息
    export ORACLE_HOME=/u01/app/oracle/32client/product/11.2.0/dbhome_1
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/usr/lib64

没有正确配置cognos用户下的$TNS_ADMIN目录下的tnsnames.ora

QE-DEF-0285 The logon failed.
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:
    testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" 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: "PROD".
ORA-12154: TNS:could not resolve the connect identifier specified

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(2028): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2070): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE

Script Stack Trace

Action No=1   Action Name=TestDataSourceConnection

没有正确配置cognos用户下的$TNS_ADMIN

QE-DEF-0285 The logon failed.
QE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
    testDataSourceConnection

UDA-SQL-0031 Unable to access the "testDataSourceConnection" 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-0107 A general exception has occurred during the operation "attach".
ORA-12162: TNS:net service name is incorrectly specified

BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1147): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1145): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(2028): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2070): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE

Script Stack Trace

Action No=1   Action Name=TestDataSourceConnection

本文原创,转载请注明出处、作者

如有错误,欢迎指正

邮箱:czmcj@163.com

Cognos 新建数据源报错(原创)

  • 0

    开心

    开心

  • 0

    板砖

    板砖

  • 0

    感动

    感动

  • 0

    有用

    有用

  • 0

    疑问

    疑问

  • 0

    难过

    难过

  • 0

    无聊

    无聊

  • 0

    震惊

    震惊

编辑推荐
1.新建数据源连接: 1)打开Cognos Connection页面,启动 IBM Cognos Administration--配置--数据源
1:配置-数据源连接-新建数据源-指定数据源名称 2:选择数据库类型,暂时不配置jdbc 3:指定服务器,
1.导入sample package 将D:\ibm\cognos\c10\webcontent\samples\content目录下的powercube.zip复制
报错信息: 15:35:02, 'LogService', 'StartService', 'Success'. 15:35:03, CAF input validation
文章來源於 sina 煙鬼博客 寫於 2009-05-02 09:59 OS:REDHAT linux AS 5 1. 首先在/etc/passwd 文
错误信息: 标题 : Microsoft SQL Server Management Studio -- -- -- -- -- -- -- -- -- -- -- --
今天做struts练习的时候,每个部分都正确,可是居然报错:Module not found 。如图: 开始认为是str
1)一般情况我们只是用Cognos Client即可,Cognos Client包括 Transformer,Framework Manager。 安
背景: 最近有个项目,有32家分公司,集团总部需要取这个32家分公司数据做分析,由于每个分公司的数
建立Empty Application,新建Storyboard并添加View Controller 控件后运行为空白,并报错 控制台显
版权所有 IT知识库 CopyRight © 2009-2015 IT知识库 IT610.com , All Rights Reserved. 京ICP备09083238号