2025-09-24 12:10:24,082 [34] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-09-24 12:10:24,098 [34] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"3ed4b6fdb04f8","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-09-24 12:10:24,098 [34] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-09-24 12:10:24,160 [34] 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: 3ed4b6fdb04f8 2025-09-24 12:10:24,160 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 12:10:24,176 [34] 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-09-24 12:10:24,176 [34] 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-09-24 12:14:05,735 [25] 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-09-24 13:08:08,071 [25] 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-09-24 13:08:09,899 [98] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24387 2025-09-24 13:08:09,899 [98] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24387 :BadRequest 2025-09-24 13:08:09,899 [98] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"rvolive2413@yahoo.com","PrismUserID":"rvolive2413","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"24387","UserID":"76e73e84-c350-4045-a8b0-75783363b932","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null} 2025-09-24 13:08:51,564 [15] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24388 2025-09-24 13:08:51,564 [15] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24388 :BadRequest 2025-09-24 13:08:51,564 [15] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"rvolive2413@yahoo.com","PrismUserID":"rvolive2413","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"24388","UserID":"76e73e84-c350-4045-a8b0-75783363b932","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null} 2025-09-24 13:14:46,109 [39] 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-09-24 13:15:05,606 [36] 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-09-24 13:15:59,816 [110] 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-09-24 13:53:28,263 [112] 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-09-24 13:54:13,247 [92] 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-09-24 13:59:59,673 [53] 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-09-24 14:06:33,549 [98] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24389 2025-09-24 14:06:33,549 [98] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24389 :BadRequest 2025-09-24 14:06:33,549 [98] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"bpatterson830@gmail.com","PrismUserID":"bpatterson","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"24389","UserID":"b6b19f3c-6e31-4cdc-903d-f76649435604","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null} 2025-09-24 14:09:51,176 [35] 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-09-24 14:11:06,284 [37] 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-09-24 14:11:49,558 [37] 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-09-24 14:12:15,569 [107] 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-09-24 14:13:13,870 [19] 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-09-24 14:13:18,479 [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-09-24 14:13:23,122 [83] 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-09-24 14:13:59,758 [75] 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-09-24 14:14:37,796 [16] 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.AddUpdateData(String commandKey, SqlCommand& cmd, Boolean isReturnmsg, Boolean isStatuscode) 2025-09-24 14:14:37,796 [16] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset 2025-09-24 14:14:40,501 [27] 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.AddUpdateData(String commandKey, SqlCommand& cmd, Boolean isReturnmsg, Boolean isStatuscode) 2025-09-24 14:14:40,501 [27] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset 2025-09-24 14:25:09,400 [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-09-24 14:26:37,595 [42] 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-09-24 14:30:46,396 [88] 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-09-24 14:32:56,452 [107] 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-09-24 14:39:24,871 [98] 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-09-24 14:43:19,505 [106] 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-09-24 14:44:58,449 [35] 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-09-24 14:45:19,461 [71] 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-09-24 14:46:19,407 [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-09-24 14:54:14,222 [82] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24386 2025-09-24 14:54:14,222 [82] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24386 :OK 2025-09-24 14:54:14,222 [82] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"lwade.weichert@gmail.com","PrismUserID":"l.wade","PhotoURLs":[],"ListingWebsite":"","PropertyAddress":"13 Mallard Drive, Tabernacle, NJ 08088","PropertyCity":"Tabernacle","PropertyState":"NJ","PropertyZIP":"08088","Price":null,"SquareFeet":"1913","ListingID":"24386","UserID":"58b13d60-da9e-4d87-9a3f-0651d6e3269a","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"1.22 acres","ListingOrderState":"SCHEDULED","Style":""} 2025-09-24 14:59:48,748 [31] 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-09-24 15:00:14,839 [103] 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-09-24 15:00:16,365 [103] 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-09-24 15:00:52,473 [37] 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-09-24 15:05:55,865 [62] 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-09-24 15:08:37,867 [32] 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-09-24 15:09:51,429 [77] 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-09-24 15:10:50,556 [45] 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-09-24 15:13:56,522 [64] 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-09-24 15:14:07,525 [64] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24224 2025-09-24 15:14:07,525 [64] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24224 :OK 2025-09-24 15:14:07,525 [64] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"TurnKeyWithAmity@gmail.com","PrismUserID":"amorales1","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F759b2be7-337b-4bee-b07c-7fd05bbc218a.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F1f852897-0eaf-48f4-869a-54764a47103d.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fef1d8c3a-496a-48e4-8da3-bdc017d49c68.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F880a5364-dfa9-40e2-90f9-ebba618b9f87.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Facacc411-8c60-4639-ba2f-be2715eb8808.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb14bbd61-82e8-4f76-e6c5-89843286ef11.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdcd08afb-7b9f-4a89-b7f0-599f446b3362.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5c772029-85f0-4664-a3ea-e13207c464b4.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd30f162b-c825-41b8-9323-7ee3d2902a1b.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd21680a5-5ab5-42a2-bea5-0233364786de.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fa87c1e33-065b-4b3d-e9a4-6788818d1b2f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F8e52e7f0-cd00-42c8-ccf6-7eaccc00ae3b.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F473d4b3e-4d13-4f48-b345-01a93e81952f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4552e804-9193-4cc7-b56d-b5082bc0c56a.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3c2e6dfb-4d6e-459d-c380-1ae59f02136f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd7a7f680-9837-4193-b087-2f5cbae75f86.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2b10b109-4f9c-4694-8311-6f207f15fd50.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5eb7c0f0-91c7-474b-c6eb-daa86de0b0eb.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5d01bf7b-2d7e-49e0-9634-754c39ed11d1.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F1d8adc42-6b62-4937-8025-81583494674e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fad1e8a08-1a35-4727-8ef7-bf6dff584d3c.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F916c542d-a4a0-46ef-b170-51b719cccbb8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F37008ab5-dd87-4fb4-af2c-0daaf0bc9fde.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F01487889-0528-47e2-ff78-60ad37d1c8cd.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F61b237f4-1eca-45f0-8a99-0195fee7ae34.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F147d9b93-a0e0-49f5-801a-45b16469c4df.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fa171e91a-56cb-4a1b-ca0e-44fd95ba4f87.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Feec8476e-3691-4c55-f94b-df744acf584c.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9ee7da29-6543-460a-919d-999eb3ee959f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fe3bb072a-0c04-4d5f-c0a8-6eea8da23913.jpg"],"ListingWebsite":"","PropertyAddress":"156 Morris St, Browns Mills, NJ, USA 08015","PropertyCity":"Browns Mills","PropertyState":"NJ","PropertyZIP":"08015","Price":null,"SquareFeet":"1200","ListingID":"24224","UserID":"40a42142-8dab-4319-b950-310be295da53","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":"Ranch"} 2025-09-24 15:14:31,156 [51] 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-09-24 15:23:01,740 [37] 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-09-24 15:23:08,974 [37] 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-09-24 15:28:32,919 [49] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 15:28:39,161 [49] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 15:28:45,357 [49] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 15:28:45,404 [49] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 15:28:46,710 [49] 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-09-24 15:30:57,210 [97] 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-09-24 15:32:22,278 [31] 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-09-24 15:36:30,525 [45] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-09-24 15:36:30,525 [45] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"0e50a0e386a40","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-09-24 15:36:30,525 [45] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-09-24 15:36:30,525 [45] 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: 0e50a0e386a40 2025-09-24 15:36:30,525 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 15:36:30,525 [45] 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-09-24 15:36:30,525 [45] 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-09-24 15:36:33,641 [45] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-09-24 15:36:33,641 [45] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"558c0808b3169","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-09-24 15:36:33,641 [45] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-09-24 15:36:33,641 [45] 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: 558c0808b3169 2025-09-24 15:36:33,641 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 15:36:33,641 [45] 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-09-24 15:36:33,641 [45] 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-09-24 15:46:50,861 [101] 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-09-24 16:08:08,544 [82] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-09-24 16:08:08,544 [82] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"b3801b0b1dde3","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-09-24 16:08:08,544 [82] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-09-24 16:08:08,544 [82] 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: b3801b0b1dde3 2025-09-24 16:08:08,544 [82] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 16:08:08,544 [82] 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-09-24 16:08:08,544 [82] 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-09-24 16:10:22,941 [82] 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-09-24 16:15:52,602 [76] 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-09-24 16:17:54,866 [78] 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-09-24 16:20:35,402 [56] 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-09-24 16:23:56,143 [97] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-09-24 16:23:56,143 [97] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"8de1f4442b7d9","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-09-24 16:23:56,143 [97] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-09-24 16:23:56,143 [97] 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: 8de1f4442b7d9 2025-09-24 16:23:56,143 [97] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 16:23:56,143 [97] 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-09-24 16:23:56,143 [97] 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-09-24 16:27:35,812 [37] 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-09-24 16:32:14,678 [36] 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-09-24 16:42:07,939 [36] 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-09-24 16:53:57,592 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24359 2025-09-24 16:53:57,592 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24359 :OK 2025-09-24 16:53:57,592 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"ArturSellsNJ@gmail.com","PrismUserID":"arturloginov","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F60650a25-ee5c-48ee-cf25-075e50cb8e49.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F89b86c37-728f-49f1-a923-6a4cca9084f8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F905b79a8-bd30-422e-e8b7-fcd42b89d2c8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F84db747d-b064-4763-f66a-386db8cdf338.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fe874a8ab-9e9f-4a7f-97b1-982f3949a420.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb6a1edde-1b4f-4aa0-c188-3bc642d7f71f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F563cac36-58fc-456e-b5e0-8b701c0984f3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F219441fe-3b45-4924-b32a-044ce33929c0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F288793b1-4254-4a0a-8963-3450131e170b.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F70024d02-3cf3-4a39-f7d8-90fc9fd236b6.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F45266844-bea0-4d32-b054-4e5c5faf94b3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd67b2b27-8a53-4b4e-d3cc-d956a2b0e57f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdfc7d073-b7fe-4d80-90ff-92ba96815e80.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ff215de10-eb73-49cf-fae3-83dce3e9135e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdbef4050-24f0-494c-a5af-d8e43c55ad62.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F34b077be-99f4-41a9-d957-d42ba1f93b97.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdec30773-4dcd-4ff4-f84f-452a769b7d39.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdfb656ef-42dd-4e0c-bc04-36d1d3280d84.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fa7f9e567-e38d-471d-9df4-c91813205f57.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F0d661d88-ccb6-4d51-bce2-319d3cc04ec0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5e3a8651-b7df-468f-c4a8-24d0979fdf67.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F28931c39-7e6b-4ce7-fa4a-1de1b55639ed.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Faefba997-23ed-46f5-a0a3-6f9ade1640e3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fc813f59d-0516-4c6c-c372-138d1783b812.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd798e499-276e-4037-e427-1f89ff6edf63.jpg"],"ListingWebsite":"","PropertyAddress":"385 Aldo dr. toms river NJ 08753","PropertyCity":"Toms River","PropertyState":"NJ","PropertyZIP":"08753","Price":null,"SquareFeet":"1500","ListingID":"24359","UserID":"c175e768-c9b1-4a25-a50a-f4e4363dfd1e","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":""} 2025-09-24 16:54:27,898 [77] 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-09-24 17:02:49,713 [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-09-24 17:03:25,913 [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-09-24 17:09:32,971 [26] 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-09-24 17:11:17,462 [13] 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-09-24 17:14:44,071 [22] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24294 2025-09-24 17:14:44,071 [22] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24294 :OK 2025-09-24 17:14:44,071 [22] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"jtsui@weichert.com","PrismUserID":"jasminetsui","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fc3b96f5f-8c09-40b6-83df-e93fb260d8c9.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2569c667-c613-4577-f219-330220ee331c.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F0271bbf3-0a97-4879-a6b3-ffc232971c45.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5e0e318a-ced0-478f-a5a1-eadbc91f444b.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F7bb15810-7a59-442f-f780-9c8d94d52799.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9cb0694b-b709-4a5d-d23b-281c1c15493b.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ff9fc25ac-8642-4b84-fdf4-e12a1526eb7a.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2f513e90-e7ac-46e1-de97-c121985e1eab.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ffc48190a-35da-4a50-c2ef-e691c7f36ea9.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F8735ddbe-9eb6-4e0a-b613-c5f2113d8af1.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F57e1e509-ce22-4253-d46d-5c809fd7e40a.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb5b18a35-9cfb-48bf-fd4c-52e2404a5160.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4d986b1a-fec5-4c5b-f16b-923bf5f6ce8d.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9608fe4d-dcb4-48d0-f951-11920da27d95.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb4ba20dc-9262-4805-93bb-363af1a7d787.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fca40aec9-2bd3-4c1b-995e-68dfe7540717.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fc24b5813-24e0-4519-bcba-eb0b4b22d6c6.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F748e0bd1-4c79-4488-8fcb-34bb2c0378ad.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F75386b3e-417e-4029-807f-843d664f9b87.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3c1b3401-385a-4416-965c-576a9afc5f8a.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F58102cd8-0df7-4ca7-c52c-8719242eab3f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F36440221-b25e-44f8-e6cc-8a9d8f376ad0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fe70bcceb-9c4d-40d2-8f64-0a69f3b5b6cc.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F110fa47e-830e-42c8-a6b6-5c42aff931df.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ffb3ae9f9-85ab-40b8-e658-4e1479d942b5.jpg"],"ListingWebsite":"","PropertyAddress":"284 Old Post Rd, Edison, NJ 08817, USA","PropertyCity":"Edison","PropertyState":"NJ","PropertyZIP":"08817","Price":null,"SquareFeet":"900","ListingID":"24294","UserID":"a05932bf-dded-4f6c-b528-552fcadb488d","Bedrooms":"3","Bathrooms":"1","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":""} 2025-09-24 17:15:08,320 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24359 2025-09-24 17:15:08,320 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24359 :OK 2025-09-24 17:15:08,320 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"ArturSellsNJ@gmail.com","PrismUserID":"arturloginov","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F60650a25-ee5c-48ee-cf25-075e50cb8e49.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F89b86c37-728f-49f1-a923-6a4cca9084f8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F905b79a8-bd30-422e-e8b7-fcd42b89d2c8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F84db747d-b064-4763-f66a-386db8cdf338.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fe874a8ab-9e9f-4a7f-97b1-982f3949a420.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb6a1edde-1b4f-4aa0-c188-3bc642d7f71f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F563cac36-58fc-456e-b5e0-8b701c0984f3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F219441fe-3b45-4924-b32a-044ce33929c0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F288793b1-4254-4a0a-8963-3450131e170b.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F70024d02-3cf3-4a39-f7d8-90fc9fd236b6.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F45266844-bea0-4d32-b054-4e5c5faf94b3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd67b2b27-8a53-4b4e-d3cc-d956a2b0e57f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdfc7d073-b7fe-4d80-90ff-92ba96815e80.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ff215de10-eb73-49cf-fae3-83dce3e9135e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdbef4050-24f0-494c-a5af-d8e43c55ad62.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F34b077be-99f4-41a9-d957-d42ba1f93b97.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdec30773-4dcd-4ff4-f84f-452a769b7d39.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdfb656ef-42dd-4e0c-bc04-36d1d3280d84.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fa7f9e567-e38d-471d-9df4-c91813205f57.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F0d661d88-ccb6-4d51-bce2-319d3cc04ec0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5e3a8651-b7df-468f-c4a8-24d0979fdf67.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F7488af7a-33ac-4337-857e-ffed43e38ab8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Faefba997-23ed-46f5-a0a3-6f9ade1640e3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fc813f59d-0516-4c6c-c372-138d1783b812.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd798e499-276e-4037-e427-1f89ff6edf63.jpg"],"ListingWebsite":"","PropertyAddress":"385 Aldo dr. toms river NJ 08753","PropertyCity":"Toms River","PropertyState":"NJ","PropertyZIP":"08753","Price":null,"SquareFeet":"1500","ListingID":"24359","UserID":"c175e768-c9b1-4a25-a50a-f4e4363dfd1e","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":""} 2025-09-24 17:24:04,463 [103] 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-09-24 17:33:09,557 [53] 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-09-24 17:33:20,695 [53] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 17:33:48,048 [53] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 17:34:25,277 [53] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 17:35:18,652 [39] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 17:35:18,668 [68] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 17:35:28,647 [22] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 17:35:28,647 [86] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 18:08:40,514 [60] 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-09-24 18:11:15,841 [98] 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-09-24 18:26:16,002 [22] 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-09-24 18:37:33,890 [56] 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-09-24 18:51:24,445 [84] 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-09-24 19:05:52,487 [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-09-24 19:08:03,089 [61] 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-09-24 19:08:03,779 [66] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 482b9c50-df6b-4e36-a542-6f9dfcd9f5ec 2025-09-24 19:14:41,903 [31] 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-09-24 19:23:36,141 [44] 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-09-24 19:24:00,308 [44] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24390 2025-09-24 19:24:00,308 [44] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24390 :OK 2025-09-24 19:24:00,308 [44] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"dcinquemane@weichert.com","PrismUserID":"dcinquemane","PhotoURLs":[],"ListingWebsite":"","PropertyAddress":"39 Marlow Avenue, Brick Township, NJ, USA 08724","PropertyCity":"Brick Township","PropertyState":"NJ","PropertyZIP":"08724","Price":null,"SquareFeet":"1500","ListingID":"24390","UserID":"6f7e02dc-6c43-4baa-be1d-6f19c5b2f7ef","Bedrooms":"3","Bathrooms":"2","PropertyType":"residential","MLSNumber":"2253023","MLSName":"Monmouth","YearBuilt":0,"Description":"Colonial","LotSize":"75 x 125","ListingOrderState":"SCHEDULED","Style":"colonial"} 2025-09-24 19:29:18,560 [101] 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-09-24 19:29:52,962 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Error converting data type nvarchar to uniqueidentifier. 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-09-24 19:29:52,962 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm 2025-09-24 19:29:52,962 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 19:29:52,962 [23] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:29:52,962 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:29:53,072 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Error converting data type nvarchar to uniqueidentifier. 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-09-24 19:29:53,072 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm 2025-09-24 19:29:53,072 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 19:29:53,072 [23] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:29:53,072 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:29:53,384 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Error converting data type nvarchar to uniqueidentifier. 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-09-24 19:29:53,384 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm 2025-09-24 19:29:53,384 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 19:29:53,384 [23] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:29:53,384 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:29:53,603 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Error converting data type nvarchar to uniqueidentifier. 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-09-24 19:29:53,603 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm 2025-09-24 19:29:53,603 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 19:29:53,603 [23] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:29:53,603 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:44:32,244 [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-09-24 19:47:45,841 [70] 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-09-24 19:47:51,214 [78] 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-09-24 19:49:13,063 [48] 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-09-24 19:50:21,441 [79] 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-09-24 19:52:16,052 [46] 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-09-24 19:52:58,383 [76] 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-09-24 19:53:24,362 [76] 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-09-24 19:57:18,310 [31] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Error converting data type nvarchar to uniqueidentifier. 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-09-24 19:57:18,310 [31] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm 2025-09-24 19:57:18,310 [31] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 19:57:18,310 [31] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:57:18,310 [31] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:57:18,451 [31] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Error converting data type nvarchar to uniqueidentifier. 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-09-24 19:57:18,451 [31] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm 2025-09-24 19:57:18,451 [31] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 19:57:18,451 [31] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 19:57:18,451 [31] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 20:00:02,920 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Error converting data type nvarchar to uniqueidentifier. 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-09-24 20:00:02,920 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm 2025-09-24 20:00:02,920 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 20:00:02,920 [75] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 20:00:02,920 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 20:00:03,045 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Error converting data type nvarchar to uniqueidentifier. 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-09-24 20:00:03,045 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm 2025-09-24 20:00:03,045 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 20:00:03,045 [75] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 20:00:03,045 [75] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId) 2025-09-24 20:07:48,612 [35] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24359 2025-09-24 20:07:48,612 [35] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24359 :OK 2025-09-24 20:07:48,612 [35] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"ArturSellsNJ@gmail.com","PrismUserID":"arturloginov","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F288793b1-4254-4a0a-8963-3450131e170b.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F70024d02-3cf3-4a39-f7d8-90fc9fd236b6.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F45266844-bea0-4d32-b054-4e5c5faf94b3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd67b2b27-8a53-4b4e-d3cc-d956a2b0e57f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdfc7d073-b7fe-4d80-90ff-92ba96815e80.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdbef4050-24f0-494c-a5af-d8e43c55ad62.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F34b077be-99f4-41a9-d957-d42ba1f93b97.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdec30773-4dcd-4ff4-f84f-452a769b7d39.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdfb656ef-42dd-4e0c-bc04-36d1d3280d84.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fa7f9e567-e38d-471d-9df4-c91813205f57.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F0d661d88-ccb6-4d51-bce2-319d3cc04ec0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F7488af7a-33ac-4337-857e-ffed43e38ab8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Faefba997-23ed-46f5-a0a3-6f9ade1640e3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fc813f59d-0516-4c6c-c372-138d1783b812.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd798e499-276e-4037-e427-1f89ff6edf63.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F688865f4-09fa-4256-88cb-9ae64085f314.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3ed1fe3b-fefd-40ea-8716-fe9526c90961.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fc3cd8077-d4e3-4172-cf8d-f5cb40bea0a5.jpg"],"ListingWebsite":"","PropertyAddress":"385 Aldo dr. toms river NJ 08753","PropertyCity":"Toms River","PropertyState":"NJ","PropertyZIP":"08753","Price":null,"SquareFeet":"1500","ListingID":"24359","UserID":"c175e768-c9b1-4a25-a50a-f4e4363dfd1e","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":""} 2025-09-24 20:08:42,069 [35] 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-09-24 20:23:57,469 [64] 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-09-24 20:55:16,354 [109] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24392 2025-09-24 20:55:16,354 [109] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24392 :BadRequest 2025-09-24 20:55:16,354 [109] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"cwilliams13@verizon.net","PrismUserID":"cathywilliams","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"24392","UserID":"6c71b9ef-3ad0-45d8-989a-45b17e48ac0e","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null} 2025-09-24 21:21:41,367 [78] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-09-24 21:21:41,382 [78] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"136664311c9cd","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-09-24 21:21:41,382 [78] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-09-24 21:21:41,382 [78] 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: 136664311c9cd 2025-09-24 21:21:41,382 [78] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 21:21:41,382 [78] 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-09-24 21:21:41,382 [78] 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-09-24 21:24:48,960 [36] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 21:24:53,094 [36] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 21:24:57,242 [36] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 21:35:05,522 [38] 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-09-24 21:47:25,238 [28] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 21:47:39,055 [28] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-09-24 22:19:42,049 [19] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-09-24 22:19:42,049 [19] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"b66fec51a194a","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-09-24 22:19:42,049 [19] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-09-24 22:19:42,049 [19] 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: b66fec51a194a 2025-09-24 22:19:42,049 [19] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 22:19:42,049 [19] 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-09-24 22:19:42,049 [19] 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-09-24 22:47:04,127 [20] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-09-24 22:47:04,127 [20] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"a68740edd5eaa","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-09-24 22:47:04,127 [20] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-09-24 22:47:04,127 [20] 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: a68740edd5eaa 2025-09-24 22:47:04,127 [20] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 22:47:04,127 [20] 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-09-24 22:47:04,127 [20] 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-09-24 23:46:07,343 [136] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:46:07,343 [136] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_WorkOrder_FetchHistory 2025-09-24 23:46:07,343 [136] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 23:46:07,343 [136] 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.FetchWorkOrderHistory(String WorkOrderID) 2025-09-24 23:46:07,343 [136] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderHistory(String WorkOrderID) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderHistory(String WorkOrderID, String TokenID) 2025-09-24 23:46:21,381 [106] 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-09-24 23:46:21,382 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_WorkOrder_FetchHistory 2025-09-24 23:46:21,383 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 23:46:21,384 [106] 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.FetchWorkOrderHistory(String WorkOrderID) 2025-09-24 23:46:21,384 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderHistory(String WorkOrderID) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderHistory(String WorkOrderID, String TokenID) 2025-09-24 23:46:51,020 [130] 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-09-24 23:46:51,020 [130] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_WorkOrder_FetchHistory 2025-09-24 23:46:51,020 [130] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 23:46:51,020 [130] 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.FetchWorkOrderHistory(String WorkOrderID) 2025-09-24 23:46:51,020 [130] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderHistory(String WorkOrderID) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderHistory(String WorkOrderID, String TokenID) 2025-09-24 23:47:15,731 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:47:15,731 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:47:15,731 [106] 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-09-24 23:47:57,400 [106] 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-09-24 23:47:57,400 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:47:57,400 [106] 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-09-24 23:50:02,967 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:50:02,968 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-09-24 23:50:41,250 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:50:41,251 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-09-24 23:50:46,590 [19] 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-09-24 23:50:46,590 [19] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-09-24 23:50:56,647 [19] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.IsTokenValid(String tokenId) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) 2025-09-24 23:51:00,278 [104] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.UpdateWorkOrderScheduleMailSent(DataTable sentMails, String timebefore) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SendWorkOrderRemainderEmail(String timebefore) at Grid_API.ServiceLayer.GridAPIService.SendWorkOrderRemainderEmail(String timebefore) 2025-09-24 23:51:28,881 [127] 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-09-24 23:51:28,881 [127] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-09-24 23:51:32,461 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:51:32,461 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-09-24 23:52:04,255 [104] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:52:04,255 [104] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:52:04,255 [104] 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-09-24 23:52:30,959 [130] 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-09-24 23:52:30,959 [130] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:52:30,959 [130] 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-09-24 23:53:16,530 [130] 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-09-24 23:53:16,530 [130] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_FetchArtistByID 2025-09-24 23:53:16,530 [127] 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-09-24 23:53:16,530 [127] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_FetchDashBoard 2025-09-24 23:53:19,551 [131] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:53:19,551 [131] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Report_FetchRevenueSummary 2025-09-24 23:53:19,551 [131] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 23:53:19,551 [131] 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.FetchRevenueShootReport(SearchByQueryDTO searchObj) 2025-09-24 23:53:19,551 [131] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchRevenueShootReport(SearchByQueryDTO searchObj) at Grid_API.ServiceLayer.GridAPIService.FetchRevenueShootReport(SearchByQueryDTO searchObj) 2025-09-24 23:53:39,533 [120] 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-09-24 23:53:39,533 [120] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:53:39,533 [120] 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-09-24 23:53:45,383 [76] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:53:45,383 [76] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-09-24 23:53:46,305 [104] 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-09-24 23:53:46,305 [104] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:53:46,305 [104] 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-09-24 23:54:10,936 [126] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:54:10,937 [126] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:54:10,937 [126] 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-09-24 23:54:23,326 [104] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:54:23,327 [104] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:54:23,328 [104] 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-09-24 23:55:39,695 [126] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:55:39,695 [126] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-09-24 23:55:54,672 [45] 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-09-24 23:55:54,672 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:55:54,672 [45] 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-09-24 23:55:58,696 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:55:58,697 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:55:58,697 [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-09-24 23:56:03,606 [120] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-09-24 23:56:03,606 [120] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:56:04,805 [120] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Error occured: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=10; handshake=8269; 2025-09-24 23:56:04,805 [120] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - at Grid_API.Service_DataAccessLayer.UserManagementDataAccessLayer.AuthenticateUser(AuthenticationDTO userLoginDetails) at Grid_API.UserManagement_BusinessLayer.UserManagementBusinessLayer.AuthenticateUser(AuthenticationDTO userLoginDetails) at Grid_API.UserManagement_ServiceLayer.UserManagementService.AuthenticateUser(AuthenticationDTO userLoginDetails) 2025-09-24 23:56:06,812 [137] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.UpdateWorkOrderScheduleMailSent(DataTable sentMails, String timebefore) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SendWorkOrderRemainderEmail(String timebefore) at Grid_API.ServiceLayer.GridAPIService.SendWorkOrderRemainderEmail(String timebefore) 2025-09-24 23:56:07,626 [137] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.IsTokenValid(String tokenId) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) 2025-09-24 23:56:24,086 [116] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:56:24,086 [116] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:56:29,497 [126] 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-09-24 23:56:29,497 [126] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:56:29,497 [126] 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-09-24 23:57:09,398 [122] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:57:09,398 [122] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:57:13,264 [126] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:57:13,264 [126] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:57:17,554 [137] 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-09-24 23:57:17,554 [137] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:57:38,942 [76] 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-09-24 23:57:38,943 [76] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Esoft_Get_WorkOrderId_FolderId_By_BatchId 2025-09-24 23:57:43,747 [116] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:57:43,747 [116] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-09-24 23:58:02,816 [136] 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-09-24 23:58:02,816 [136] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:58:02,816 [136] 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-09-24 23:58:05,532 [11] 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-09-24 23:58:05,532 [11] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_FetchArtistByID 2025-09-24 23:58:08,523 [137] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:58:08,523 [137] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:58:13,215 [126] 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-09-24 23:58:13,215 [126] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:58:13,481 [120] 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-09-24 23:58:13,481 [120] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_FetchDashBoard 2025-09-24 23:58:17,144 [117] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:58:17,144 [117] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:58:29,100 [76] 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-09-24 23:58:29,101 [76] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Report_FetchRevenueSummary 2025-09-24 23:58:29,101 [76] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-09-24 23:58:29,101 [76] 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.FetchRevenueShootReport(SearchByQueryDTO searchObj) 2025-09-24 23:58:29,101 [76] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchRevenueShootReport(SearchByQueryDTO searchObj) at Grid_API.ServiceLayer.GridAPIService.FetchRevenueShootReport(SearchByQueryDTO searchObj) 2025-09-24 23:58:36,808 [122] 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-09-24 23:58:36,808 [122] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:58:40,405 [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-09-24 23:58:40,405 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:58:40,405 [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-09-24 23:58:45,083 [116] 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-09-24 23:58:45,083 [116] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Esoft_Get_WorkOrderId_FolderId_By_BatchId 2025-09-24 23:58:51,312 [137] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.IsTokenValid(String tokenId) at Grid_API.ServiceLayer.GridAPIService.FetchArtistByID(String artistID, String tokenID) 2025-09-24 23:58:59,795 [120] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-09-24 23:58:59,795 [120] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:59:08,982 [117] 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-09-24 23:59:08,982 [117] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:59:08,982 [117] 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-09-24 23:59:11,961 [122] 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-09-24 23:59:11,961 [122] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:59:11,962 [122] 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-09-24 23:59:33,641 [137] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:59:33,641 [137] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:59:33,860 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:59:33,860 [124] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:59:34,143 [116] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:59:34,143 [116] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:59:34,696 [76] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: 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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) 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-09-24 23:59:34,696 [76] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Calendar_FetchDetails 2025-09-24 23:59:44,413 [120] 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-09-24 23:59:44,413 [120] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Branded_FetchProperty 2025-09-24 23:59:44,413 [120] 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)