// Id: #6a95348eba1269dca122da01
using AG.ScheduledJobs.Payments;
var syncPaymentsToGP = Activate<SyncPaymentsToGP>();
await syncPaymentsToGP.ExecuteAsync(null);
| RecurringJobId | |
| Time | |
| CurrentCulture | |
| CurrentUICulture | |
| RetryCount | |
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 10 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 9 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 8 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 7 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 6 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 5 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 4 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 3 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 2 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by DelayedJobScheduler
Retry attempt 1 of 10: One or more payments failed to sync to GP. (Incor…
An exception occurred during performance of the job.
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)
Triggered by recurring job scheduler