Query processor could not produce a query plan

question
5

Hi Joshua

Sorry for the late reply - I did eventually get back to this.

I also manage the HangFire schema manually so that I can control the db permissions.

I worked my way through the Install.sql script and your instinct was correct - This key was missing from my database:

CREATE NONCLUSTERED INDEX [IX_HangFire_Job_StateName] ON [HangFire].[Job] ([StateName] ASC);

That fixed the issue.

Thanks for your help!

  • Nils
1 Like