ZenoxCRMJobs.SendWhatsappLogsAsync

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

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

Parameters

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

State

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

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

Enqueue at:
10/25/2026 9:20:27 PM

+17ms 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.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+43ms Processing

Server:
ns5022610:33776
Worker:
d0dac070

+30m 12.442s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
10/25/2026 8:41:39 PM

+7ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:48712)

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)

+4ms Processing

Server:
ns5022610:48712
Worker:
92f29069

+4m 45.600s Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

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

Enqueue at:
10/25/2026 8:28:12 PM

+6ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:48712)

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:48712
Worker:
219347cb

+3m 324ms Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

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

Enqueue at:
10/25/2026 8:23:23 PM

+7ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:48712)

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:48712
Worker:
157c1983

+1m 30.240s Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

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

Enqueue at:
10/25/2026 8:20:26 PM

+25ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:48712)

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)

+15ms Processing

Server:
ns5022610:48712
Worker:
d6e500d7

+30.039s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
10/25/2026 8:18:49 PM

+5ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:48712)

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:48712
Worker:
d91850d4

+30.005s Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

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

Enqueue at:
10/25/2026 8:18:30 PM

+9ms Failed

An exception occurred during performance of the job.

Npgsql.PostgresException (ns5022610:48712)

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)

+8ms Processing

Server:
ns5022610:48712
Worker:
219347cb

+1ms Enqueued

Triggered by recurring job scheduler

10/25/2026 8:18:01 PM Created