Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

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>