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.

Failed to execute command Create Oozie Database Tables on service Oozie

Highlighted

Failed to execute command Create Oozie Database Tables on service Oozie

Explorer

Hi

can someone please help me on the below error.

Error:  Failed to execute command Create Oozie Database Tables on service Oozie

Create Oozie Database Tables
Process oozie-OOZIE-SERVER-createdbtables (id=408) on host cdldtcoevap0001.es.ad.adp.com (id=1) exited with 1 and expected 0

Error:

$> oozie/oozie.sh ["db-command","create"]

JAVA_HOME=/usr/java/jdk1.8.0_181-cloudera
using 6 as CDH_VERSION
CONF_DIR=/var/run/cloudera-scm-agent/process/408-oozie-OOZIE-SERVER-createdbtables
CMF_CONF_DIR=
Copying JDBC jar from /usr/share/java/mysql-connector-java.jar to /var/lib/oozie

Validate DB Connection
DONE
DB schema does not exist
Check OOZIE_SYS table does not exist
DONE
Create SQL schema

I have done the below steps.
1. I've dropped the database and user and then recreated. Executed the below command also.
MariaDB [(none)]> grant all on oozie.* TO 'oozie'@'host.company.com' IDENTIFIED BY 'secretpassword';
2. Server has enough RAM.
# free -m
total used free shared buffers cached
Mem: 128550 44334 84215 334 1 23256
-/+ buffers/cache: 21077 107473
Swap: 2054 0 2054

 

Thank you in advance!

 

Thanks,

Vijaya