Enable Sentry In BDA 4.5 or Higher Failed With Error "Failed to create Sentry database tables" (Doc ID 2211418.1)

Last updated on JANUARY 06, 2017

Applies to:

Big Data Appliance Integrated Software - Version 4.5.0 and later
Information in this document applies to any platform.

Symptoms

Try to enable sentry on BDA 4.5 using doc "How to Add or Remove Sentry on Oracle Big Data Appliance v4.2 or Higher with bdacli (Doc ID 2052733.1)” it failed with the following error:

ERROR: Puppet agent run on node bdaxxxn01 had errors. List of errors follows
INFO: Also check the log file in /opt/oracle/BDAMammoth/bdaconfig/tmp/pagent-bdaxxxn01-20161129092432.log

From pagent-bdaxxxn01-20161129092432.log:

Nov 29 09:24:42 bdaxxxn01 puppet-master[14095]: Compiled catalog for bdaxxxn01.example.com in environment production in 0.67 seconds
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/File[enable_sentry]/ensure) created
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql_53]/File[sentry_sql_53]/content) content changed '{md5}0ce441e54fd02634c9995b873242aee4' to '{md5}f63f1e1e052835e4eef518f6107a6a9f'
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql_53]/Exec[sentry_sql_53]/returns) executed successfully
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql_52]/File[sentry_sql_52]/content) content changed '{md5}59ce96797742cda07d91a28a18259a96' to '{md5}4759c3cb66506824407f5cc37252a79e'
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql_52]/Exec[sentry_sql_52]/returns) executed successfully
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/Mysqldb[sentry]/Exec[create-sentry-db]/returns) executed successfully
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/Mysqldb[sentry]/Exec[create-sentry-db-user]/returns) executed successfully
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql]/File[sentry_sql]/content) content changed '{md5}216d01a03337f7bad1e18b75ebc17f50' to '{md5}cab35ab5b4785905abc72f3411d62d60'
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/File_with_backup[sentry_sql]/Exec[sentry_sql]/returns) executed successfully
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com/Puppet) /opt/oracle/BDAMammoth/bdaconfig/tmp/enablesentry.sh &> /opt/oracle/BDAMammoth/bdaconfig/tmp/enablesentry_1480432306.out returned 1 instead of one of [0]
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com//Stage[main]/Hadoop::Enablesentry/Exec[enable_sentry]/returns) change from notrun to 0 failed: /opt/oracle/BDAMammoth/bdaconfig/tmp/enablesentry.sh &> /opt/oracle/BDAMammoth/bdaconfig/tmp/enablesentry_1480432306.out returned 1 instead of one of [0]
Nov 29 09:26:36 bdaxxxn01 puppet-master[14095]: (//bdaxxxn01.example.com/Puppet) Finished catalog run in 114.25 seconds

From enablesentry_1480432306.out:

Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/cm_commands.out
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_bdaxxx_services_1480433084.out
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_bdaxxx_services_sentry_roles_1480433084.out
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_bdaxxx_services_sentry_config_1480433084.out
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/cm_commands_generateCredentials.out
Command ID is 7707

Command 7707 finished after 5 seconds
Operation completed successfully
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_bdaxxx_services_sentry_commands_sentryCreateDatabaseTables.out
Command ID is 7709
..
Command 7709 finished after 15 seconds
Operation failed
Result Message is: "Failed to create Sentry database tables.",
API Version used is v12
Succeeded. Output in : /opt/oracle/BDAMammoth/bdaconfig/tmp/clusters_bdaxxx_services_sentry_commands_restart.out
Command ID is 7712
.....
Command 7712 finished after 30 seconds
Operation failed
Result Message is: "Failed to restart service.",



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms