Skip to main content
HanzalaShaikh
Gold ⭐️
January 21, 2022
Solved

Oozie workflow failed for sqoop import job

Hi Experts,

 

One of our oozie workflow got failed while sqoop import job.

 

Please find below logs:

 

org.apache.velocity.exception.VelocityException: Error initializing log: Failed to initialize an instance of org.apache.velocity.runtime.log.Log4JLogChute with the current runtime configuration.

 

in other logs as :

 

org.springframework.web.client.HttpServerErrorException: 500 null

 

Please tell what could be the possible cause of this failure, we retried this job but getting the same error.

HanzalaShaikh
Gold ⭐️
March 20, 2022

Yes before I tried runing sqoop import manually, I restarted the oozie sqoop service multiple times until I can see the oozie workflow was initialized in the logs. 

 

The workflows started working as expected and the job completed. 

2 replies

ChethanYM
Gold ⭐️
Gold ⭐️
January 25, 2022

Hi, 

Please try to rerun the sqoop import outside of oozie and confirm whether its working or not. If it is working then we need to check it from oozie side. We need a complete stacktrcae of the error.

 

Regards,

Chethan YM

Translate
HanzalaShaikh
HanzalaShaikhAuthorAnswer
Gold ⭐️
March 20, 2022

Yes before I tried runing sqoop import manually, I restarted the oozie sqoop service multiple times until I can see the oozie workflow was initialized in the logs. 

 

The workflows started working as expected and the job completed. 

Translate