获取目录和架构时发生 MSR_GEN_0097 错误： "OCI_dwh_JDBC" 无法连接到数据源。

最后更新
另存为PDF

Views:: 24

Visibility:: Public

Votes:: 0

Category:: oncommand-insight-data-warehouse

Specialty:: oci

Last Updated:

适用场景

OnCommand Insight DataWarehouse 7.3.11 ， Windows （ DWH ）
IBM Cognos 11.x

问题描述

无法打开从 IBM Cognos 到 DWH MySQL 数据库的 JDBC 连接
signon ocI_dwh_jdbc 无法连接或测试连接，并出现错误： XQE-DS-0006

在中发现错误 cognosserver.log：

2021-09-13T11:34:59.216+0200 ERROR com.ibm.bi.platform.moser.rs.endpoints.DataSources [Default Executor-thread-78570] wydGq4h9hvh8Cjdqhqw2vMqsM8q9s4C4Mdhsvssw wydGq4h9hvh8Cjdqhqw2vMqsM8q9s4C4Mdhsvssw y9ywwqshvdyC2ls8wwjCG2M4Cjsdy8ydlGjjqCjC NA 10.34.25.59 58900 LoginUserUser AggAAABqVUhhAAAAAAoAAAASh79MLtUb+gfuFAAAAI3BBmIGOBZ6FQkc/nbgMZ++2coJBwAAAFNIQS0yNTYgAAAAIVNrG1SJHm52uk52q8W+VeFvQ3OQosge0ngjKKI9AiE= /v1/metadata/dataSources/i45BF151DFC3D4D98BAE3AC15AED2E6FF/schemas modelingservice 4244 MSR_GEN_0097 Error while getting catalogs and schemas for: "oci_dwh_jdbc". Unable to connect to the data source. "Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server." com.ibm.bi.platform.moser.common.utils.MoserException: MSR_GEN_0097 Error while getting catalogs and schemas for: "oci_dwh_jdbc". Unable to connect to the data source. "Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server."