IBM Support

Hive Datasource Connection fails with XQE-GEN-0002 An unexpected exception occurred: org.apache.curator.RetryPolicy

Troubleshooting


Problem

When creating a HIVE data source connection in the Cognos Administration Console, the test fails with the error:
XQE-GEN-0002 An unexpected exception occurred: org.apache.curator.RetryPolicy
image-20240811200935-1

Symptom

XQE Logs contain the following excerpt:
 

<event component="XQE" group="Exception" level="ERROR" thread="113" timestamp="2024-08-09 15:18:48.647" contextId="28" requestId="wC4M8w9Gsy4MMh4qjCCsMswws42y4C92M9M4sh2M" sessionId="73019c77:19137af7561:-7ecd"><![CDATA[Caught error in V5QueryHandler: java.lang.NoClassDefFoundError: org.apache.curator.RetryPolicy
at org.apache.hive.jdbc.Utils.extractURLComponents(Utils.java:472)
at org.apache.hive.jdbc.Utils.parseURL(Utils.java:332)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:168)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
at com.ibm.cognos.jdbc.adaptor.AdaptorFactory.connect(AdaptorFactory.java:435)
at com.ibm.cognos.jdbc.adaptor.ConnectionFactory.createAndWrapConnection(ConnectionFactory.java:269)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.driverConnect(JDBCConnection.java:1136)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.driverConnect(JDBCConnection.java:1108)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.driverConnectKerberos(JDBCConnection.java:3256)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.connectWithAuthentication(JDBCConnection.java:3156)
at com.cognos.xqe.data.providers.relational.jdbc.JDBCConnection.connect(JDBCConnection.java:1291)
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:154)
at com.cognos.xqe.data.providers.relational.TraceRelationalDataProvider.testConnection(TraceRelationalDataProvider.java:222)
at com.cognos.xqebifw.bibushandler.ConnectionTester.doTestConnection(ConnectionTester.java:345)
at com.cognos.xqebifw.bibushandler.ConnectionTester.doTestConnection(ConnectionTester.java:365)
at com.cognos.xqebifw.bibushandler.ConnectionTester.testDataSourceConnection(ConnectionTester.java:179)
at com.cognos.xqebifw.bibushandler.TestDataSourceConnectionWithInfoRequestAdapter.executeRequest(TestDataSourceConnectionWithInfoRequestAdapter.java:95)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:812)
Caused by: java.lang.ClassNotFoundException: org.apache.curator.RetryPolicy
at com.ibm.ws.classloading.internal.AppClassLoader.findClassCommonLibraryClassLoaders(AppClassLoader.java:569)
at com.ibm.ws.classloading.internal.AppClassLoader.findClass(AppClassLoader.java:291)
at java.lang.ClassLoader.loadClassHelper(ClassLoader.java:925)
at java.lang.ClassLoader.loadClass(ClassLoader.java:870)
at com.ibm.ws.classloading.internal.AppClassLoader.findOrDelegateLoadClass(AppClassLoader.java:547)
at com.ibm.ws.classloading.internal.AppClassLoader.loadClass(AppClassLoader.java:505)
at java.lang.ClassLoader.loadClass(ClassLoader.java:853)
... 77 more

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Data Source"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.2.4;12.0.0;12.0.1;12.0.2;12.0.3"},{"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"}},{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB77","label":"Automation 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:
15 January 2026

UID

ibm17165248