ZenoxCRMJobs.SendWhatsappLogsAsync

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

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

Parameters

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

State

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

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

Enqueue at:
10/25/2026 9:21:38 PM

+8ms 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)

+7ms Processing

Server:
ns5022610:33776
Worker:
18bbd9e0

+27m 12.284s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
10/25/2026 8:44:21 PM

+4ms 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)

+3ms Processing

Server:
ns5022610:48712
Worker:
157c1983

+5m 15.691s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
10/25/2026 8:31:03 PM

+4ms 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:
4540a23a

+2m 30.294s Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

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

Enqueue at:
10/25/2026 8:25:59 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)

+3ms Processing

Server:
ns5022610:48712
Worker:
d6e500d7

+1m 30.189s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

Enqueue at:
10/25/2026 8:23:26 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.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

+3ms Processing

Server:
ns5022610:48712
Worker:
157c1983

+30.017s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

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

+4ms 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)

+3ms Processing

Server:
ns5022610:48712
Worker:
05fc8d22

+30.086s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

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

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

+4ms 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)

+3ms Processing

Server:
ns5022610:48712
Worker:
2f156047

+1ms Enqueued

Triggered by recurring job scheduler

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