2025-10-11 22:47:17,336 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 537e6a8c-1ce5-4cbc-aa66-036bcfdc0580

2025-10-12 09:51:21,672 [106] ERROR PayPal.Api.HttpConnection [(null)] - Error response:
2025-10-12 09:51:21,672 [106] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"6f49484130c77","message":"Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.","information_link":"https://developer.paypal.com/docs/api/payments.billing-agreements#errors"}
2025-10-12 09:51:21,672 [106] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request.
2025-10-12 09:51:21,672 [106] ERROR PayPal.PayPalException [(null)] - Payments Exception: 
   Error:    MERCHANT_ACCOUNT_DENIED
   Message:  Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.
   URI:      https://developer.paypal.com/docs/api/payments.billing-agreements#errors
   Debug ID: 6f49484130c77

2025-10-12 09:51:21,672 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-10-12 09:51:21,688 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader)
   at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
2025-10-12 09:51:21,688 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
   at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname)
2025-10-12 11:56:53,863 [29] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24512

2025-10-12 11:56:53,863 [29] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24512 :BadRequest

2025-10-12 11:56:53,863 [29] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"jtsui@weichert.com","PrismUserID":"jasminetsui","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"24512","UserID":"a05932bf-dded-4f6c-b528-552fcadb488d","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-10-12 12:45:00,656 [40] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Generating weekly invoice on: 20251012 12:45:00.656

2025-10-12 12:55:01,020 [100] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Sending weekly invoice on: 20251012 12:55:01.02

2025-10-12 14:00:00,086 [33] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Generating weekly invoice on: 20251012 14:00:00.086

2025-10-12 14:10:00,027 [114] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Sending weekly invoice on: 20251012 14:10:00.027

2025-10-12 16:00:00,215 [13] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-12 17:04:01,533 [130] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24514

2025-10-12 17:04:01,533 [130] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24514 :BadRequest

2025-10-12 17:04:01,533 [130] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"eborowsky@weichert.com","PrismUserID":"1lisaborowsky","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"24514","UserID":"363da185-1afa-4628-a7c5-333c84595707","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-10-12 17:09:14,136 [47] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24515

2025-10-12 17:09:14,136 [47] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24515 :OK

2025-10-12 17:09:14,136 [47] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"eborowsky@weichert.com","PrismUserID":"1lisaborowsky","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":"829F Balmoral Court, Lakewood, NJ, USA","PropertyCity":"Lakewood","PropertyState":"NJ","PropertyZIP":"08701","Price":"125","SquareFeet":"670","ListingID":"24515","UserID":"363da185-1afa-4628-a7c5-333c84595707","Bedrooms":null,"Bathrooms":"1","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"SUBMITTED","Style":null}

2025-10-12 18:53:44,619 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-10-12 18:53:44,619 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.UpdateInvoiceDetail(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 18:53:44,619 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
   at Grid_API.ServiceLayer.GridAPIService.RejectInvoice(String tokenID, String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 18:53:54,291 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-10-12 18:53:54,291 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.UpdateInvoiceDetail(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 18:53:54,291 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
   at Grid_API.ServiceLayer.GridAPIService.RejectInvoice(String tokenID, String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 18:54:14,314 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-10-12 18:54:14,330 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.UpdateInvoiceDetail(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 18:54:14,330 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
   at Grid_API.ServiceLayer.GridAPIService.RejectInvoice(String tokenID, String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 18:54:23,556 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-10-12 18:54:23,556 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.UpdateInvoiceDetail(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 18:54:23,556 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
   at Grid_API.ServiceLayer.GridAPIService.RejectInvoice(String tokenID, String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 18:54:37,661 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-10-12 18:54:37,662 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.UpdateInvoiceDetail(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 18:54:37,663 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: String or binary data would be truncated.
The statement has been terminated.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.RejectInvoice(String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
   at Grid_API.ServiceLayer.GridAPIService.RejectInvoice(String tokenID, String userID, String invoiceNo, InvoiceDetailDTO invoiceDetails, String rejectDescription)
2025-10-12 19:11:35,575 [22] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-12 20:45:38,208 [106] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-12 20:45:38,255 [106] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-12 20:45:46,896 [106] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-12 21:37:26,493 [65] ERROR PayPal.Api.HttpConnection [(null)] - Error response:
2025-10-12 21:37:26,493 [65] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"131da00ceff1f","message":"Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.","information_link":"https://developer.paypal.com/docs/api/payments.billing-agreements#errors"}
2025-10-12 21:37:26,493 [65] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request.
2025-10-12 21:37:26,493 [65] ERROR PayPal.PayPalException [(null)] - Payments Exception: 
   Error:    MERCHANT_ACCOUNT_DENIED
   Message:  Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.
   URI:      https://developer.paypal.com/docs/api/payments.billing-agreements#errors
   Debug ID: 131da00ceff1f

2025-10-12 21:37:26,493 [65] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-10-12 21:37:26,493 [65] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader)
   at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
2025-10-12 21:37:26,493 [65] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
   at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname)
2025-10-12 21:37:26,900 [65] ERROR PayPal.Api.HttpConnection [(null)] - Error response:
2025-10-12 21:37:26,900 [65] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"ec664239d1398","message":"Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.","information_link":"https://developer.paypal.com/docs/api/payments.billing-agreements#errors"}
2025-10-12 21:37:26,900 [65] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request.
2025-10-12 21:37:26,900 [65] ERROR PayPal.PayPalException [(null)] - Payments Exception: 
   Error:    MERCHANT_ACCOUNT_DENIED
   Message:  Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.
   URI:      https://developer.paypal.com/docs/api/payments.billing-agreements#errors
   Debug ID: ec664239d1398

2025-10-12 21:37:26,900 [65] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-10-12 21:37:26,900 [65] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader)
   at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
2025-10-12 21:37:26,900 [65] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
   at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname)
2025-10-12 23:53:24,698 [27] ERROR PayPal.Api.HttpConnection [(null)] - Error response:
2025-10-12 23:53:24,698 [27] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"6608dfe62e24d","message":"Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.","information_link":"https://developer.paypal.com/docs/api/payments.billing-agreements#errors"}
2025-10-12 23:53:24,698 [27] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request.
2025-10-12 23:53:24,698 [27] ERROR PayPal.PayPalException [(null)] - Payments Exception: 
   Error:    MERCHANT_ACCOUNT_DENIED
   Message:  Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.
   URI:      https://developer.paypal.com/docs/api/payments.billing-agreements#errors
   Debug ID: 6608dfe62e24d

2025-10-12 23:53:24,698 [27] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-10-12 23:53:24,698 [27] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader)
   at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
2025-10-12 23:53:24,698 [27] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
   at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname)
2025-10-13 01:25:24,987 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: {"WorkOrderId":null,"StepNumber":6,"BatchId":null,"CreatedOn":"\/Date(1760318724464)\/","ResponseTime":"\/Date(1760318724987)\/","RequestBody":"{\"id\":\"3680fcb6-0d44-4eaa-ae01-33bbeae223de\",\"method\":\"getAssets\",\"jsonrpc\":\"2.0\",\"params\":{\"clientId\":\"50100184\",\"reference\":\"\",\"receivingCompany\":null,\"orderLines\":null,\"callbackUrl\":null,\"materialsHttp\":null,\"batchId\":70020937917}}","ResponseBody":"{\"jsonrpc\":\"2.0\",\"id\":\"3680fcb6-0d44-4eaa-ae01-33bbeae223de\",\"result\":{\"state\":\"ACTIVE\",\"pictures\":[],\"animatedPictures\":[],\"floorPlans\":[],\"panoramasHtml5\":[],\"panoramasFlash\":[],\"panoramasJpeg\":[],\"videos\":[],\"slideShows\":[],\"links\":[],\"copywriteTexts\":[],\"qrCodes\":[],\"interactivePresentation\":null,\"poiPresentation\":null,\"beforeAfterPictures\":[],\"beforeAfterPanoramas\":[],\"matterport\":null}}","ResponseType":"success"}

2025-10-13 01:29:20,497 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: {"WorkOrderId":null,"StepNumber":6,"BatchId":null,"CreatedOn":"\/Date(1760318959987)\/","ResponseTime":"\/Date(1760318960497)\/","RequestBody":"{\"id\":\"fc5b594e-8071-4577-920f-187c22b8276c\",\"method\":\"getAssets\",\"jsonrpc\":\"2.0\",\"params\":{\"clientId\":\"50100184\",\"reference\":\"\",\"receivingCompany\":null,\"orderLines\":null,\"callbackUrl\":null,\"materialsHttp\":null,\"batchId\":70020937910}}","ResponseBody":"{\"jsonrpc\":\"2.0\",\"id\":\"fc5b594e-8071-4577-920f-187c22b8276c\",\"result\":{\"state\":\"ACTIVE\",\"pictures\":[],\"animatedPictures\":[],\"floorPlans\":[],\"panoramasHtml5\":[],\"panoramasFlash\":[],\"panoramasJpeg\":[],\"videos\":[],\"slideShows\":[],\"links\":[],\"copywriteTexts\":[],\"qrCodes\":[],\"interactivePresentation\":null,\"poiPresentation\":null,\"beforeAfterPictures\":[],\"beforeAfterPanoramas\":[],\"matterport\":null}}","ResponseType":"success"}

2025-10-13 01:29:21,491 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: {"WorkOrderId":null,"StepNumber":6,"BatchId":null,"CreatedOn":"\/Date(1760318961194)\/","ResponseTime":"\/Date(1760318961491)\/","RequestBody":"{\"id\":\"45de1ccb-e5ee-4bda-8f3a-72db690935ef\",\"method\":\"getAssets\",\"jsonrpc\":\"2.0\",\"params\":{\"clientId\":\"50100184\",\"reference\":\"\",\"receivingCompany\":null,\"orderLines\":null,\"callbackUrl\":null,\"materialsHttp\":null,\"batchId\":70020937920}}","ResponseBody":"{\"jsonrpc\":\"2.0\",\"id\":\"45de1ccb-e5ee-4bda-8f3a-72db690935ef\",\"result\":{\"state\":\"ACTIVE\",\"pictures\":[],\"animatedPictures\":[],\"floorPlans\":[],\"panoramasHtml5\":[],\"panoramasFlash\":[],\"panoramasJpeg\":[],\"videos\":[],\"slideShows\":[],\"links\":[],\"copywriteTexts\":[],\"qrCodes\":[],\"interactivePresentation\":null,\"poiPresentation\":null,\"beforeAfterPictures\":[],\"beforeAfterPanoramas\":[],\"matterport\":null}}","ResponseType":"success"}

2025-10-13 01:29:22,445 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: {"WorkOrderId":null,"StepNumber":6,"BatchId":null,"CreatedOn":"\/Date(1760318962179)\/","ResponseTime":"\/Date(1760318962445)\/","RequestBody":"{\"id\":\"0631ebb9-10c9-44cf-83c3-ee9a22f217c9\",\"method\":\"getAssets\",\"jsonrpc\":\"2.0\",\"params\":{\"clientId\":\"50100184\",\"reference\":\"\",\"receivingCompany\":null,\"orderLines\":null,\"callbackUrl\":null,\"materialsHttp\":null,\"batchId\":70020937877}}","ResponseBody":"{\"jsonrpc\":\"2.0\",\"id\":\"0631ebb9-10c9-44cf-83c3-ee9a22f217c9\",\"result\":{\"state\":\"ACTIVE\",\"pictures\":[],\"animatedPictures\":[],\"floorPlans\":[],\"panoramasHtml5\":[],\"panoramasFlash\":[],\"panoramasJpeg\":[],\"videos\":[],\"slideShows\":[],\"links\":[],\"copywriteTexts\":[],\"qrCodes\":[],\"interactivePresentation\":null,\"poiPresentation\":null,\"beforeAfterPictures\":[],\"beforeAfterPanoramas\":[],\"matterport\":null}}","ResponseType":"success"}

2025-10-13 02:03:40,475 [141] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24516

2025-10-13 02:03:40,475 [141] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24516 :BadRequest

2025-10-13 02:03:40,475 [141] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"jtsui@weichert.com","PrismUserID":"jasminetsui","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"24516","UserID":"a05932bf-dded-4f6c-b528-552fcadb488d","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-10-13 02:04:07,094 [81] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24517

2025-10-13 02:04:07,094 [81] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24517 :BadRequest

2025-10-13 02:04:07,094 [81] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"jtsui@weichert.com","PrismUserID":"jasminetsui","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"24517","UserID":"a05932bf-dded-4f6c-b528-552fcadb488d","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-10-13 02:06:35,213 [60] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24518

2025-10-13 02:06:35,213 [60] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24518 :OK

2025-10-13 02:06:35,213 [60] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"jtsui@weichert.com","PrismUserID":"jasminetsui","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":"35 Revere Boulevard, Edison, NJ, USA","PropertyCity":"Edison","PropertyState":"NJ","PropertyZIP":"08820","Price":"175","SquareFeet":"2000","ListingID":"24518","UserID":"a05932bf-dded-4f6c-b528-552fcadb488d","Bedrooms":null,"Bathrooms":"2","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"SUBMITTED","Style":null}

2025-10-13 02:06:53,021 [155] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-13 02:07:06,320 [155] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-13 02:07:20,703 [155] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-13 02:07:33,208 [155] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-13 02:07:56,584 [155] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-13 02:08:08,162 [155] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-13 02:08:20,459 [45] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-10-13 02:26:49,633 [103] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 6adcc44d-ed7e-43b3-ae9b-1d82df42e688

2025-10-13 02:26:52,687 [103] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 22ea0c55-1234-4429-8e80-34b26d86f6a8

2025-10-13 02:26:56,228 [103] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 31138d47-a889-4a52-99d8-927a2e2b793e

2025-10-13 02:26:59,080 [103] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 9a3211a4-6526-4d60-805b-39822c195af3