Question

Photo of Chris Rea

0

Issue with Rock Cleanup

I am running into an issue with my Rock Cleanup job.  It maxes out the DTU's on my DBaaS in Azure for about 40 seconds before running into the following exception

at System.Data.Entity.Core.EntityClient.EntityTransaction.Commit() at Rock.Jobs.RockCleanup.PurgeExceptionLog(JobDataMap dataMap) at Rock.Jobs.RockCleanup.Execute(IJobExecutionContext context)

Based on what I can tell, that's a connectivity issue with my DBaaS.  I do run my web server in a different location, but it worked fine until about 3 months ago.  I didn't notice until now.

Other than that I have experience no issue with the servers talking to each other.  I'm working on setting up a vpn tunnel right now.  Is there anything else I should try?

  • Photo of Kelley Langkamp

    0

    Try bumping up your Azure DB to the next level for a few minutes. Then manually run the clean up job. When it completes successfully, you can bump your DB back down to the service level it normally runs at. I had similar sounding issues earlier this week. Getting the job to run once seems to have taken care of it. My Azure is back down to the level that I normally run at and the job has run successfully the last 2 nights.