After fighting for days to load a HDFS file into a Hive table using ODI, now I'm trying to load some columns of this table into an Oracle DB. I created a new Interface with Source and Staging Area the Hive table and the Oracle DB as Target. When I execute the Interface, I'm getting this error:
ODI-1217: Session Hive to Oracle (40002) fails with return code 7000.
Caused By: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-17517: Error during task interpretation.
java.lang.Exception: The application script threw an exception: java.lang.RuntimeException:
Required unix environment variable ODI_OLH_JARS is undefined!
(I can paste the full log if necessary)
Obviously, I've checked that this variable is set in the machine containing both the ODI Agent and the OLH. It is set both in the root and the regular user. I've also tried to set oracle.hadoop.loader.libjars from the IKM File-Hive to Oracle properties with no success.
The error may be due to environment variable ODI_OLH_JARS is not set right. If you have added it to unix user profile - can you do a echo and see if the value is getting displayed by logging as that unix user.
The env variable should be set in unix users profile running the ODI studio and Agent.