SyncPaymentsToGP.ExecuteAsync

// Id: #6a95348eba1269dca122da01
using AG.ScheduledJobs.Payments;

var syncPaymentsToGP = Activate<SyncPaymentsToGP>();
await syncPaymentsToGP.ExecuteAsync(null);

Parameters

RecurringJobId
"Sync Payments To GP"
Time
1788163200
CurrentCulture
""
CurrentUICulture
""
RetryCount
10

State

08/31/2026 12:38:05 (+8.162s) Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+2.420s Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
93d97d0a

+1h 52m Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

Retry attempt 10 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 12:37:45

+7.664s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+1.805s Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
7ae1bd99

+1h 11m Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 9 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 10:45:28

+7.693s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+3.371s Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
2ce255ac

+42m 28.072s Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

Retry attempt 8 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 09:33:43

+7.621s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+701ms Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
7ae1bd99

+25m 14.881s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 7 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 08:51:18

+7.555s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+389ms Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
fd168964

+12m 16.510s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 6 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 08:25:44

+7.337s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+2.231s Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
fd168964

+5m 27.177s Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

Retry attempt 5 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 08:13:24

+1m 7.829s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetPaymentAsync failed: {"Success":false,"StatusCode":504,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":null,"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/ip/payments/694667","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetPaymentAsync failed: {"Success":false,"StatusCode":504,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":null,"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/ip/payments/694667","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+823ms Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
2ce255ac

+2m 53.435s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 4 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 08:06:45

+7.145s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+2.367s Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
fd168964

+1m 8.318s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 3 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 08:03:38

+7.142s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+1.063s Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
7ae1bd99

+1m 9.253s Enqueued

Triggered by DelayedJobScheduler

+1ms Scheduled

Retry attempt 2 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 08:02:22

+7.082s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+230ms Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
4949034f

+54.726s Enqueued

Triggered by DelayedJobScheduler

+ <1ms Scheduled

Retry attempt 1 of 10: One or more payments failed to sync to GP. (Incor…

Enqueue at:
08/31/2026 08:01:06

+7.881s Failed

An exception occurred during performance of the job.

System.AggregateException (cross-stitch-549567767c-g6vtl:1)

One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'. Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null})

System.AggregateException: One or more payments failed to sync to GP. (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) (GetCompanyAsync failed: {"Success":false,"StatusCode":404,"RateLimits":{"RequestsLeft":0,"RequestsQuota":0,"TimeResetMs":0,"TimeWindowMs":0},"Data":null,"Meta":null,"Error":{"Status":404,"Title":null,"Type":null,"Instance":null,"ErrorDetails":null,"Errors":null},"RequestMethod":{"Method":"GET"},"RequestUri":"https://api-b2b.bigcommerce.com/api/v3/io/companies/7992690","RequestBody":null}) ---> Microsoft.Data.SqlClient.SqlException: Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
Incorrect syntax near 'THROW'.
   at Microsoft.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__195_0(Task`1 result)
   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location ---
   at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location ---
   at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command)
   at SqlKata.Execution.QueryFactory.SelectAsync[T](String sql, Object param, IDbTransaction transaction, Nullable`1 timeout, CancellationToken cancellationToken)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.DbServiceBase.ExecuteQueryFactoryAsync[T](Func`2 executeFunc)
   at AG.DynamicsGPServices.GPPaymentSyncService.PostPaymentToGPAsync(GPPostPaymentRequest request, CancellationToken token)
   at AG.ScheduledJobs.Payments.ProcessInvoicePayment.ExecuteAsync(Int32 paymentId, CancellationToken cancellationToken)
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)

   --- End of inner exception stack trace ---
   at AG.ScheduledJobs.Payments.SyncPaymentsToGP.ExecuteAsync(CancellationToken cancellationToken)
   at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*)
   at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)

+1.551s Processing

Server:
cross-stitch-549567767c-g6vtl:1
Worker:
2ce255ac

+37ms Enqueued

Triggered by recurring job scheduler

08/31/2026 08:00:14 Created