2025-04-19 11:56:06,735 [21] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-04-19 11:56:06,751 [21] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Filechest_FetchAssetsOfFolder 2025-04-19 11:57:19,786 [22] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-04-19 11:57:19,817 [22] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Filechest_FetchAssetsOfFolder 2025-04-19 12:01:44,536 [37] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-04-19 12:01:44,536 [37] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_WorkOrder_FetchHistory 2025-04-19 12:01:45,938 [37] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException 2025-04-19 12:01:49,060 [37] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderHistory(String WorkOrderID) 2025-04-19 12:01:49,513 [29] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-04-19 12:01:50,067 [29] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_Filechest_FetchAssetsOfFolder 2025-04-19 12:01:50,197 [37] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object. Stack Trace: at Houselens.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderHistory(String WorkOrderID) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderHistory(String WorkOrderID, String TokenID) 2025-04-19 12:03:46,582 [13] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-04-19 12:03:46,582 [13] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_Editors_FetchAllCompletedWorkOrders 2025-04-19 12:06:45,740 [53] ERROR Houselens.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-04-19 12:11:39,234 [11] ERROR Houselens.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-04-19 12:12:26,541 [43] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.AddUpdateData(String commandKey, SqlCommand& cmd, Boolean isReturnmsg, Boolean isStatuscode) 2025-04-19 12:12:26,541 [43] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset 2025-04-19 12:25:48,585 [5] ERROR Houselens.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-04-19 13:59:22,024 [16] ERROR Houselens.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-04-19 14:13:20,772 [56] ERROR Houselens.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-04-19 14:14:40,571 [36] ERROR Houselens.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-04-19 14:20:34,033 [51] ERROR Houselens.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-04-19 14:21:18,509 [53] ERROR Houselens.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-04-19 14:21:23,392 [29] ERROR Houselens.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-04-19 14:26:05,325 [24] ERROR Houselens.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-04-19 14:37:39,242 [44] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.AddUpdateData(String commandKey, SqlCommand& cmd, Boolean isReturnmsg, Boolean isStatuscode) 2025-04-19 14:37:39,242 [44] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset 2025-04-19 14:37:41,954 [36] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.AddUpdateData(String commandKey, SqlCommand& cmd, Boolean isReturnmsg, Boolean isStatuscode) 2025-04-19 14:37:41,954 [36] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset 2025-04-19 14:37:51,098 [70] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.AddUpdateData(String commandKey, SqlCommand& cmd, Boolean isReturnmsg, Boolean isStatuscode) 2025-04-19 14:37:51,098 [70] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset 2025-04-19 14:44:14,388 [106] ERROR Houselens.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-04-19 14:44:46,721 [106] ERROR Houselens.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-04-19 14:45:22,316 [110] ERROR Houselens.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-04-19 14:46:45,697 [112] ERROR Houselens.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-04-19 14:55:03,283 [113] ERROR Houselens.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-04-19 14:55:12,452 [113] ERROR Houselens.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-04-19 14:55:40,653 [105] ERROR Houselens.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-04-19 14:56:48,738 [75] ERROR Houselens.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-04-19 14:57:23,760 [84] ERROR Houselens.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-04-19 14:57:39,375 [12] ERROR Houselens.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-04-19 14:58:56,053 [75] ERROR Houselens.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-04-19 15:04:05,418 [13] ERROR Houselens.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-04-19 15:04:19,344 [13] ERROR Houselens.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-04-19 15:23:09,055 [91] ERROR Houselens.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-04-19 15:24:30,938 [87] ERROR Houselens.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-04-19 15:29:35,796 [15] ERROR Houselens.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-04-19 15:33:18,229 [166] ERROR Houselens.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-04-19 15:33:32,164 [167] ERROR Houselens.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-04-19 15:34:01,611 [167] ERROR Houselens.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-04-19 15:34:55,764 [160] ERROR Houselens.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-04-19 15:43:27,550 [103] ERROR Houselens.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-04-19 15:45:06,861 [143] ERROR Houselens.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-04-19 15:49:37,733 [86] ERROR Houselens.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-04-19 15:50:34,412 [40] ERROR Houselens.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-04-19 15:51:03,171 [49] ERROR Houselens.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-04-19 16:00:32,995 [56] ERROR Houselens.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-04-19 16:02:36,118 [153] ERROR Houselens.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-04-19 16:06:30,071 [156] ERROR Houselens.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-04-19 16:20:30,912 [78] ERROR Houselens.Helper.LogHelper [(null)] - Message: {"WorkOrderId":null,"StepNumber":6,"BatchId":null,"CreatedOn":"\/Date(1745079630410)\/","ResponseTime":"\/Date(1745079630912)\/","RequestBody":"{\"id\":\"745c907d-5680-4661-9d1a-d83c8e72eeab\",\"method\":\"getAssets\",\"jsonrpc\":\"2.0\",\"params\":{\"clientId\":\"50100184\",\"reference\":\"\",\"receivingCompany\":null,\"orderLines\":null,\"callbackUrl\":null,\"materialsHttp\":null,\"batchId\":70017141973}}","ResponseBody":"{\"jsonrpc\":\"2.0\",\"id\":\"745c907d-5680-4661-9d1a-d83c8e72eeab\",\"result\":{\"state\":\"ACTIVE\",\"pictures\":[],\"animatedPictures\":[],\"floorPlans\":[],\"panoramasHtml5\":[],\"panoramasFlash\":[],\"panoramasJpeg\":[],\"videos\":[],\"slideShows\":[],\"links\":[],\"copywriteTexts\":[],\"qrCodes\":[],\"interactivePresentation\":null,\"poiPresentation\":null,\"beforeAfterPictures\":[],\"beforeAfterPanoramas\":[],\"matterport\":null}}","ResponseType":"success"} 2025-04-19 16:26:23,149 [55] ERROR Houselens.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-04-19 16:36:46,119 [115] ERROR Houselens.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-04-19 16:39:37,171 [5] ERROR Houselens.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-04-19 16:40:52,459 [26] ERROR Houselens.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-04-19 16:49:16,950 [138] ERROR Houselens.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-04-19 16:53:07,757 [126] ERROR Houselens.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-04-19 16:53:20,289 [126] ERROR Houselens.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-04-19 16:53:27,842 [145] ERROR Houselens.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-04-19 16:53:36,953 [126] ERROR Houselens.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-04-19 16:57:00,604 [140] ERROR Houselens.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-04-19 17:10:41,792 [123] ERROR Houselens.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-04-19 17:10:59,164 [147] ERROR Houselens.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-04-19 17:11:22,454 [148] ERROR Houselens.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-04-19 17:11:36,030 [123] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-04-19 17:11:42,847 [40] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-04-19 17:11:50,245 [199] ERROR Houselens.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-04-19 17:16:39,996 [174] ERROR Houselens.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-04-19 17:18:48,277 [174] ERROR Houselens.Helper.LogHelper [(null)] - Message: Column 'DisplayName' does not belong to table Table. Stack Trace: at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.EditWorkOrder(AddWorkOrderDTO workOrderObj) at Grid_API.BusinessLayer.Grid_APIBusinessLayer.EditWorkOrder(AddWorkOrderDTO workOrderObj) 2025-04-19 17:21:56,003 [174] ERROR Houselens.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-04-19 18:57:17,025 [10] ERROR Houselens.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-04-19 18:59:14,985 [177] ERROR Houselens.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-04-19 19:42:13,596 [167] ERROR Houselens.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-04-19 19:59:44,926 [10] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-04-19 19:59:45,067 [10] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-04-19 22:09:56,602 [155] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Called For Order 13378 2025-04-19 22:09:56,602 [155] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Response For Order 13378 :BadRequest 2025-04-19 22:09:56,602 [155] ERROR Houselens.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"homesbyjosephine1@gmail.com","PrismUserID":"jrich","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"13378","UserID":"e6850edb-75fb-46ff-9a99-eb02e9827f21","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null} 2025-04-19 22:09:59,996 [133] ERROR Houselens.Helper.LogHelper [(null)] - Message: An explicit value for the identity column in table '@tempTable' can only be specified when a column list is used and IDENTITY_INSERT is ON. 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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-04-19 22:09:59,996 [133] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_ExternalUser_GetOrders 2025-04-19 22:10:01,125 [133] ERROR Houselens.Helper.LogHelper [(null)] - Message: An explicit value for the identity column in table '@tempTable' can only be specified when a column list is used and IDENTITY_INSERT is ON. 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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus) 2025-04-19 22:10:01,125 [133] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_ExternalUser_GetOrders 2025-04-19 22:46:55,309 [29] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-04-19 23:42:02,449 [172] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-04-20 00:12:15,262 [100] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: aac9c198-44c0-4b74-a626-589200b6ad7c 2025-04-20 00:12:17,917 [100] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: af52d50f-d29f-4c32-a90b-ecffb34013c3 2025-04-20 01:45:40,096 [99] ERROR Houselens.Helper.LogHelper [(null)] - Message: Value cannot be null. Parameter name: input Stack Trace: at System.Guid.Parse(String input) at Houselens.Service_DataAccessLayer.DAMSDataAccessLayer.<>c.b__9_0(AssetDTO i) at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext() at System.Xml.Linq.XContainer.AddContentSkipNotify(Object content) at Houselens.Service_DataAccessLayer.DAMSDataAccessLayer.UpdateAssetRanking(AssetListDTO assetRankObj) 2025-04-20 01:45:40,096 [99] ERROR Houselens.Helper.LogHelper [(null)] - Message: at System.Guid.Parse(String input) at Houselens.Service_DataAccessLayer.DAMSDataAccessLayer.<>c.b__9_0(AssetDTO i) at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext() at System.Xml.Linq.XContainer.AddContentSkipNotify(Object content) at Houselens.Service_DataAccessLayer.DAMSDataAccessLayer.UpdateAssetRanking(AssetListDTO assetRankObj) Stack Trace: 2025-04-20 03:46:55,529 [174] ERROR Houselens.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-04-20 03:48:31,358 [96] ERROR Houselens.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-04-20 03:49:04,313 [96] ERROR Houselens.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-04-20 03:49:24,827 [96] ERROR Houselens.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-04-20 12:45:01,218 [96] ERROR Houselens.Helper.LogHelper [(null)] - Message: Generating weekly invoice on: 20250420 12:45:01.218 2025-04-20 12:55:00,543 [96] ERROR Houselens.Helper.LogHelper [(null)] - Message: Sending weekly invoice on: 20250420 12:55:00.543 2025-04-20 14:00:00,852 [21] ERROR Houselens.Helper.LogHelper [(null)] - Message: Generating weekly invoice on: 20250420 14:00:00.852 2025-04-20 14:10:00,877 [29] ERROR Houselens.Helper.LogHelper [(null)] - Message: Sending weekly invoice on: 20250420 14:10:00.877 2025-04-20 16:31:41,680 [159] ERROR Houselens.Helper.LogHelper [(null)] - Message: Value cannot be null. Parameter name: g Stack Trace: at System.Guid..ctor(String g) at Houselens.Service_DataAccessLayer.CalenderDataAccessLayer.UpdateCalendarDetails(CalendarDTO appointments)