Oozie workflow failed for sqoop import job

[#1]

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.

[#2]

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

[#3 · Accepted solution]

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.