Service ID 'xxxxx' no longer exists
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Problem
In the scheduler administration page, there is a lot of errors icon appearing under com.atlassian.jira.service.DefaultServiceManager group.
After expand we will see this:
1
2
3
4
5
6
7
8
9
com.atlassian.jira.service.JiraService:10200
Type: Runnable
Parameters: {com.atlassian.jira.service.ServiceManager:serviceId=10200}
Run mode: once per cluster
Schedule: 1 hour
Last Run: Thu Jul 30 17:44:45 MYT 2015
Last run duration: 5 milliseconds
Next Run: Thu Jul 30 18:44:45 MYT 2015
Message: Service ID '10200' no longer exists!Diagnosis
Check on the service id by running the SQL command below via database:
1
2
3
4
5
6
select * from jquartz_simple_triggers where trigger_name like '%<Service_ID>%';
select * from jquartz_triggers where trigger_name like '%<Service_ID>%';
select * from jquartz_cron_triggers where trigger_name like '%<Service_ID>%';
select * from clusteredjob where job_id like '%<Service_ID>%';If one of the table above doesn't return the service data, that means the service no longer exist in JIRA.
Cause
The service ID is missing or no longer exist in JIRA database.
Solution
Workaround
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Backup JIRA
Run the SQL command below to remove the service ID data:
1 2 3 4 5 6 7delete from jquartz_simple_triggers where trigger_name like '%<Service_ID>%'; delete from jquartz_triggers where trigger_name like '%<Service_ID>%'; delete from jquartz_cron_triggers where trigger_name like '%<Service_ID>%'; delete from clusteredjob where job_id like '%<Service_ID>%';Restart JIRA.
Was this helpful?