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 Ooziedb.sh. I ran it first as "ooziedb.sh create -run" and later again as "sudo -u oozie ooziedb.sh 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?