Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Oozie schema SA does not exist

Oozie schema SA does not exist

New Contributor



I have installed CDH using Cloudera Manager. I have got the other components working, except Oozie. When I try to run Oozie, I get the "Schema SA does not exist". I am using Derby as the backend DB.


While searching online for any solutions, one of the suggestions was to run I ran it first as " create -run" and later again as "sudo -u oozie create -run", but I am still running into the same issues. Oozie server is trying to find a schema with the name same as Oozie server database user.  


Where can I start troubleshooting this error? 


Re: Oozie schema SA does not exist

Master Guru
You can attempt a DB creation via Cloudera Manager:

1. Stop Oozie from CM
2. Go to CM -> Oozie -> Actions, and select "Create Database"
3. Once done, start Oozie
Don't have an account?
Coming from Hortonworks? Activate your account here