Query processor hint errors

Using 1.5.3 I’ve been seeing a number of errors which prevent me from loading the hangfire dashboard at times.

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.

This is appearing when I try and load hangfire/jobs/scheduled endpoint.

I re-ran the install sql as per - https://github.com/HangfireIO/Hangfire/blob/master/src/Hangfire.SqlServer/Install.sql but I still get the error.

I think I’ve solved this. I completely dropped all my hangfire objects and re-create, it seems to be OK right now!