2025-07-15 15:36:46,294 [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-07-15 15:40:34,721 [113] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 20844

2025-07-15 15:40:34,721 [113] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 20844 :BadRequest

2025-07-15 15:40:34,721 [113] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"jnaame@weichertrealtors.net","PrismUserID":"Jnaame","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"20844","UserID":"b7c34c23-2952-435d-975f-1595e5232660","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-07-15 15:43:48,861 [113] 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-07-15 15:43:48,861 [113] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 15:43:49,262 [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-07-15 15:44:28,007 [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-07-15 15:45:58,090 [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-07-15 15:47:17,528 [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-07-15 15:49:12,757 [55] 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-07-15 15:49:29,784 [15] 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-07-15 15:49:29,784 [15] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 15:51:56,495 [8] 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-07-15 15:56:05,217 [29] 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-07-15 15:57:41,189 [11] 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-07-15 15:59:32,590 [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-07-15 16:00:34,978 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly.
Stack Trace:    at System.Net.HttpWebRequest.GetResponse()
   at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url)
2025-07-15 16:01:56,439 [91] 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-07-15 16:02:14,714 [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-07-15 16:03:16,736 [35] 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-07-15 16:03:16,736 [35] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 16:03:27,673 [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-07-15 16:15:33,249 [54] 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-07-15 16:16:29,675 [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-07-15 16:17:51,427 [48] 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-07-15 16:17:51,427 [48] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 16:17:51,427 [48] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 16:18:01,805 [89] 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-07-15 16:18:01,805 [89] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 16:18:01,805 [89] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 16:18:05,900 [99] 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-07-15 16:18:05,900 [99] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 16:18:11,065 [52] 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-07-15 16:18:11,065 [52] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 16:20:51,053 [89] 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-07-15 16:20:54,363 [36] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 16:20:54,378 [89] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 16:20:59,739 [89] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 16:20:59,739 [36] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 16:21:01,979 [89] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 19819

2025-07-15 16:21:01,979 [89] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 19819 :OK

2025-07-15 16:21:01,979 [89] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"michelle.smith@weichert.com","PrismUserID":"michellesmith","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fe7cef270-4768-4520-fd6f-f38fd8969a59.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb2ac0f51-a5db-4a6f-ba78-7e83f0489ff3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F277e34b8-41f3-415d-a3e1-9fe68dc43333.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F265e0c35-14a2-4442-e954-bd0dd95a73b5.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2b082e98-cb24-41e1-8270-26955be31896.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Facdfc3ef-1d74-4afd-d7a7-2d67873af28c.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3d1cc1f5-6b97-4494-ddf6-47575efa0fc3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9104526c-2c01-4625-e70d-ad9ad51b185d.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2ee392ed-2737-49f6-c8fa-ac49405e87e4.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5e357a7a-3278-4762-e689-eb8c79ae0e4e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F14e7c155-40fd-43cf-aae9-4f0be9209cb0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5926550f-c137-4e98-a82e-ca57988cd128.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fcf1f9e66-c10a-4553-bf60-4d95104fb47e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5b217ef4-aa41-46e6-8b4a-45eacfc23d01.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4678b471-f327-4942-fff0-d0bb446ae837.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2802f521-c500-4e8e-b70e-a6234f475739.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ffd4ab451-939b-46d6-e368-692118416dac.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F1162463a-ecde-46a9-8f62-8c4bb90bb195.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F7d3f48cc-f864-41a5-b392-d149d7420af2.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F26a990f4-7026-4702-d18b-7a6e0bf6223f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3b80d798-03a7-40b0-e136-f6692e8add49.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9a38916c-e0e4-4f06-fb03-10faa195a088.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F50f1a52f-dbee-4e24-89d3-06bd6ae9c908.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F691ec621-3c09-4b9a-a1a0-d0a6927daaf0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5364969d-7b4f-4d1f-ead7-f11c1a54b9c4.jpg"],"ListingWebsite":"","PropertyAddress":"205 Lindsey Avenue, Runnemede, NJ, USA 08078","PropertyCity":"Runnemede","PropertyState":"NJ","PropertyZIP":"08078","Price":null,"SquareFeet":"1600","ListingID":"19819","UserID":"c588035e-9243-4ed8-8794-b0b0b3f92d49","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":""}

2025-07-15 16:21:05,334 [36] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 16:21:05,334 [43] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 16:22:51,574 [43] 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-07-15 16:22:51,574 [43] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 16:26:43,025 [108] 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-07-15 16:28:00,391 [108] 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-07-15 16:29:55,865 [90] 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-07-15 16:29:55,865 [90] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-07-15 16:29:55,865 [90] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-07-15 16:29:55,865 [90] 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-07-15 16:29:55,865 [90] 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-07-15 16:29:55,990 [90] 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-07-15 16:29:55,990 [90] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-07-15 16:29:55,990 [90] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-07-15 16:29:55,990 [90] 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-07-15 16:29:55,990 [90] 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-07-15 16:30:02,993 [90] 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-07-15 16:30:02,993 [90] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-07-15 16:30:02,993 [90] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-07-15 16:30:02,993 [90] 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-07-15 16:30:02,993 [90] 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-07-15 16:30:16,528 [108] 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-07-15 16:32:05,240 [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-07-15 16:32:52,858 [46] 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-07-15 16:32:52,858 [46] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 16:34:36,235 [46] 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-07-15 16:34:36,235 [46] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 16:35:11,904 [61] 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-07-15 16:35:11,904 [61] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 16:51:38,716 [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-07-15 16:52:59,864 [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-07-15 17:06:15,500 [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-07-15 17:07:41,567 [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-07-15 17:08:43,336 [108] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 17:12:33,726 [124] 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-07-15 17:14:36,293 [102] 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-07-15 17:14:36,293 [102] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 17:16:36,147 [40] 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-07-15 17:16:39,721 [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-07-15 17:20:22,103 [107] 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-07-15 17:20:22,103 [107] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 17:20:25,905 [58] 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-07-15 17:20:25,905 [58] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 17:21:27,619 [58] 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-07-15 17:21:27,619 [58] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 17:21:56,248 [29] 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-07-15 17:21:56,248 [29] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 17:23:10,598 [97] 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-07-15 17:23:10,598 [97] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 17:25:31,602 [15] 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-07-15 17:25:31,602 [15] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 17:25:55,583 [104] 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-07-15 17:26:24,759 [104] 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-07-15 17:27:42,372 [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-07-15 17:31:49,723 [96] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 17:31:49,882 [85] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 17:31:54,308 [38] 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-07-15 17:31:54,323 [38] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 17:32:01,928 [67] 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-07-15 17:32:01,928 [67] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 17:32:11,874 [85] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 17:32:17,476 [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-07-15 17:32:57,328 [85] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 17:33:36,642 [85] 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-07-15 17:47:54,409 [63] 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-07-15 17:48:43,389 [13] 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-07-15 17:48:43,389 [13] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 17:50:27,269 [13] 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-07-15 17:50:27,269 [13] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 17:51:28,618 [13] 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-07-15 17:51:28,618 [13] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 17:55:22,283 [55] 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-07-15 17:59:22,134 [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-07-15 18:10:08,942 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-07-15 18:10:08,942 [34] 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.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.DataAccessLayer.Grid_APIDataAccessLayer.SaveInvoiceAdditionalItems(InvoiceAdditionalItems invoiceAdditionalItemsObj)
2025-07-15 18:10:08,942 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Error converting data type nvarchar to uniqueidentifier.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SaveInvoiceAdditionalItems(InvoiceAdditionalItems invoiceAdditionalItemsObj)
   at Grid_API.ServiceLayer.GridAPIService.SaveInvoiceAdditionalItems(InvoiceAdditionalItems invoiceAdditionalItemsObj)
2025-07-15 18:10:58,297 [95] 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-07-15 18:10:58,297 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-07-15 18:10:58,297 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-07-15 18:10:58,297 [95] 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-07-15 18:10:58,297 [95] 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-07-15 18:10:58,422 [95] 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-07-15 18:10:58,422 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-07-15 18:10:58,422 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException

2025-07-15 18:10:58,438 [95] 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-07-15 18:10:58,438 [95] 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-07-15 18:13:02,462 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:02,462 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: SQLException

2025-07-15 18:13:02,462 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:02,462 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string to uniqueidentifier.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
   at Grid_API.ServiceLayer.GridAPIService.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:05,777 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:05,777 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: SQLException

2025-07-15 18:13:05,777 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:05,777 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string to uniqueidentifier.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
   at Grid_API.ServiceLayer.GridAPIService.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:08,461 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:08,461 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: SQLException

2025-07-15 18:13:08,461 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:08,461 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string to uniqueidentifier.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
   at Grid_API.ServiceLayer.GridAPIService.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:09,304 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:09,304 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: SQLException

2025-07-15 18:13:09,304 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:13:09,304 [45] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string to uniqueidentifier.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
   at Grid_API.ServiceLayer.GridAPIService.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:24:56,137 [110] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:24:56,137 [110] ERROR Grid_API.Helper.LogHelper [(null)] - Message: SQLException

2025-07-15 18:24:56,137 [110] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:24:56,137 [110] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string to uniqueidentifier.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
   at Grid_API.ServiceLayer.GridAPIService.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:24:57,223 [110] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:24:57,223 [110] ERROR Grid_API.Helper.LogHelper [(null)] - Message: SQLException

2025-07-15 18:24:57,223 [110] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string 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.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   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(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:24:57,223 [110] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Conversion failed when converting from a character string to uniqueidentifier.
Stack Trace:    at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
   at Grid_API.ServiceLayer.GridAPIService.InvoiceSearchProperty(InvoiceSearchCriteria invoiceSearchCriteriaObj)
2025-07-15 18:28:14,877 [96] 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-07-15 18:28:53,251 [96] 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-07-15 18:29:51,568 [14] 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-07-15 18:29:51,568 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 18:29:51,568 [14] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 18:30:02,026 [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-07-15 18:31:53,317 [59] 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-07-15 18:31:53,317 [59] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 18:31:53,317 [59] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 18:32:13,516 [68] 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-07-15 18:32:13,516 [68] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 18:32:13,516 [68] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 18:32:13,672 [34] 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-07-15 18:32:13,672 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 18:32:13,672 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 18:33:30,847 [89] 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-07-15 18:35:43,934 [59] 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-07-15 18:35:43,934 [59] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 18:41:14,891 [102] 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-07-15 18:51:08,880 [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-07-15 18:53:47,704 [72] 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-07-15 18:55:27,827 [64] 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-07-15 18:55:27,827 [64] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 18:56:36,374 [54] 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-07-15 18:56:36,374 [54] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 18:56:36,374 [54] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 18:56:53,324 [38] 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-07-15 18:56:53,324 [38] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 18:58:48,850 [30] 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-07-15 18:58:53,537 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 19819

2025-07-15 18:58:53,537 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 19819 :OK

2025-07-15 18:58:53,537 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"michelle.smith@weichert.com","PrismUserID":"michellesmith","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fe7cef270-4768-4520-fd6f-f38fd8969a59.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb2ac0f51-a5db-4a6f-ba78-7e83f0489ff3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F277e34b8-41f3-415d-a3e1-9fe68dc43333.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F265e0c35-14a2-4442-e954-bd0dd95a73b5.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2b082e98-cb24-41e1-8270-26955be31896.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Facdfc3ef-1d74-4afd-d7a7-2d67873af28c.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3d1cc1f5-6b97-4494-ddf6-47575efa0fc3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9104526c-2c01-4625-e70d-ad9ad51b185d.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2ee392ed-2737-49f6-c8fa-ac49405e87e4.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5e357a7a-3278-4762-e689-eb8c79ae0e4e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F14e7c155-40fd-43cf-aae9-4f0be9209cb0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5926550f-c137-4e98-a82e-ca57988cd128.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fcf1f9e66-c10a-4553-bf60-4d95104fb47e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5b217ef4-aa41-46e6-8b4a-45eacfc23d01.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4678b471-f327-4942-fff0-d0bb446ae837.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2802f521-c500-4e8e-b70e-a6234f475739.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ffd4ab451-939b-46d6-e368-692118416dac.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F1162463a-ecde-46a9-8f62-8c4bb90bb195.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F7d3f48cc-f864-41a5-b392-d149d7420af2.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F26a990f4-7026-4702-d18b-7a6e0bf6223f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3b80d798-03a7-40b0-e136-f6692e8add49.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9a38916c-e0e4-4f06-fb03-10faa195a088.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F50f1a52f-dbee-4e24-89d3-06bd6ae9c908.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F691ec621-3c09-4b9a-a1a0-d0a6927daaf0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5364969d-7b4f-4d1f-ead7-f11c1a54b9c4.jpg"],"ListingWebsite":"","PropertyAddress":"205 Lindsey Avenue, Runnemede, NJ, USA 08078","PropertyCity":"Runnemede","PropertyState":"NJ","PropertyZIP":"08078","Price":null,"SquareFeet":"1600","ListingID":"19819","UserID":"c588035e-9243-4ed8-8794-b0b0b3f92d49","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":""}

2025-07-15 19:00:11,744 [70] 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-07-15 19:00:11,744 [70] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 19:00:11,744 [70] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 19:28:02,515 [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-07-15 19:35:44,989 [35] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 19:40:37,709 [105] 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-07-15 19:47:03,409 [69] 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-07-15 20:03:25,397 [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-07-15 20:05:18,327 [53] 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-07-15 20:05:18,327 [53] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 20:05:18,327 [53] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 20:05:31,940 [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-07-15 20:05:31,941 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 20:05:31,941 [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.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 20:05:32,152 [51] 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-07-15 20:05:32,152 [51] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 20:05:32,153 [51] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 20:05:37,579 [44] 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-07-15 20:05:37,579 [44] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 20:16:47,585 [18] 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-07-15 20:16:47,585 [18] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 20:16:47,585 [18] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 20:20:29,283 [17] 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-07-15 20:20:46,265 [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-07-15 20:20:46,265 [106] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 20:20:46,265 [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.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 20:20:46,343 [46] 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-07-15 20:20:46,343 [46] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Tours_FetchTourListing

2025-07-15 20:20:46,343 [46] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String UserID)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderTourDetails(String ClientID, String artitFirmID, String searchInput, String agentID, String operation, String brokerageFirmId, String tokenID, String UserID)
2025-07-15 20:39:18,153 [47] 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-07-15 21:08:16,681 [88] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 21:08:16,681 [13] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 21:08:22,430 [13] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 21:08:22,445 [88] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 21:52:43,963 [18] 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-07-15 21:53:19,864 [10] 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-07-15 21:53:19,864 [10] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 21:53:24,854 [50] 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-07-15 21:53:26,587 [50] ERROR Grid_API.Helper.LogHelper [(null)] - Message: ===============================================
inside from imagenai
WorkorderId from imagenai: e6c2255e-537b-4dec-b0aa-d8c8c13b4cc1

2025-07-15 21:53:26,759 [50] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Profile : HouseLens_AIProfile_RAW_031723

2025-07-15 21:53:26,790 [50] ERROR Grid_API.Helper.LogHelper [(null)] - Message: projectUuid from imagenai: 6876cdd710d9cda6b54e1af2

2025-07-15 21:53:27,649 [50] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Raw image count: 157

2025-07-15 21:53:53,666 [9] 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-07-15 21:53:53,666 [9] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 21:53:57,445 [37] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Upload image done from imagenai

2025-07-15 21:53:57,461 [37] ERROR Grid_API.Helper.LogHelper [(null)] - Message: SendProjectForEdit done from imagenai

2025-07-15 21:56:55,195 [9] 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-07-15 21:57:55,244 [9] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 19819

2025-07-15 21:57:55,244 [9] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 19819 :OK

2025-07-15 21:57:55,244 [9] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"michelle.smith@weichert.com","PrismUserID":"michellesmith","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fe7cef270-4768-4520-fd6f-f38fd8969a59.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb2ac0f51-a5db-4a6f-ba78-7e83f0489ff3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F277e34b8-41f3-415d-a3e1-9fe68dc43333.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F265e0c35-14a2-4442-e954-bd0dd95a73b5.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2b082e98-cb24-41e1-8270-26955be31896.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Facdfc3ef-1d74-4afd-d7a7-2d67873af28c.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3d1cc1f5-6b97-4494-ddf6-47575efa0fc3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9104526c-2c01-4625-e70d-ad9ad51b185d.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2ee392ed-2737-49f6-c8fa-ac49405e87e4.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5e357a7a-3278-4762-e689-eb8c79ae0e4e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F14e7c155-40fd-43cf-aae9-4f0be9209cb0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5926550f-c137-4e98-a82e-ca57988cd128.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fcf1f9e66-c10a-4553-bf60-4d95104fb47e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5b217ef4-aa41-46e6-8b4a-45eacfc23d01.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4678b471-f327-4942-fff0-d0bb446ae837.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2802f521-c500-4e8e-b70e-a6234f475739.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ffd4ab451-939b-46d6-e368-692118416dac.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F1162463a-ecde-46a9-8f62-8c4bb90bb195.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F7d3f48cc-f864-41a5-b392-d149d7420af2.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F26a990f4-7026-4702-d18b-7a6e0bf6223f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3b80d798-03a7-40b0-e136-f6692e8add49.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9a38916c-e0e4-4f06-fb03-10faa195a088.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F50f1a52f-dbee-4e24-89d3-06bd6ae9c908.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F691ec621-3c09-4b9a-a1a0-d0a6927daaf0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5364969d-7b4f-4d1f-ead7-f11c1a54b9c4.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4ba43bc3-0c7a-4f48-a7dd-fc5a7384e40c.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9ceaa79b-3fa5-45ed-935f-ba9c705128a8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F8da6cbd3-15f2-48de-9c8c-88d27cf58837.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F6a7127fc-1bb1-4f99-8dc4-fce3a02215c7.jpg"],"ListingWebsite":"","PropertyAddress":"205 Lindsey Avenue, Runnemede, NJ, USA 08078","PropertyCity":"Runnemede","PropertyState":"NJ","PropertyZIP":"08078","Price":null,"SquareFeet":"1600","ListingID":"19819","UserID":"c588035e-9243-4ed8-8794-b0b0b3f92d49","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":""}

2025-07-15 21:58:07,813 [18] 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-07-15 21:58:07,813 [18] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 21:58:29,626 [18] 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-07-15 21:59:08,318 [91] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 19819

2025-07-15 21:59:08,318 [91] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 19819 :OK

2025-07-15 21:59:08,318 [91] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"michelle.smith@weichert.com","PrismUserID":"michellesmith","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fe7cef270-4768-4520-fd6f-f38fd8969a59.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb2ac0f51-a5db-4a6f-ba78-7e83f0489ff3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F277e34b8-41f3-415d-a3e1-9fe68dc43333.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F265e0c35-14a2-4442-e954-bd0dd95a73b5.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2b082e98-cb24-41e1-8270-26955be31896.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Facdfc3ef-1d74-4afd-d7a7-2d67873af28c.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3d1cc1f5-6b97-4494-ddf6-47575efa0fc3.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9104526c-2c01-4625-e70d-ad9ad51b185d.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2ee392ed-2737-49f6-c8fa-ac49405e87e4.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5e357a7a-3278-4762-e689-eb8c79ae0e4e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F14e7c155-40fd-43cf-aae9-4f0be9209cb0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5926550f-c137-4e98-a82e-ca57988cd128.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fcf1f9e66-c10a-4553-bf60-4d95104fb47e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5b217ef4-aa41-46e6-8b4a-45eacfc23d01.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4678b471-f327-4942-fff0-d0bb446ae837.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2802f521-c500-4e8e-b70e-a6234f475739.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ffd4ab451-939b-46d6-e368-692118416dac.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F1162463a-ecde-46a9-8f62-8c4bb90bb195.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F7d3f48cc-f864-41a5-b392-d149d7420af2.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F26a990f4-7026-4702-d18b-7a6e0bf6223f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3b80d798-03a7-40b0-e136-f6692e8add49.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9a38916c-e0e4-4f06-fb03-10faa195a088.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F50f1a52f-dbee-4e24-89d3-06bd6ae9c908.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F691ec621-3c09-4b9a-a1a0-d0a6927daaf0.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5364969d-7b4f-4d1f-ead7-f11c1a54b9c4.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9ceaa79b-3fa5-45ed-935f-ba9c705128a8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F6a7127fc-1bb1-4f99-8dc4-fce3a02215c7.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4ba43bc3-0c7a-4f48-a7dd-fc5a7384e40c.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F8da6cbd3-15f2-48de-9c8c-88d27cf58837.jpg"],"ListingWebsite":"","PropertyAddress":"205 Lindsey Avenue, Runnemede, NJ, USA 08078","PropertyCity":"Runnemede","PropertyState":"NJ","PropertyZIP":"08078","Price":null,"SquareFeet":"1600","ListingID":"19819","UserID":"c588035e-9243-4ed8-8794-b0b0b3f92d49","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":""}

2025-07-15 22:01:10,726 [102] 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-07-15 22:01:10,727 [102] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders

2025-07-15 22:01:55,161 [18] 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-07-15 22:02:40,338 [95] 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-07-15 22:02:40,338 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 22:03:14,334 [26] 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-07-15 22:03:14,334 [26] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 22:04:06,654 [141] 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-07-15 22:04:06,654 [141] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 22:07:40,585 [132] 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-07-15 22:09:57,874 [119] 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-07-15 22:15:03,307 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 358c93e1-1160-48a4-98bd-9cd5d67dbf55

2025-07-15 22:15:16,822 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 9c0bd564-9b4e-44be-a5b5-a4b4f1e9aee2

2025-07-15 22:15:23,678 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 0212155d-b5ee-4ef2-ae34-dc3f2b6b082a

2025-07-15 22:25:37,677 [128] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: e1afd385-b5d7-4873-87a4-a4e001257511

2025-07-15 22:29:23,475 [24] ERROR Grid_API.Helper.LogHelper [(null)] - Message: inside imagenai callback, projectid: 6876cdd710d9cda6b54e1af2, status: Completed, action: edit

2025-07-15 22:29:23,913 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: number of edited picture: 71

2025-07-15 22:29:23,928 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: clientFolderId: 9363ceed-6faa-464a-b42b-d946bc5e4687

2025-07-15 22:29:27,721 [84] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1777.dng

2025-07-15 22:29:31,091 [20] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1778-HDR.dng

2025-07-15 22:29:33,529 [42] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1784-HDR.dng

2025-07-15 22:29:35,651 [115] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1787-HDR.dng

2025-07-15 22:29:38,117 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1790-HDR.dng

2025-07-15 22:29:40,332 [36] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1793-HDR.dng

2025-07-15 22:29:42,962 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1796-HDR.dng

2025-07-15 22:29:45,373 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1799-HDR.dng

2025-07-15 22:29:47,727 [48] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1802-HDR.dng

2025-07-15 22:29:49,953 [67] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1808-HDR.dng

2025-07-15 22:29:53,184 [100] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1811-HDR.dng

2025-07-15 22:29:55,600 [49] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1814-HDR.dng

2025-07-15 22:29:57,751 [42] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1817-HDR.dng

2025-07-15 22:30:00,099 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1820-HDR.dng

2025-07-15 22:30:02,166 [115] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1823-HDR.dng

2025-07-15 22:30:04,519 [20] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1826-HDR.dng

2025-07-15 22:30:06,559 [100] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1829-HDR.dng

2025-07-15 22:30:08,877 [100] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1832-HDR.dng

2025-07-15 22:30:11,071 [8] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1835-HDR.dng

2025-07-15 22:30:14,051 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1838-HDR.dng

2025-07-15 22:30:16,266 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1841-HDR.dng

2025-07-15 22:30:18,825 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1844-HDR.dng

2025-07-15 22:30:21,354 [115] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1847-HDR.dng

2025-07-15 22:30:24,159 [115] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1850-HDR.dng

2025-07-15 22:30:26,578 [8] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1853-HDR.dng

2025-07-15 22:30:29,217 [115] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1856-HDR.dng

2025-07-15 22:30:31,792 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1859-HDR.dng

2025-07-15 22:30:34,564 [67] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1862-HDR.dng

2025-07-15 22:30:37,355 [67] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1865-HDR.dng

2025-07-15 22:30:40,071 [42] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1871-HDR.dng

2025-07-15 22:30:42,854 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1877-HDR.dng

2025-07-15 22:30:45,889 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1880-HDR.dng

2025-07-15 22:30:48,926 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1883-HDR.dng

2025-07-15 22:30:51,389 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1886-HDR.dng

2025-07-15 22:30:54,548 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1889-HDR.dng

2025-07-15 22:30:57,501 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1892-HDR.dng

2025-07-15 22:31:00,581 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1895-HDR.dng

2025-07-15 22:31:03,023 [8] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1898-HDR.dng

2025-07-15 22:31:05,691 [84] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1901.dng

2025-07-15 22:31:08,372 [36] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1902.dng

2025-07-15 22:31:11,376 [20] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1903.dng

2025-07-15 22:31:14,124 [99] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1904.dng

2025-07-15 22:31:17,007 [49] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1905.dng

2025-07-15 22:31:19,576 [49] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1906.dng

2025-07-15 22:31:22,432 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1907.dng

2025-07-15 22:31:25,397 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1908.dng

2025-07-15 22:31:28,237 [42] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1909.dng

2025-07-15 22:31:31,279 [100] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1910.dng

2025-07-15 22:31:34,619 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1911.dng

2025-07-15 22:31:37,628 [84] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1912.dng

2025-07-15 22:31:40,472 [67] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1913.dng

2025-07-15 22:31:43,480 [20] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1914.dng

2025-07-15 22:31:46,831 [84] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1915.dng

2025-07-15 22:31:49,772 [84] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1916.dng

2025-07-15 22:31:52,531 [36] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1917.dng

2025-07-15 22:31:55,424 [42] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1918.dng

2025-07-15 22:31:57,933 [69] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1919.dng

2025-07-15 22:32:00,870 [69] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1920.dng

2025-07-15 22:32:04,258 [36] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1921.dng

2025-07-15 22:32:07,184 [100] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1922.dng

2025-07-15 22:32:09,970 [95] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1923.dng

2025-07-15 22:32:12,739 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1924.dng

2025-07-15 22:32:15,752 [83] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1925.dng

2025-07-15 22:32:19,338 [42] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1926.dng

2025-07-15 22:32:22,316 [138] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1927.dng

2025-07-15 22:32:25,490 [69] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1928.dng

2025-07-15 22:32:28,372 [88] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1929.dng

2025-07-15 22:32:32,379 [49] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1930.dng

2025-07-15 22:32:34,856 [20] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1931.dng

2025-07-15 22:32:37,975 [8] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1932.dng

2025-07-15 22:32:40,912 [42] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1933.dng

2025-07-15 22:33:41,052 [85] ERROR Grid_API.Helper.LogHelper [(null)] - Message: inside imagenai callback, projectid: 6876cdd710d9cda6b54e1af2, status: Completed, action: export

2025-07-15 22:33:41,274 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: number of exported picture: 71

2025-07-15 22:33:41,290 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: clientFolderId: 9363ceed-6faa-464a-b42b-d946bc5e4687

2025-07-15 22:33:42,727 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1777.jpg

2025-07-15 22:33:44,125 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1778-HDR.jpg

2025-07-15 22:33:45,552 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1784-HDR.jpg

2025-07-15 22:33:47,100 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1787-HDR.jpg

2025-07-15 22:33:48,511 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1790-HDR.jpg

2025-07-15 22:33:49,990 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1793-HDR.jpg

2025-07-15 22:33:51,681 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1796-HDR.jpg

2025-07-15 22:33:53,731 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1799-HDR.jpg

2025-07-15 22:33:55,252 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1802-HDR.jpg

2025-07-15 22:33:56,588 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1808-HDR.jpg

2025-07-15 22:33:57,933 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1811-HDR.jpg

2025-07-15 22:33:59,231 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1814-HDR.jpg

2025-07-15 22:34:00,762 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1817-HDR.jpg

2025-07-15 22:34:02,071 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1820-HDR.jpg

2025-07-15 22:34:03,414 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1823-HDR.jpg

2025-07-15 22:34:04,867 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1826-HDR.jpg

2025-07-15 22:34:06,333 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1829-HDR.jpg

2025-07-15 22:34:07,689 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1832-HDR.jpg

2025-07-15 22:34:09,056 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1835-HDR.jpg

2025-07-15 22:34:10,309 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1838-HDR.jpg

2025-07-15 22:34:11,621 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1841-HDR.jpg

2025-07-15 22:34:12,968 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1844-HDR.jpg

2025-07-15 22:34:14,250 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1847-HDR.jpg

2025-07-15 22:34:15,773 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1850-HDR.jpg

2025-07-15 22:34:17,295 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1853-HDR.jpg

2025-07-15 22:34:18,733 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1856-HDR.jpg

2025-07-15 22:34:20,239 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1859-HDR.jpg

2025-07-15 22:34:21,762 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1862-HDR.jpg

2025-07-15 22:34:23,281 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1865-HDR.jpg

2025-07-15 22:34:24,714 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1871-HDR.jpg

2025-07-15 22:34:26,190 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1877-HDR.jpg

2025-07-15 22:34:27,768 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1880-HDR.jpg

2025-07-15 22:34:29,015 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1883-HDR.jpg

2025-07-15 22:34:30,351 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1886-HDR.jpg

2025-07-15 22:34:31,772 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1889-HDR.jpg

2025-07-15 22:34:33,233 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1892-HDR.jpg

2025-07-15 22:34:34,558 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1895-HDR.jpg

2025-07-15 22:34:35,847 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1898-HDR.jpg

2025-07-15 22:34:36,878 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1901.jpg

2025-07-15 22:34:39,243 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1902.jpg

2025-07-15 22:34:40,449 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1903.jpg

2025-07-15 22:34:41,654 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1904.jpg

2025-07-15 22:34:42,750 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1905.jpg

2025-07-15 22:34:43,934 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1906.jpg

2025-07-15 22:34:45,137 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1907.jpg

2025-07-15 22:34:46,255 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1908.jpg

2025-07-15 22:34:47,379 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1909.jpg

2025-07-15 22:34:48,740 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1910.jpg

2025-07-15 22:34:49,927 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1911.jpg

2025-07-15 22:34:51,888 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1912.jpg

2025-07-15 22:34:53,378 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1913.jpg

2025-07-15 22:34:54,737 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1914.jpg

2025-07-15 22:34:56,114 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1915.jpg

2025-07-15 22:34:57,504 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1916.jpg

2025-07-15 22:34:59,058 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1917.jpg

2025-07-15 22:35:00,508 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1918.jpg

2025-07-15 22:35:02,005 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1919.jpg

2025-07-15 22:35:03,139 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1920.jpg

2025-07-15 22:35:04,180 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1921.jpg

2025-07-15 22:35:05,253 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1922.jpg

2025-07-15 22:35:06,302 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1923.jpg

2025-07-15 22:35:07,351 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1924.jpg

2025-07-15 22:35:08,368 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1925.jpg

2025-07-15 22:35:09,408 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1926.jpg

2025-07-15 22:35:10,408 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1927.jpg

2025-07-15 22:35:11,352 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1928.jpg

2025-07-15 22:35:13,453 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1929.jpg

2025-07-15 22:35:14,796 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1930.jpg

2025-07-15 22:35:16,210 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1931.jpg

2025-07-15 22:35:17,413 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1932.jpg

2025-07-15 22:35:19,316 [105] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Add files success for:IMG_1933.jpg

2025-07-15 22:38:01,403 [36] 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-07-15 22:38:01,403 [36] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-15 22:46:09,654 [61] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 1fb1db7a-3e69-49fa-a409-55a1227daf33

2025-07-15 23:30:30,301 [151] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 23:40:09,305 [149] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 23:40:09,305 [179] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-15 23:45:40,958 [168] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: fb7dbf9a-c6cb-4b92-881a-ab66da9b64d6

2025-07-16 00:04:45,738 [5] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 966f5aa7-071c-4581-9c3a-4bf4457e65d4

2025-07-16 00:04:47,886 [5] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 1d06ec0a-30af-43f2-b1dd-83bbe46cddb7

2025-07-16 00:04:49,663 [5] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: c5c9d14c-6f52-447b-ba87-a1483444c3a5

2025-07-16 00:57:33,020 [128] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-16 00:57:41,250 [128] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-16 01:04:51,734 [118] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-16 01:04:51,843 [118] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-16 01:10:09,058 [67] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-07-16 01:25:06,597 [198] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 15feaee8-56b4-4919-b757-554a0584f10c

2025-07-16 01:25:09,554 [198] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 84d0cb9f-c7e5-4396-85b6-9d5646082f56

2025-07-16 01:25:11,622 [198] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 1c5b2891-ddc0-45dd-be9b-d1218aec06b2

2025-07-16 01:25:14,168 [198] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: aec872b6-4b9e-4e1c-afb6-a707401c278d

2025-07-16 01:25:16,180 [198] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 15d8a643-552f-4bd3-88ec-07c3a47e2bf8

2025-07-16 01:25:18,095 [198] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 173ce402-ce1e-4bb7-aca0-c7b314ed591a

2025-07-16 01:36:36,687 [184] 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-07-16 01:36:36,687 [184] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-07-16 02:16:31,964 [193] 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-07-16 02:16:31,964 [193] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders