Problem
当使用CQM/兼容/OCI方式连接Oracle时,所有报表运行都报“DPR-ERR-2056 报表服务器没有反应”。
数据源测试失败。详细信息如下
DPR-ERR-2056 The Report Server is not responding
Handler trace back: [the_dispatcher]
com.cognos.pogo.handlers.performance.PerformanceIndicationHandler [the_dispatcher]
com.cognos.pogo.handlers.logic.ChainHandler [service_lookup]
com.cognos.pogo.handlers.engine.ServiceLookupHandler [load_balancer]
com.cognos.pogo.handlers.logic.ChainHandler [lb_forwarder]
com.cognos.p2plb.clerver.LoadBalanceHandler [mdaChainHandler]
com.cognos.pogo.handlers.logic.ChainHandler [asyncMetadataServiceHandler]
com.cognos.pogo.async.impl.AsyncHandler [metadataServiceHandler]
com.cognos.metadataService.bibusHandler.MDSRVHandler
Cause
使用了64位的Oracle客户端程序或者使用了不当的32位客户端
Environment
Congos on Linux
Resolving The Problem
确保您安装了32位的Oracle客户端。 对于某些Oracle服务器版本比如11.2.0.4.0,如果要使用Cognos连接,请使用相应的32位客户端程序。
同时,要确保TNS正确设置以及环境变量都正确指向。 比如PATH, LD_LIBRARY_PATH(LINUX).
[{"Product":{"code":"SSEP7J","label":"Cognos Business Intelligence"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Cognos Administration","Platform":[{"code":"PF016","label":"Linux"}],"Version":"10.2.2;10.2.1;10.2;10.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]