@saravanan gopalsamy
As mentioned earlier that you can
delete services from ambari UI from Ambari 2.4.x version else you will
have to use the Rest API as mentioned in the above link.
In Ambari 2.2.1 that feature is not available in ambari UI. So you will need to either use the Ambari API or more simplest way is to delete the service directly from the Database as mentioned in the following article.
.
(Easiest and quick option) Deleting Service entry directly from Database using the following query:
delete from hostcomponentstate where service_name = 'KNOX';
delete from hostcomponentdesiredstate where service_name = 'KNOX';
delete from servicecomponentdesiredstate where service_name = 'KNOX';
delete from servicedesiredstate where service_name = 'KNOX';
delete from serviceconfighosts where service_config_id in (select service_config_id from serviceconfig where service_name = 'KNOX');
delete from serviceconfigmapping where service_config_id in (select service_config_id from serviceconfig where service_name = 'KNOX');
delete from serviceconfig where service_name = 'KNOX';
delete from requestresourcefilter where service_name = 'KNOX';
delete from requestoperationlevel where service_name = 'KNOX';
delete from clusterservices where service_name ='KNOX';
delete from clusterconfig where type_name like 'knox%';
delete from clusterconfigmapping where type_name like 'knox%';
.
Please see: https://community.hortonworks.com/content/kbentry/81939/how-to-resolve-ambari-db-inconsistency-error...
Then you will need to restart Ambari Server.
