IBM Support

Using Cognos Analytics 11 with Hive

Troubleshooting


Problem

When testing the connection to an Apache Hive 1.2 database with driver versions 0.12, 1.2, 1.2. and 0.14, the following errors are received: XQE-DS-0006 Unable to logon to the data source. com.ibm.cognos.jdbc.adaptor.sqlexception.SQLCognosInvalidLogonException: The connection object was not initialized properly. Caught error in V5QueryHandler: java.lang.NoClassDefFoundError: org.apache.http.config.Lookup

Symptom

Messages seen in the XQE log files include:

<![CDATA[Connection failed: com.ibm.cognos.jdbc.adaptor.sqlexception.SQLCognosInvalidLogonException: The connection object was not initialized properly.]]>

<![CDATA[Caught error in V5QueryHandler: XQE-DS-0006 Unable to logon to the data source.
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.mapConnectionException(JDBCConnection.java:1497)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.driverConnect(JDBCConnection.java:872)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.driverConnectKerberos(JDBCConnection.java:2745)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.connect(JDBCConnection.java:986)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnectionFactory.createConnection(JDBCConnectionFactory.java:122)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCDataProvider.testConnection(JDBCDataProvider.java:153)
at com.cognos.xqe.data.providers.relational.TraceRelationalDataProvider.testConnection(TraceRelationalDataProvider.java:222)
at com.cognos.xqebifw.bibushandler.ConnectionTester.doTestConnection(ConnectionTester.java:319)
at com.cognos.xqebifw.bibushandler.ConnectionTester.testDataSourceConnection(ConnectionTester.java:162)
at com.cognos.xqebifw.bibushandler.TestDataSourceConnectionWithInfoRequestAdapter.executeRequest(TestDataSourceConnectionWithInfoRequestAdapter.java:93)
at com.cognos.xqebifw.cubingservices.V5QueryHandler.executeRequestInSequence(V5QueryHandler.java:729)
at com.cognos.xqebifw.cubingservices.V5QueryHandler.execute(V5QueryHandler.java:548)
at com.cognos.xqebifw.cubingservices.RequestWorker.processMessage(RequestWorker.java:300)
at com.cognos.xqebifw.cubingservices.RequestWorker.processQueryInputMsg(RequestWorker.java:277)
at com.cognos.xqebifw.cubingservices.RequestWorker.call(RequestWorker.java:146)
at com.cognos.xqebifw.cubingservices.RequestWorker.call(RequestWorker.java:53)
at java.util.concurrent.FutureTask.run(FutureTask.java:277)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1153)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.lang.Thread.run(Thread.java:785)

<![CDATA[V5QueryHandler returning SOAP Fault for request type "testDataSourceConnectionWithInfo"]]

XQE-GEN-0002 An unexpected exception occurred.

XQE-GEN-0002 An unexpected exception occurred: org.apache.http.config.Lookup

[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.0","Edition":"All Editions","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SS6G84","label":"IBM Cognos Analytics on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
01 May 2025

UID

swg21977509

Page Feedback