Hi Support, i am trying to delete a service but received error "Could not find a unique ID for this service".
I have tried searching in CCM as well as /usr/local/nagios/etc/services for the particular service but not able to locate any. I have also tried performing database repair and did not get any errors.
I am running nagiosxi 5.4.
Can you advise how can i resolve this issue?
Could not find a unique ID for this service
-
nfv_nagios
- Posts: 35
- Joined: Sun Jan 08, 2017 8:00 pm
Could not find a unique ID for this service
You do not have the required permissions to view the files attached to this post.
Re: Could not find a unique ID for this service
This error can happen if there are multiple records in the database that have the same service name and host. Run the following command and post the output to help me diagnose:
Code: Select all
mysql -h localhost -unagiosql -pn@gweb nagiosql <<< "select count(*) as ct, tbl_host.host_name, tbl_service.service_description from tbl_host inner join tbl_service on (tbl_host.id = tbl_service.host_name) group by tbl_host.host_name, tbl_service.service_description order by ct desc, host_name, service_description;"If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
-
nfv_nagios
- Posts: 35
- Joined: Sun Jan 08, 2017 8:00 pm
Re: Could not find a unique ID for this service
Hi Support, please see attached file for the output.
The problematic service that i was trying to delete is "Actual Memory usage"
ct host_name service_description
20 localhost Actual Memory usage
The problematic service that i was trying to delete is "Actual Memory usage"
ct host_name service_description
20 localhost Actual Memory usage
You do not have the required permissions to view the files attached to this post.
Re: Could not find a unique ID for this service
If you PM me a system profile I can diagnose further. Get one by going to Admin (top menu) => System Profile (in the left menu), then clicking the blue button.
If you're unable to generate the the profile through the web interface, please try generating it from the command line by running these commands as root:
Then send me the resulting /usr/local/nagiosxi/var/components/profile.zip file.
If the profile script fails, please include the ENTIRE output.
If you're unable to generate the the profile through the web interface, please try generating it from the command line by running these commands as root:
Code: Select all
rm -rf /usr/local/nagiosxi/var/components/profile*
/usr/local/nagiosxi/scripts/components/getprofile.sh SUPPORTIf the profile script fails, please include the ENTIRE output.
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
-
nfv_nagios
- Posts: 35
- Joined: Sun Jan 08, 2017 8:00 pm
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: Could not find a unique ID for this service
Hi @nfv_nagios,
Assisting with this post as Dan is out today. Sorry about the inconvenience, but can you send the PM once more to my account?
Thanks,
Benjamin
Assisting with this post as Dan is out today. Sorry about the inconvenience, but can you send the PM once more to my account?
Thanks,
Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!
-
nfv_nagios
- Posts: 35
- Joined: Sun Jan 08, 2017 8:00 pm
Re: Could not find a unique ID for this service
Hi, can you run the following command on your Nagios XI machine:
Code: Select all
mysql -h localhost -unagiosql -pn@gweb nagiosql <<< "select count(*) as ct, tbl_service.config_name, tbl_service.service_description from tbl_host inner join tbl_service on (tbl_host.id = tbl_service.host_name) group by tbl_host.host_name, tbl_service.service_description order by ct desc, tbl_service.config_name, service_description;"If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
-
nfv_nagios
- Posts: 35
- Joined: Sun Jan 08, 2017 8:00 pm
Re: Could not find a unique ID for this service
Have PM you the requested info.
Re: Could not find a unique ID for this service
I'm able to see the "Actual Memory Usage" service you're referring to in the CCM under Services.
You will want to make sure the "Config Name" field is empty when you're on the list -- the field value is "sticky."
You will want to make sure the "Config Name" field is empty when you're on the list -- the field value is "sticky."
If you didn't get an 8% raise over the course of the pandemic, you took a pay cut.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.
Discussion of wages is protected speech under the National Labor Relations Act, and no employer can tell you you can't disclose your pay with your fellow employees.