メインコンテンツまでスキップ

MSR の GEN_0097 エラーが発生しました。「 oci_dwh_jdbc 」のカタログおよびスキーマを取得できません。

Views:
20
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 接続を開けません
  • oca_dwh_jdbc という署名があり、接続または接続のテストに失敗しています。エラー: XQE-DS-0006

cognos_XQE-DS-0006.JPG

 

  • 検出されたエラー 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."

Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.