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
Cause
Incorrect driver versions used.
Resolving The Problem
1. Copy the following from the Hive/Hadoop downloaded drivers into the drivers subdirectory of the Cognos Analytics 11 installation directory:
commons-logging-1.1.3.jar
hadoop-core-1.2.1.jar
hive-exec-1.2.1.jar
hive-jdbc-1.2.1.jar
hive-metastore-1.2.1.jar
hive-service-1.2.1.jar
httpclient-4.4.jar
httpcore-4.4.jar
libfb303-0.9.2.jar
libthrift-0.9.2.jar
commons-codec-1.4.jar
2. Restart Cognos Analytics 11 services and test.
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21977509