cognos数据源配置修改oracle,Cognos 新建数据源报错(原创)

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种可能

解决方式，

使用了Oracle 11.2.0 client 64bit，应使用Oracle 11.2.0 Client 32bit?

没有正确设置$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

写在最后

今天关于面试的分享就到这里，还是那句话，有些东西你不仅要懂，而且要能够很好地表达出来，能够让面试官认可你的理解，例如Handler机制，这个是面试必问之题。有些晦涩的点，或许它只活在面试当中，实际工作当中你压根不会用到它，但是你要知道它是什么东西。

最后在这里小编分享一份自己收录整理上述技术体系图相关的几十套腾讯、头条、阿里、美团等公司的面试题，把技术点整理成了视频和PDF（实际上比预期多花了不少精力），包含知识脉络 + 诸多细节，由于篇幅有限，这里以图片的形式给大家展示一部分。

还有 高级架构技术进阶脑图、Android开发面试专题资料，高级进阶架构资料 帮助大家学习提升进阶，也节省大家在网上搜索资料的时间来学习，也可以分享给身边好友一起学习。

【Android核心高级技术PDF文档，BAT大厂面试真题解析】

【算法合集】

【延伸Android必备知识点】

】**

[外链图片转存中…(img-Zi7AWh8I-1719808016751)]

【算法合集】

[外链图片转存中…(img-CXfFuNGy-1719808016752)]

【延伸Android必备知识点】

[外链图片转存中…(img-qkU7aYSH-1719808016752)]