Getting SQL Server error while using Hangfire

asp.net-mvc-5 hangfire
Dreamer picture Dreamer · Dec 16, 2016 · Viewed 7.7k times · Source

I am using Hangfire in an ASP.NET MVC5 application to send an email. Until now, it was working fine, but now when I run the application, it is throwing this error:

There is already an object named 'Job' in the database.nstalling Hangfire SQL objects... Database schema [HangFire] already exists Table [HangFire].[Schema] already exists.. Installing schema version 1

From this error, I understood that Hangfire trying to create all those tables in the database which are already there. But I'm not getting reason behind it because till now application was working fine, even when I run it locally many times.

Answer

tripurary picture tripurary · Dec 6, 2018

This happened to me and I run this query and restart the server. Just run the query: 

INSERT INTO [HangFire].[Schema]
           ([Version])
     VALUES
           (5)

Related questions

How to prevent a Hangfire recurring job from restarting after 30 minutes of continuous execution

I am working on an asp.net mvc-5 web application, and I am facing a problem in using Hangfire tool to run long running background jobs. the problem is that if the job execution exceed 30 minutes, then hangfire will automatically …

Read More
HangFire recurring task data

I am coding a MVC 5 internet application and am using HangFire for recurring tasks. If I have a Monthly recurring task, how can I get the value of the next execution time? Here is my code for the recurring task: …

Read More
HTTP Error 500.19 and error code : 0x80070021

I have a simple webAPI build by Visual Studio 2013. It works well when I run it from VS13 but when I copy the project in local IIS it gives me the following error. HTTP Error 500.19 - Internal Server Error The …

Read More