IBM Support

Apache Hive 3.1 JDBC driver causes Cognos Analytics to fail to start

Troubleshooting


Problem

Some versions of the Apache Hive 3.1 JDBC driver JAR files include Java classes that cause Cognos Analytics 11.2.2 to fail to start.
An example is version 3.1.0.3.1.5.0-152

Cause

The JAR files provided by Apache include Java classes, which cause conflicts.
The log4j Java classes included with Apache Hive are incompatible with the log4j Java classes in Cognos Analytics.

Diagnosing The Problem

There is a log file in the logs subdirectory ffdc with the following text:
Caused by: java.util.ServiceConfigurationError: org.apache.logging.log4j.util.PropertySource: Provider org.apache.logging.log4j.util.EnvironmentPropertySource not a subtype

Resolving The Problem

Change the Apache Hive driver to latest which works with your server.
Apache Hive version 3.1.3000.7.1.6.0-297 is compatible with Cognos Analytics.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
08 April 2022

UID

ibm16559328