Yes, other jobs are wokring fine. I am on CDH 5.9, so just tried with jar path in options list which is atleast running the job now. I am encountering below error while running the job, Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.SparkMain], main() threw exception, requirement failed java.lang.IllegalArgumentException: requirement failed     ... View more

I have kept only 1 driver sqljdbc41.jar in all directories and Oozie shared lib path. But still I am getting below error, Log Type: stderr Log Length: 3696 log4j:ERROR Could not find value for key log4j.appender.CLA log4j:ERROR Could not instantiate appender named "CLA". log4j:WARN No appenders could be found for logger (org.apache.hadoop.yarn.client.ConfiguredRMFailoverProxyProvider). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. Aug 16, 2016 9:45:42 AM com.microsoft.sqlserver.jdbc.SQLServerConnection <init> SEVERE: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0. java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.  Even I tried with driver sqljdbc4.jar, but it keep asking other version of driver other than present in directories.   After running a workflow, I realized there is workflow.xml generated in workspace but no job.properties. So I manually created job.properties as below and added in workspace,     Below is workflow.xml generated ,   I am not entering any other job properties or parameters in workflow. Not sure if I am doing something wrong here, as I can not see jobTracker and nameNode actual names is workflow.xml file.   Please guide in this.           ... View more

Thank you Harsh. It was my bad to overlook the actul commands inside the Sqoop action.   Now I am getting below error,    Log Type: stderr     Log Length: 3696   log4j:ERROR Could not find value for key log4j.appender.CLA   log4j:ERROR Could not instantiate appender named "CLA".   log4j:WARN No appenders could be found for logger (org.apache.hadoop.yarn.client.ConfiguredRMFailoverProxyProvider).   log4j:WARN Please initialize the log4j system properly.   log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.   Aug 14, 2016 9:47:55 PM com.microsoft.sqlserver.jdbc.SQLServerConnection <init>   SEVERE: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.   java.lang.UnsupportedOperationException: Java Runtime Environment (JRE) version 1.7 is not supported by this driver. Use the sqljdbc4.jar class library, which provides support for JDBC 4.0.     I have below drivers in Oozie sahred lib / user/ oozie/ share/ lib/ lib_20150429135817/ sqoop, sqljdbc.jar, sqljdbc4.jar, sqljdbc41.jar, sqljdb42.jar   Also have below drivers, Edge node Sqoop2: /var/lib/sqoop2     sqljdbc41.jar Edge node Sqoop:  /var/lib/sqoop        sqljdbc.jar, sqljdbc4.jar, sqljdbc41.jar, sqljdb42.jar Sqoop2 Server:      /var/lib/sqoop2       sqljdbc.jar, sqljdbc4.jar, sqljdbc41.jar, sqljdb42.jar   Do I need to add sqljdbc4.jar on Edge node Sqoop2 directory as well remove drivers other than sqljdbc4.jar from all places ? What if in future I want to connect to another SQL Server with different version ? Are these drivers not come with older version compatibiltiy ?   Thank you, Vinod ... View more