ODI 12c Mapping Hive to Oracle Using Spark Technology Fails on "LKM Spark to SQL" Global with Password Error
(Doc ID 2373855.1)
Last updated on JULY 13, 2018
Oracle Data Integrator - Version 188.8.131.52.0 and later Information in this document applies to any platform.
The following error is observed in Oracle Data Integrator (ODI) 12c when running a Mapping that has an Apache Spark source Datastore, and uses "LKM Spark to SQL":
ODIKM-SPARK-SYNC-10000: EKM Command Failed with Exception: java.lang.Exception: Traceback (most recent call last): 13 File "/tmp/MyMapping_Physical.py", line 107, in 14 props = getSqlJDBCProps(sc) 15 File "/tmp/MyMapping_Physical.py", line 73, in getSqlJDBCProps 16 raise Exception( "Hadoop Credential provider does not contain entry for alias " + pwdholder + ". Spark will be unable to connect to target data server. Configure Hadoop Credential provider and re-try." ) 17 Exception: Hadoop Credential provider does not contain entry for alias odi.MyDBUserName.MyDataServerName.password. Spark will be unable to connect to target data server. Configure Hadoop Credential provider and re-try.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a Million Knowledge Articles and hundreds of Community platforms