HDP 2.5 : Oozie issue

mcas_uvaraj — Thu, 05 Jan 2017 22:06:20 GMT

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)

Re: HDP 2.5 : Oozie issue

jsensharma — Thu, 05 Jan 2017 22:09:01 GMT

@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

skurup — Thu, 05 Jan 2017 22:13:01 GMT

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

Re: HDP 2.5 : Oozie issue

KuldeepK — Fri, 06 Jan 2017 01:35:53 GMT

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

question HDP 2.5 : Oozie issue in Archives of Support Questions (Read Only)

HDP 2.5 : Oozie issue

Re: HDP 2.5 : Oozie issue

Re: HDP 2.5 : Oozie issue

Re: HDP 2.5 : Oozie issue