// Id: #147
using ZenoxCRM.Hangfire.Jobs;
var zenoxCRMJobs = Activate<ZenoxCRMJobs>();
await zenoxCRMJobs.SendWhatsappLogsAsync(null);
| RecurringJobId | |
| Time | |
| CurrentCulture | |
| RetryCount | |
Retry attempt 8 of 10: 42883: function fn_claim_whatsapplog(integer, tex…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 7 of 10: 42883: function fn_claim_whatsapplog(integer, tex…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 6 of 10: 42883: function fn_claim_whatsapplog(integer, tex…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 5 of 10: 42883: function fn_claim_whatsapplog(integer, tex…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 4 of 10: 42883: function fn_claim_whatsapplog(integer, tex…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 3 of 10: 42883: function fn_claim_whatsapplog(integer, tex…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 2 of 10: 42883: function fn_claim_whatsapplog(integer, tex…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 1 of 10: 42883: function fn_claim_whatsapplog(integer, tex…
An exception occurred during performance of the job.
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)
Triggered by recurring job scheduler