question Oozie workflow failed for sqoop import job in Support Questions

Oozie workflow failed for sqoop import job

HanzalaShaikh — Fri, 21 Jan 2022 17:09:02 GMT

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.

Re: Oozie workflow failed for sqoop import job

ChethanYM — Tue, 25 Jan 2022 12:08:19 GMT

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

Re: Oozie workflow failed for sqoop import job

HanzalaShaikh — Sun, 20 Mar 2022 10:00:29 GMT

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.