Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (1)

ISSUE: While upgrading HDP, Ranger service failed. Below was the error -

Failed to apply patch 020-datamask-policy.sql” with error “Not able to drop table ‘x_datamast_type_’def” Foreign constraints fails Error Code 1217

ERROR:

10878-pic3.png

ROOT CAUSE: Issue was with foreign_key_checks

RESOLUTION:

“SET foreign_key_checks = 0;” in mysql ranger DB and dropped the table manually and re-created and again “SET foreign_key_checks = 1;” 
270 Views
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
2 of 2
Last update:
‎08-17-2019 06:32 AM
Updated by:
 
Contributors
Top Kudoed Authors