Ranger delete process and Hive errors

[#1]

Error:

2016-02-11 08:57:07,482 ERROR [Thread-9]: client.RangerAdminRESTClient (RangerAdminRESTClient.java:getServicePoliciesIfUpdated(81)) - Error getting policies. request=http://phdns01.cloud.hortonworks.com:6080/service/plugins/policies/download/HDPTEST_hive?lastKnownVe..., response={"httpStatusCode":400,"statusCode":1,"msgDesc":"Serivce:HDPTEST_hive not found","messageList":[{"name":"DATA_NOT_FOUND","rbKey":"xa.error.data_not_found","message":"Data not found"}]}, serviceName=HDPTEST_hive

Issue:

Ranger was deleted and delete process ended up causing issues at the database level as shown above.

Delete was done using the following command

curl --user admin:admin -i -H "X-Requested-By: ambari" -X DELETE http://`hostname -f`:8080/api/v1/clusters/CLUSTERNAME/services/RANGER

Now, No Hive repo showed up in Ranger console after adding Ranger and enabling Hive plugin.

Fix:

As you can seen in the error "HDPTEST_hive" Data Not Found.

Disclaimer: Unofficial solution

[#2]

1] Did the DB also get cleaned up? Otherwise, I don't see why repo is not there.

2] If ranger service is deleted, plugin should have been disabled also, so that it does not try to communicate to ranger.

3] After ranger is added again, if using the same DB, repo should be there. If using diff. DB, it should get created when hive plugin is enabled again and hive is restarted

[#3]

@vperiasamy I did not cleanup the db manually.

2) Good point.

3) I did use the same DB