Droou Notification Jobs

PolicyRenewalJob.SendRenewalRemindersAsync

// Id: #350
using DroouNotification.Jobs;

var policyRenewalJob = Activate<PolicyRenewalJob>();
await policyRenewalJob.SendRenewalRemindersAsync();

Parameters

CurrentCulture 
""
RecurringJobId 
"policy-renewal-job"
RetryCount 
10
Time 
1791342007

State

10/07/2026 07:29:15 (+1.453s) Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+250ms Processing

Server:
d85dee724f4d:1
Worker:
8c5d86d0

+1h 49m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 10 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 07:29:03

+1.073s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+7ms Processing

Server:
d85dee724f4d:1
Worker:
915f4c9c

+1h 9m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 9 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 05:39:11

+1.130s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+7ms Processing

Server:
d85dee724f4d:1
Worker:
54ba5cfd

+40m 44.397s Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

Retry attempt 8 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 04:29:42

+1.323s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+10ms Processing

Server:
d85dee724f4d:1
Worker:
133b6371

+23m 28.767s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 7 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 03:48:55

+1.603s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+10ms Processing

Server:
d85dee724f4d:1
Worker:
4a9bff06

+11m 58.850s Enqueued

Triggered by DelayedJobScheduler

+4ms Scheduled

Retry attempt 6 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 03:25:37

+1.343s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+7ms Processing

Server:
d85dee724f4d:1
Worker:
c8b1eb91

+6m 43.796s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 5 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 03:13:30

+1.324s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+6ms Processing

Server:
d85dee724f4d:1
Worker:
d91a58ee

+3m 28.954s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 4 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 03:06:52

+1.103s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+7ms Processing

Server:
d85dee724f4d:1
Worker:
1693a34d

+1m 29.013s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 3 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 03:03:22

+1.010s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+10ms Processing

Server:
d85dee724f4d:1
Worker:
8c5d86d0

+58.960s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 2 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 03:01:42

+1.057s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+10ms Processing

Server:
d85dee724f4d:1
Worker:
915f4c9c

+44.033s Enqueued

Triggered by DelayedJobScheduler

+7ms Scheduled

Retry attempt 1 of 10: Conversion failed when converting the varchar val…

Enqueue at:
10/07/2026 03:00:45

+1.600s Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (d85dee724f4d:1)

Conversion failed when converting the varchar value 'NR' to data type int.

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'NR' to data type int.
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at Microsoft.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at Microsoft.Data.SqlClient.SqlDataReader.ReadAsyncExecute(Task task, Object state)
   at Microsoft.Data.SqlClient.SqlDataReader.InvokeAsyncCall[T](SqlDataReaderBaseAsyncCallContext`1 context)
--- End of stack trace from previous location ---
   at Microsoft.EntityFrameworkCore.Query.Internal.FromSqlQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1 source, CancellationToken cancellationToken)
   at DroouNotification.Services.RenewalReminderService.GetPoliciesAsync(Int64 userId, DateTime date)
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45)
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync()
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync()
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+203ms Processing

Server:
d85dee724f4d:1
Worker:
4c3ef679

+3ms Enqueued

Triggered by recurring job scheduler

10/07/2026 03:00:07 Created