Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


ERROR: BDRM script on Linux fails after TLS is enabled on the HIVE server
Problem Description
1) TLS was enabled on Hive server. 

2) It requires using SSL= true, trust store and truststore password. 
(Note: Trust store password is removed from security reason). 

3) The connection string manually works but when bdrm shell script is run it fails. DMBDEHiveConnector MapReduce Job Failed with exception:
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:1000/infa_household;principal=
password;saslQop=auth-conf: Invalid status 21 
at com.informatica.mdmbde.database.hive.HiveDatabaseAdapterImpl.createConnection( 
at com.informatica.
at com.informatica.mdmbde.hive.driver.MDMBDEHiveEnabler.initializeHive( 
at com.informatica.mdmbde.hive.driver.MDMBDEHiveEnabler.runJob( at com.informatica.mdmbde.hive.driver.MDMBD
EHiveEnabler.main( at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
at sun.reflect.NativeMethodAccessorImpl.invoke( 
at sun.reflect.DelegatingMethodAccessorImpl.invoke( 
at java.lang.reflect.Method.invoke( 
at org.apache.hadoop.util.RunJar.main( Caused by: java.sql.SQLException: 
Could not open client transport with JDBC Uri: jdbc:hive2://localhost:100​0/infa_household;principal=hive/localhost@abc.COM​
The problem occurs because of a known issue (BDRM-2361) 
This is a known issue (BDRM-2361) which has been resolved in Master Data Management (MDM) - Relate 360 10.0 HotFix 9. To resolve this issue, upgrade to MDM - Relate 360 10.0 HotFix 9.


1) Look for a standalone.jar for hive in your machine (Ex: find / -name *-standalone.jar). Choose the one which is close to hive version 1.1.1
For example in cdh513kerb01 you will get /opt/cloudera/parcels/CDH-5.14.4-1.cdh5.14.4.p0.3/jars/hive-jdbc-1.1.0-cdh5.14.4-standalone.jar and in hdp26relate001/usr/hdp/
2) Follow the below steps to execute in CDH when hive is SSL enabled:
cp /opt/cloudera/parcels/CDH-5.14.4-1.cdh5.14.4.p0.3/jars/hive-jdbc-1.1.0-cdh5.14.4-standalone.jar /usr/local/mdmbdrm-10.0/bin/
cd /usr/local/mdmbdrm-10.0/bin/
rm -rf hive-jdbc.jar
cp hive-jdbc-1.1.0-cdh5.14.4-standalone.jar hive-jdbc.jar
chmod 777 hive-jdbc.jar
More Information
Applies To
Product: Relate 360
Problem Type: Installation
User Type: Administrator
Project Phase: Implement
Product Version:
Operating System:
Other Software:

Last Modified Date:7/10/2019 9:41 AMID:573979
People who viewed this also viewed


Did this KB document help you?

What can we do to improve this information (2000 or fewer characters)