The sqoop commands from command line and the ones that will work to completion in oozie are going to be slightly different. This difference is based on container enviroment, paths, and permissions.
The only way to trouble shoot is to go into YARN UI, and click deep into the log for the containers and the application failure(s). You are specifically looking for the logs of the failed container. Be careful as there are several higher level of logs that are not always going to show the errors. You will most likely be looking in every possible place.
For my oozie / sqoop job the click through path is:
1. From workflow tab, click into the job.
2. Inspect the log tabs here.
3. Follow link to the Job into the Yarn Resource UI.
2. Next find the container that executed the job(s) and click on the link to those Logs. This can be 1 or 2 pages to click through so be sure to inspect all links into sub pages.
3. Inspect the log output at the deepest levels for additional information and usually the error you need to solve.
Once you have the actual failures, it is usually descriptive enough to direct some adjustment in the workflow. Retry the application and repeat until resolved.
Good luck, and if this answer helps, please choose ACCEPT.