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

HDP 2.5 : Oozie issue

Solved Go to solution

HDP 2.5 : Oozie issue

New Contributor

I have installed HDP 2.5 components using Ambari. All the services started and working fine without any issue except Oozie.

Got the below error,

ERROR XBM0A: The database directory '/data/hadoop/oozie/data/oozie-db' exists. However, it does not contain the expected 'service.properties' file. Perhaps Derby was brought down in the middle of creating this database. You may want to delete this directory and try creating the database again. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.services.monitor.StorageFactoryService.vetService(Unknown Source) at org.apache.derby.impl.services.monitor.StorageFactoryService.access$900(Unknown Source) at org.apache.derby.impl.services.monitor.StorageFactoryService$10.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at org.apache.derby.impl.services.monitor.StorageFactoryService.createServiceRoot(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.bootService(Unknown Source) at org.apache.derby.impl.services.monitor.BaseMonitor.createPersistentService(Unknown Source) at org.apache.derby.iapi.services.monitor.Monitor.createPersistentService(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) at org.apache.derby.jdbc.Driver20.connect(Unknown Source) at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at org.apache.oozie.tools.OozieDBCLI.createConnection(OozieDBCLI.java:953) at org.apache.oozie.tools.OozieDBCLI.validateConnection(OozieDBCLI.java:959) at org.apache.oozie.tools.OozieDBCLI.createDB(OozieDBCLI.java:189) at org.apache.oozie.tools.OozieDBCLI.run(OozieDBCLI.java:128) at org.apache.oozie.tools.OozieDBCLI.main(OozieDBCLI.java:79)

1 ACCEPTED SOLUTION

Accepted Solutions

Re: HDP 2.5 : Oozie issue

Expert Contributor

Backup the directory "/data/hadoop/oozie/data/oozie-db" to another directory and then remove it using the command:

rm -rf /data/hadoop/oozie/data/oozie-db

Then restart oozie from Ambari and try again

3 REPLIES 3

Re: HDP 2.5 : Oozie issue

Super Mentor

@Uvaraj Seerangan

By any chance did you try deleting the directory '/data/hadoop/oozie/data/oozie-db' and then tried starting it again?

Better to try moving '/data/hadoop/oozie/data/oozie-db' to some other directory and then try starting it,

Re: HDP 2.5 : Oozie issue

Expert Contributor

Backup the directory "/data/hadoop/oozie/data/oozie-db" to another directory and then remove it using the command:

rm -rf /data/hadoop/oozie/data/oozie-db

Then restart oozie from Ambari and try again

Highlighted

Re: HDP 2.5 : Oozie issue

Super Guru

@Uvaraj Seerangan - Please check answers given below and accept an appropriate answer once your issue is resolved.

Don't have an account?
Coming from Hortonworks? Activate your account here