How is timesheet plugin subscription job run without TIMESHEET_SUBSCRIPTION job?

We had a user subscribe to a timesheet report.  After user left, I removed his subsription via Admin --> Add-ons --> Timesheet Subscriptions.  I can see that the subscription row has been removed from the AO_E24DEA_TIMESHEET_JOB_CFG table.

However, the jira.timesheet.plugin.job.TimesheetJob job still runs via scheduler and fails daily with "Timesheet Job Configuration not found2" (2 being the ID of the subscription row that was removed).

Leaving aside the question of why the scheduler hasn't been cleaned up properly as part of removing the subscription, I am struggling to understand where this job is kicked off and where this parameter is passed.

It was mentioned on the Timesheet Bitbucket site that one would need to delete from qrtz_job_details where job_name = 'TIMESHEET_SUBSCRIPTION'.  However, that table does not have a TIMESHEET_SUBSCRIPTION job.  It only has 1 row for SEND_SUBSCRIPTION job, which I'm lead to believe is limited to filter subscriptions.

I cannot find anything off-hand in any scheduler tables that is kicking off this timesheet job or passing the ID that's been removed.

Could someone let me know how this is hanging together behind the schenes please so that we can clean it up manually and get rid of the error?

Thanks!

 

1 answer

This widget could not be displayed.

According to Atlassian, the Quartz scheduler is no longer used in JIRA 7.1 (although the corresponding tables are not dropped or even truncated as part of the upgrade).  The 'clusteredjob' table is used instead.  Cleaning that one out against timesheet and filtersubscription tables does the trick of failing jobs for non-existing entities disappearing from being scheduled.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

292 views 5 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you