ZenoxCRMJobs.SendWhatsappLogsAsync

// Id: #1185
using ZenoxCRM.Hangfire.Jobs;

var zenoxCRMJobs = Activate<ZenoxCRMJobs>();
await zenoxCRMJobs.SendWhatsappLogsAsync(null);

Parameters

RecurringJobId
"crm-wa-claim"
Time
1792963082
CurrentCulture
"en-US"
RetryCount
7

State

10/25/2026 10:28:29 PM (+1ms) Scheduled

Retry attempt 7 of 10: 42883: function fn_claim_whatsapplog(integer, tex…

Enqueue at:
10/25/2026 10:52:19 PM

+7ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:47936)

42883: function fn_claim_whatsapplog(integer, text) does not exist POSITION: 1082

Npgsql.PostgresException (0x80004005): 42883: function fn_claim_whatsapplog(integer, text) does not exist

POSITION: 1082
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 434
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 62
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 64
   at ZenoxCRM.Hangfire.Services.WhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\WhatsappClaimService.cs:line 43
   at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 75
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+4ms Processing

Server:
ns5022610:47936
Worker:
017a77bb

+31m 47.111s Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

Retry attempt 6 of 10: 42883: function fn_claim_whatsapplog(integer, tex…

Enqueue at:
10/25/2026 10:08:22 PM

+7ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:53608)

42883: function fn_claim_whatsapplog(integer, text) does not exist POSITION: 1082

Npgsql.PostgresException (0x80004005): 42883: function fn_claim_whatsapplog(integer, text) does not exist

POSITION: 1082
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 434
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 62
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 64
   at ZenoxCRM.Hangfire.Services.WhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\WhatsappClaimService.cs:line 43
   at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 75
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+21ms Processing

Server:
ns5022610:53608
Worker:
d240f973

+6m 30.617s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 5 of 10: 42883: function fn_claim_whatsapplog(integer, tex…

Enqueue at:
10/25/2026 9:56:33 PM

+5ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:53608)

42883: function fn_claim_whatsapplog(integer, text) does not exist POSITION: 1082

Npgsql.PostgresException (0x80004005): 42883: function fn_claim_whatsapplog(integer, text) does not exist

POSITION: 1082
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 434
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 62
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 64
   at ZenoxCRM.Hangfire.Services.WhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\WhatsappClaimService.cs:line 43
   at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 75
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+3ms Processing

Server:
ns5022610:53608
Worker:
4d2f590e

+2m 15.237s Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

Retry attempt 4 of 10: 42883: function fn_claim_whatsapplog(integer, tex…

Enqueue at:
10/25/2026 9:50:12 PM

+11ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:53608)

42883: function fn_claim_whatsapplog(integer, text) does not exist POSITION: 1082

Npgsql.PostgresException (0x80004005): 42883: function fn_claim_whatsapplog(integer, text) does not exist

POSITION: 1082
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 434
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 62
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 64
   at ZenoxCRM.Hangfire.Services.WhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\WhatsappClaimService.cs:line 43
   at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 75
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+5ms Processing

Server:
ns5022610:53608
Worker:
4ef9c9d3

+45.041s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 3 of 10: 42883: function fn_claim_whatsapplog(integer, tex…

Enqueue at:
10/25/2026 9:47:45 PM

+11ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:53608)

42883: function fn_claim_whatsapplog(integer, text) does not exist POSITION: 1082

Npgsql.PostgresException (0x80004005): 42883: function fn_claim_whatsapplog(integer, text) does not exist

POSITION: 1082
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 434
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 62
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 64
   at ZenoxCRM.Hangfire.Services.WhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\WhatsappClaimService.cs:line 43
   at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 75
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+10ms Processing

Server:
ns5022610:53608
Worker:
f2bd9b37

+45.808s Enqueued

Triggered by DelayedJobScheduler

+3ms Scheduled

Retry attempt 2 of 10: 42883: function fn_claim_whatsapplog(integer, tex…

Enqueue at:
10/25/2026 9:46:57 PM

+65ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:53608)

42883: function fn_claim_whatsapplog(integer, text) does not exist POSITION: 1082

Npgsql.PostgresException (0x80004005): 42883: function fn_claim_whatsapplog(integer, text) does not exist

POSITION: 1082
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 434
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 62
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 64
   at ZenoxCRM.Hangfire.Services.WhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\WhatsappClaimService.cs:line 43
   at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 75
   at System.Reflection.MethodBaseInvoker.InterpretedInvoke_Method(Object obj, IntPtr* args)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+20ms Processing

Server:
ns5022610:53608
Worker:
d82f95e3

+28m 23.807s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 1 of 10: 42883: function fn_claim_whatsapplog(integer, tex…

Enqueue at:
10/25/2026 9:18:22 PM

+5ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:33776)

42883: function fn_claim_whatsapplog(integer, text) does not exist POSITION: 1082

Npgsql.PostgresException (0x80004005): 42883: function fn_claim_whatsapplog(integer, text) does not exist

POSITION: 1082
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteReader(Boolean async, CommandBehavior behavior, CancellationToken cancellationToken)
   at Npgsql.NpgsqlCommand.ExecuteDbDataReaderAsync(CommandBehavior behavior, CancellationToken cancellationToken)
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in /_/Dapper/SqlMapper.Async.cs:line 434
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 62
   at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 64
   at ZenoxCRM.Hangfire.Services.WhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\WhatsappClaimService.cs:line 43
   at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 75
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+10ms Processing

Server:
ns5022610:33776
Worker:
a2cb4ed2

+2ms Enqueued

Triggered by recurring job scheduler

10/25/2026 9:18:02 PM Created