2025-08-09 16:34:44,358 [180] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 16:36:18,228 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 16:40:08,182 [195] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 16:40:09,612 [195] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 16:47:48,225 [197] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 18:13:24,930 [132] ERROR PayPal.Api.HttpConnection [(null)] - The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. 2025-08-09 18:25:34,570 [121] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-08-09 18:25:43,342 [159] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-08-09 18:26:11,137 [159] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-08-09 18:31:38,074 [174] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 18:32:06,889 [176] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 18:32:32,236 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 18:33:33,009 [171] ERROR PayPal.Api.HttpConnection [(null)] - The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. 2025-08-09 18:34:47,162 [197] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 18:36:43,417 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 18:36:44,049 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 0c448c26-d509-4103-aa54-63f0a217c6dc 2025-08-09 18:39:42,968 [202] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 18:47:47,431 [178] ERROR PayPal.Api.HttpConnection [(null)] - The underlying connection was closed: A connection that was expected to be kept alive was closed by the server. 2025-08-09 19:34:13,597 [154] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-08-09 19:34:13,597 [154] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"0b71a15f3e1d6","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-08-09 19:34:13,597 [154] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-08-09 19:34:13,597 [154] 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: 0b71a15f3e1d6 2025-08-09 19:34:13,597 [154] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-08-09 19:34:13,613 [154] 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-08-09 19:34:13,613 [154] 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-08-09 20:20:31,188 [73] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-08-09 20:20:31,188 [73] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"88b87f348b22d","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-08-09 20:20:31,188 [73] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-08-09 20:20:31,188 [73] 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: 88b87f348b22d 2025-08-09 20:20:31,188 [73] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-08-09 20:20:31,188 [73] 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-08-09 20:20:31,188 [73] 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-08-09 20:36:50,108 [58] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 20:37:00,145 [96] ERROR Grid_API.Helper.LogHelper [(null)] - Message: =============================================== inside from imagenai WorkorderId from imagenai: cc7f9f2c-1b80-43f7-b844-9b64d29fcee4 2025-08-09 20:37:00,567 [96] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Profile : HouseLens_AIProfile_RAW_031723 2025-08-09 20:37:00,583 [96] ERROR Grid_API.Helper.LogHelper [(null)] - Message: projectUuid from imagenai: 6897b16ce4a7e8ce43f879cc 2025-08-09 20:37:01,007 [96] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Raw image count: 41 2025-08-09 20:37:10,413 [52] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Upload image done from imagenai 2025-08-09 20:37:10,428 [52] ERROR Grid_API.Helper.LogHelper [(null)] - Message: SendProjectForEdit done from imagenai 2025-08-09 20:38:23,413 [29] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 64fa6c8a-2539-47d2-b9e3-20429a316bb3 2025-08-09 20:38:29,100 [29] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: fc377546-9b84-4098-a670-379a28bf5984 2025-08-09 20:44:25,359 [65] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 20:48:13,292 [158] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 20:51:41,279 [116] ERROR Grid_API.Helper.LogHelper [(null)] - Message: inside imagenai callback, projectid: 6897b16ce4a7e8ce43f879cc, status: Completed, action: edit 2025-08-09 20:51:41,794 [63] ERROR Grid_API.Helper.LogHelper [(null)] - Message: number of edited picture: 25 2025-08-09 20:51:41,810 [63] ERROR Grid_API.Helper.LogHelper [(null)] - Message: clientFolderId: 2172bfbc-2359-411f-9cce-60f476e04b6f 2025-08-09 20:51:44,303 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0001.dng 2025-08-09 20:51:45,454 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0002.dng 2025-08-09 20:51:47,657 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0003.dng 2025-08-09 20:51:48,580 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0004.dng 2025-08-09 20:51:49,418 [7] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0005.dng 2025-08-09 20:51:50,291 [109] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0006.dng 2025-08-09 20:51:51,129 [63] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0007.dng 2025-08-09 20:51:51,941 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0008.dng 2025-08-09 20:51:52,722 [109] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0009.dng 2025-08-09 20:51:53,528 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0013.dng 2025-08-09 20:51:54,316 [63] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0015.dng 2025-08-09 20:51:55,113 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0016.dng 2025-08-09 20:52:01,045 [109] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0017.dng 2025-08-09 20:52:01,866 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0018.dng 2025-08-09 20:52:02,699 [109] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0019.dng 2025-08-09 20:52:03,562 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0021.dng 2025-08-09 20:52:04,351 [63] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0022.dng 2025-08-09 20:52:05,110 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0023.dng 2025-08-09 20:52:05,950 [7] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0024.dng 2025-08-09 20:52:06,775 [7] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0025.dng 2025-08-09 20:52:07,630 [63] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0027.dng 2025-08-09 20:52:08,536 [63] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_5544-HDR.dng 2025-08-09 20:52:09,405 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_5549-HDR.dng 2025-08-09 20:52:10,195 [7] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_5554-HDR.dng 2025-08-09 20:52:10,987 [63] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_5559-HDR.dng 2025-08-09 20:52:59,745 [125] ERROR Grid_API.Helper.LogHelper [(null)] - Message: inside imagenai callback, projectid: 6897b16ce4a7e8ce43f879cc, status: Completed, action: export 2025-08-09 20:52:59,964 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: number of exported picture: 25 2025-08-09 20:52:59,979 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: clientFolderId: 2172bfbc-2359-411f-9cce-60f476e04b6f 2025-08-09 20:53:01,550 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0001.jpg 2025-08-09 20:53:02,887 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0002.jpg 2025-08-09 20:53:04,097 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0003.jpg 2025-08-09 20:53:05,420 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0004.jpg 2025-08-09 20:53:06,558 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0005.jpg 2025-08-09 20:53:07,714 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0006.jpg 2025-08-09 20:53:08,944 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0007.jpg 2025-08-09 20:53:10,048 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0008.jpg 2025-08-09 20:53:11,017 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0009.jpg 2025-08-09 20:53:12,074 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0013.jpg 2025-08-09 20:53:13,051 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0015.jpg 2025-08-09 20:53:14,051 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0016.jpg 2025-08-09 20:53:15,070 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0017.jpg 2025-08-09 20:53:16,073 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0018.jpg 2025-08-09 20:53:17,123 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0019.jpg 2025-08-09 20:53:18,277 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0021.jpg 2025-08-09 20:53:19,348 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0022.jpg 2025-08-09 20:53:20,505 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0023.jpg 2025-08-09 20:53:21,779 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0024.jpg 2025-08-09 20:53:22,928 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0025.jpg 2025-08-09 20:53:24,265 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_0027.jpg 2025-08-09 20:53:25,556 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_5544-HDR.jpg 2025-08-09 20:53:26,830 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_5549-HDR.jpg 2025-08-09 20:53:27,973 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_5554-HDR.jpg 2025-08-09 20:53:29,067 [151] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:706 Charney Ct, Hanover, MD, USA 21076_5559-HDR.jpg 2025-08-09 20:54:12,784 [81] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 20:54:17,086 [81] ERROR Grid_API.Helper.LogHelper [(null)] - Message: responseDto row count: 1 2025-08-09 20:54:17,101 [81] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Save uploaded files response: Success 2025-08-09 20:54:17,507 [81] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success 2025-08-09 21:00:07,775 [33] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 21:06:30,960 [134] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-08-09 21:23:39,200 [130] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 4e57f351-a79b-4df4-8e0f-0c9b9f6afe58 2025-08-10 00:38:30,463 [104] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: d9c99655-b8a5-494e-ad7b-346512a59823 2025-08-10 12:45:02,573 [171] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Generating weekly invoice on: 20250810 12:45:02.573 2025-08-10 12:55:00,664 [37] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Sending weekly invoice on: 20250810 12:55:00.664 2025-08-10 13:10:20,396 [97] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-08-10 14:00:04,700 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Generating weekly invoice on: 20250810 14:00:04.7 2025-08-10 14:00:13,979 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-08-10 14:00:13,979 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Cannot insert the value NULL into column 'InvoiceNo', table 'Grid_Enterprise.dbo.Grid_Artist_InvoiceItem'; column does not allow nulls. INSERT fails. 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.CreateInvoices3(String userID, String startDate, String endDate) 2025-08-10 14:00:13,979 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Cannot insert the value NULL into column 'InvoiceNo', table 'Grid_Enterprise.dbo.Grid_Artist_InvoiceItem'; column does not allow nulls. INSERT fails. The statement has been terminated. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.CreateInvoices3(String userID, String startDate, String endDate) at Grid_API.ServiceLayer.GridAPIService.CreateInvoices3(String tokenID, String userID, String startDate, String endDate) 2025-08-10 14:10:05,038 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Sending weekly invoice on: 20250810 14:10:05.038 2025-08-10 15:54:08,765 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out 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.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-08-10 15:54:08,765 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-08-10 15:54:08,765 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderProperty(String ClientID, String workOrderIdentity, String PropertyAliasName) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) 2025-08-10 15:55:45,924 [79] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out 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.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-08-10 15:55:45,924 [79] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-08-10 15:55:45,924 [79] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderProperty(String ClientID, String workOrderIdentity, String PropertyAliasName) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) 2025-08-10 15:57:24,190 [119] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out 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.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-08-10 15:57:24,190 [119] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-08-10 15:57:24,205 [119] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderProperty(String ClientID, String workOrderIdentity, String PropertyAliasName) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) 2025-08-10 15:57:54,134 [112] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out 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.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-08-10 15:57:54,134 [112] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-08-10 15:59:34,091 [119] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out 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.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-08-10 15:59:34,091 [119] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing 2025-08-10 15:59:34,091 [119] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID) 2025-08-10 16:00:11,988 [57] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out 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.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-08-10 16:00:11,988 [57] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing 2025-08-10 16:00:11,988 [57] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID) 2025-08-10 16:00:12,144 [119] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-08-10 16:00:12,144 [119] 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-08-10 16:00:12,144 [119] 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)