Droou Notification Jobs

PolicyRenewalJob.SendRenewalRemindersAsync

// Id: #118
using DroouNotification.Jobs;

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

Parameters

CurrentCulture 
"en-US"
RecurringJobId 
"policy-renewal-job"
RetryCount 
10
Time 
1780801209

State

06/07/2026 07:27:01 (+94ms) Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3ms Processing

Server:
insuranceoffice:14492
Worker:
6ce4420b

+1h 49m Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

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

Enqueue at:
06/07/2026 07:26:59

+80ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3ms Processing

Server:
insuranceoffice:14492
Worker:
76ef4a2e

+1h 10m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
06/07/2026 05:37:04

+90ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+ <1ms Processing

Server:
insuranceoffice:14492
Worker:
ec4721ee

+41m 46.097s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
06/07/2026 04:27:01

+96ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+ <1ms Processing

Server:
insuranceoffice:14492
Worker:
4fb829ca

+23m 45.587s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
06/07/2026 03:45:23

+87ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+ <1ms Processing

Server:
insuranceoffice:14492
Worker:
8c55bac9

+11m 253ms Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
06/07/2026 03:21:37

+87ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+ <1ms Processing

Server:
insuranceoffice:14492
Worker:
4ab1cdf6

+5m 30.013s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

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

+93ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+ <1ms Processing

Server:
insuranceoffice:14492
Worker:
6522d415

+1m 44.964s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
06/07/2026 03:05:08

+96ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+ <1ms Processing

Server:
insuranceoffice:14492
Worker:
69df9c50

+1m 59.934s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

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

+100ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+ <1ms Processing

Server:
insuranceoffice:14492
Worker:
8f54faeb

+44.893s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
06/07/2026 03:01:21

+127ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+6ms Processing

Server:
insuranceoffice:14492
Worker:
f63d5e36

+30.194s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
06/07/2026 03:00:32

+126ms Failed

An exception occurred during performance of the job.

Microsoft.Data.SqlClient.SqlException (insuranceoffice:14492)

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

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value 'aZHA1xaLLpA1QR8HDOY4PA==' to data type int.
   at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   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) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 118
   at DroouNotification.Services.RenewalReminderService.FetchPoliciesForDatesAsync(Int64 userId, DateTime d0, DateTime d3, DateTime d15, DateTime d30, DateTime d45) in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 107
   at DroouNotification.Services.RenewalReminderService.GetRenewalReminderAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Services\RenewalReminderService.cs:line 74
   at DroouNotification.Jobs.PolicyRenewalJob.SendRenewalRemindersAsync() in C:\Users\vivek\Documents\droou\src\droouAPIcore\DroouNotification\Jobs\PolicyRenewalJob.cs:line 32
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Void** arguments, Signature sig, Boolean isConstructor)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+4ms Processing

Server:
insuranceoffice:14492
Worker:
1b4c5856

+ <1ms Enqueued

Triggered by recurring job scheduler

06/07/2026 03:00:09 Created