Skip to main content
NetApp Stage KB

IBM Cognos JDBC connection to DWH MySQL fails with error XQE-DS-0006

Views:
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

Applies to

  • OnCommand Insight DataWareHouse 7.3.11, Windows (DWH)
  • IBM Cognos 11.x

Issue

  • Facing the error of the title while creating a dashboard in IBM Cognos
  • Cannot open a JDBC connection from IBM Cognos to DWH MySQL database
  • The signon oci_dwh_jdbc, is failing to connect or test connection with error: XQE-DS-0006

 

  • Errors found in 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+THGCAGMTJVJGFA=    /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.
6b42a841-20e1-46cf-8fa3-e5dc07a7c4b7