// Id: #814
using ZenoxCRM.Hangfire.Jobs;
var zenoxCRMJobs = Activate<ZenoxCRMJobs>();
await zenoxCRMJobs.SendZenoxCRMWhatsappLogsAsync(null);
| RecurringJobId | |
| Time | |
| CurrentCulture | |
| RetryCount | |
Retry attempt 7 of 10: 42883: function fn_claim_zenoxcrm_whatsapplog(int…
An exception occurred during performance of the job.
42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077
Npgsql.PostgresException (0x80004005): 42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077 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.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 184 at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 186 at ZenoxCRM.Hangfire.Services.ZenoxCRMWhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\ZenoxCRMWhatsappClaimService.cs:line 43 at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendZenoxCRMWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 89 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_zenoxcrm_whatsapplog(int…
An exception occurred during performance of the job.
42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077
Npgsql.PostgresException (0x80004005): 42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077 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.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 184 at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 186 at ZenoxCRM.Hangfire.Services.ZenoxCRMWhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\ZenoxCRMWhatsappClaimService.cs:line 43 at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendZenoxCRMWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 89 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_zenoxcrm_whatsapplog(int…
An exception occurred during performance of the job.
42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077
Npgsql.PostgresException (0x80004005): 42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077 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.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 184 at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 186 at ZenoxCRM.Hangfire.Services.ZenoxCRMWhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\ZenoxCRMWhatsappClaimService.cs:line 43 at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendZenoxCRMWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 89 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_zenoxcrm_whatsapplog(int…
An exception occurred during performance of the job.
42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077
Npgsql.PostgresException (0x80004005): 42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077 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.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 184 at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 186 at ZenoxCRM.Hangfire.Services.ZenoxCRMWhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\ZenoxCRMWhatsappClaimService.cs:line 43 at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendZenoxCRMWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 89 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_zenoxcrm_whatsapplog(int…
An exception occurred during performance of the job.
42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077
Npgsql.PostgresException (0x80004005): 42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077 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.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 184 at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 186 at ZenoxCRM.Hangfire.Services.ZenoxCRMWhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\ZenoxCRMWhatsappClaimService.cs:line 43 at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendZenoxCRMWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 89 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_zenoxcrm_whatsapplog(int…
An exception occurred during performance of the job.
42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077
Npgsql.PostgresException (0x80004005): 42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077 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.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 184 at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 186 at ZenoxCRM.Hangfire.Services.ZenoxCRMWhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\ZenoxCRMWhatsappClaimService.cs:line 43 at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendZenoxCRMWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 89 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_zenoxcrm_whatsapplog(int…
An exception occurred during performance of the job.
42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077
Npgsql.PostgresException (0x80004005): 42883: function fn_claim_zenoxcrm_whatsapplog(integer, text) does not exist POSITION: 1077 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.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 184 at ZenoxCRM.Hangfire.Data.PgClaimDb.ClaimZenoxCRMWhatsappLogAsync(Int32 batchSize, String worker, CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Data\PgClaimDb.cs:line 186 at ZenoxCRM.Hangfire.Services.ZenoxCRMWhatsappClaimService.ClaimAndEnqueueAsync(CancellationToken cancellationToken) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Services\ZenoxCRMWhatsappClaimService.cs:line 43 at ZenoxCRM.Hangfire.Jobs.ZenoxCRMJobs.SendZenoxCRMWhatsappLogsAsync(IJobCancellationToken token) in D:\Projects\WebProjects\ZenoxCRM\ZenoxCRM.Hangfire\Jobs\ZenoxCRMJobs.cs:line 89 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by recurring job scheduler