Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hi I am getting oozie error " error code is=JA018" "error message=com/yammer/metrics/core/MetricsRegistry" while scheduling job in oozie for sqoop incremental import to hbase??help me??

avatar
Rising Star

4656-ja018.png

He is my job. properties and workflow.xml

job.properties

nameNode=hdfs://sandbox.hortonworks.com:8020                                                                                                         
jobTracker=sandbox.hortonworks.com:8050                                                                                                              
queueName=default                                                                                                      
examplesRoot=examples                                                                                                                             
oozie.use.system.libpath=true                                                                                                                        
oozie.libpath=${nameNode}/user/${user.name}/share/lib                                                                                                
oozie.wf.application.path=${nameNode}/user/${user.name}/${examplesRoot}/apps/sqoop/       



here is my workflow.xml

<workflow-app name="sqoop-hbase-wf" xmlns="uri:oozie:workflow:0.4">                                                                                  
    <start to="sqoop-import"/>                                                                                                                      
    <action name="sqoop-import">                                                                                                                     
        <sqoop xmlns="uri:oozie:sqoop-action:0.2">                                                                                                   
            <job-tracker>${jobTracker}</job-tracker>                                                                                                 
            <name-node>${nameNode}</name-node>                                                                                                                                                                                                                                      
            <job-xml>/user/root/hbase-site.xml</job-xml>                                                                                              
           <command>import --connect "jdbc:sqlserver://ip:port;database=ESP" --table bundle_plan_package --username omkar --password tarpass --incremental append --check-column packageid --hbase-table bundle_plan_package --column-family bundleid</command>                                                                                                                                    
  <file>/user/root/sqljdbc4.jar#sqljdbc4.jar</file>                                                                                                  
  <file>/user/root/hbase/hbase-client.jar#hbase-client.jar</file>                                                                                    
  <file>/user/root/hbase/hbase-common.jar#hbase-common.jar</file>                                                                                    
  <file>/user/root/hbase/hbase-protocol.jar#hbase-protocol.jar</file>                                                                                
  <file>/user/root/hbase/htrace-core-3.1.0-incubating.jar#htrace-core-3.1.0-incubating.jar</file>                                                    
  <file>/user/root/hbase/hbase-server.jar#hbase-server.jar</file>                                                                                    
  <file>/user/root/hbase/hbase-hadoop-compat.jar#hbase-hadoop-compat.jar</file>                                                                      
  <file>/user/root/hbase/high-scale-lib-1.1.1.jar#high-scale-lib-1.1.1.jar</file>                                                                    
        </sqoop>                                                                                                                                     
        <ok to="end"/>                                                                                                                               
        <error to="fail"/>                                                                                                                           
    </action>                                                                                                                                        
    <kill name="fail">                                                                                                                               
        <message>Sqoop failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>                                                       
    </kill>                                                                                                                                          
    <end name="end"/>                                                                                                                                
</workflow-app> 
1 ACCEPTED SOLUTION

avatar
Rising Star

i resolved this by adding hbase/lib metrics-core-2.2.0.jar to /user/root/hbase/ and definer in <file>metrics-core-2.2.0.jar#metrics-core-2.2.0.jar</file>

View solution in original post

2 REPLIES 2

avatar
Master Guru
@omkar pathallapalli

Can you please click on magnifier icon at the end of your console url (middle window in your screenshot), that will take you to resource manager UI --> Then click on Mapper --> logs --> check stderr logs

This looks like classnotfound exception.

avatar
Rising Star

i resolved this by adding hbase/lib metrics-core-2.2.0.jar to /user/root/hbase/ and definer in <file>metrics-core-2.2.0.jar#metrics-core-2.2.0.jar</file>