Questions tagged [hangfire-sql]

63 questions
1
vote
0 answers

HangFire on .NET framework 4.6 doesn't work with SQL Server 2017 instance

I tried to use HangFire with SQL Server 2017 but it doesn't work. The error encountered is Hangfire.BackgroundJobClientException: 'background job creation failed' The same setting works with SQL Server 2016. Even with the compatibility Level…
MNF
  • 687
  • 9
  • 13
1
vote
1 answer

Hangfire dashboard: SqlException: Invalid column name 'Key'

I have Hangfire installed on my web server. And it works. And i was able to access hangfire dashboard. But suddenly today i tried to open dashboard and when trying to access http://localhost/hangfire i get the following error: An unhandled…
1
vote
0 answers

Hangfire MSMQ processed in server 1 but stuck in server 2

I'm using Hangfire with MSMQ. Here is the setup 2 Front-end Servers (for IIS), I will call them web1 and web2 A 3rd server for Hangfire Windows Service (I'll call it app1) A load balancer between them. Problem When I tried to access Hangfire…
bunjeeb
  • 1,096
  • 1
  • 17
  • 32
0
votes
0 answers

Hangfire Recurring job can't be scheduled

Hi I am getting below issue in my Hangfire recurring job after each 10 or 15 mins and every time I have to trigger my job manually and again it starts working for some time and then again getting the same issue. What could be the cause of this…
0
votes
0 answers

hangfire in worker error some time after so (1 or 2 worker working)

Hangfire in worker count error there are 700 job in Enqueue and 36 worker counts available and 36 process are processing than add more job 500 in another Queues than worker are than working properly 1 to 2 hour than worker are not free they only…
0
votes
0 answers

Mixed datetime formats at [HangFire].[State], Data column

I recently joined a project that is using hangfire 1.6.20. We are having some problems with our code, and I decided to enable hangfire dashboards to help me check what is gong on. I am getting some exceptions if I move to the 2nd page of the…
user1845593
  • 1,736
  • 3
  • 20
  • 37
0
votes
0 answers

log all SQL queries that Hangfire sends to database

I am currently using Hangfire 1.8.4 in my project, with SQL Server as job storage (using Hangfire.SqlServer 1.8.4). I am trying to find a way to log all SQL queries that Hangfire sends to my SQL Server database for execution.
Kinin Roza
  • 1,908
  • 1
  • 7
  • 17
0
votes
1 answer

Execution of old Hang Fire jobs even after deleting the database

I ran into a strange problem. I used Hang Fire in a software under Blazor Server and .NET Core that I had no problem with, and now I have come across this problem that when I request to create any job, I see a bunch of jobs that I don't know where…
0
votes
0 answers

What is the benefit of upgrading the Hangfire database schema?

I am in the process of upgrading the framework from an older .net framework to .net 6. In this process I also upgraded some of the 3rd party libraries including Hangfire. Looking at the documentation it says that the current 1.8 version of Hangfire…
Serj Sagan
  • 28,927
  • 17
  • 154
  • 183
0
votes
0 answers

What kind of problems can be caused by referencing both Microsoft.Data.SqlClient and System.Data.SqlClient

I was reading the answer to this question about the Microsoft.Data.SqlClient and System.Data.SqlClient which states that "Mixing up data providers isn't fun and should be avoided when possible." I'd like to know what kind of problems could be caused…
0
votes
1 answer

Hangfire - Two server instances are created - only one heartbeat

I'm using Hangfire and for some reason, two server instances are created during startup. During startup I use services.AddHangfire((provider, hangfireConfig) => hangfireConfig .UseDatabase(storageSettings.StorageProvider,…
amr-it
  • 21
  • 4
0
votes
0 answers

Hangfire - Schedule job fires unexpectedly

I have set up 5 jobs to run at 4pm/5pm/6pm/7pm/8pm daily. This jobs emails reports those times. This morning, I had 5 emails at 630am as you can see by the screen shot Does anyone know why all these jobs ran at the same time. Is there a better…
H20rider
  • 2,162
  • 5
  • 29
  • 47
0
votes
1 answer

Hangfire - Win32Exception (258): The wait operation timed out

I sometimes get the following exception, when a job gets executed: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. --->…
roli09
  • 817
  • 1
  • 8
  • 20
0
votes
0 answers

Error - There is no explicit mapping for the categories 'Hangfire.Server.ServerJobCancellationWatcher'

My project required to update the versions of Hangfire.core and Hangfire.SqlServer from 1.6.7 to 1.7.31 . After updating these dlls, I am finding build issues in the below method- "Cannot convert from Microsoft.Practices.Unity.IUnityContainer to…
Tannya
  • 161
  • 6
  • 21
0
votes
0 answers

HangFire takes different class than the one the method present in for Recurring Jobs

We are using HangFire for one of our applications to schedule Reports. CreateJobsOpenBidListReportHandler is class which is being inherited from AbstractCreateReportHandler class. public class CreateJobsOpenBidListReportHandler :…
RashmiMs
  • 129
  • 14