2025-05-28 15:10:43,626 [13] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: 3a8e5bf8-d5e8-4cca-832f-d5dfebd7ffda

2025-05-28 15:12:09,737 [69] 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-05-28 15:13:43,380 [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-05-28 15:18:04,153 [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-05-28 15:21:55,338 [69] 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-05-28 15:27:29,292 [99] 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-05-28 15:27:33,785 [99] 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-05-28 15:28:26,531 [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-05-28 15:31:36,648 [57] 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-05-28 15:31:53,331 [57] 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-05-28 15:31:58,433 [65] 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-05-28 15:44:01,407 [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-05-28 15:49:02,133 [95] 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-05-28 15:49:19,448 [116] 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-05-28 15:49:32,691 [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-05-28 15:49:56,820 [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-05-28 16:04:51,585 [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-05-28 16:04:55,356 [157] 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-05-28 16:05:17,572 [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-05-28 16:09:53,604 [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-05-28 16:20:54,111 [64] 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-05-28 16:21:44,728 [49] 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-05-28 16:21:44,728 [49] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-05-28 16:21:46,581 [35] 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-05-28 16:21:46,581 [35] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-05-28 16:23:05,315 [125] 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-05-28 16:23:09,323 [90] 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-05-28 16:23:20,801 [90] 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-05-28 16:24:16,513 [35] 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-05-28 16:25:11,482 [124] 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-05-28 16:35:57,559 [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-05-28 16:37:11,338 [78] 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-05-28 16:38:08,482 [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-05-28 16:38:34,550 [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-05-28 17:09:29,629 [20] 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-05-28 17:11:35,804 [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-05-28 17:16:26,943 [67] 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-05-28 17:18:00,009 [57] 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-05-28 17:18:31,388 [109] 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-05-28 17:56:23,183 [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-05-28 18:03:34,476 [139] 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-05-28 18:04:31,145 [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-05-28 18:06:24,752 [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-05-28 18:16:09,669 [42] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 18:16:40,489 [42] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 18:21:39,870 [87] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 18:56:06,909 [20] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-28 18:56:06,909 [20] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-28 18:56:06,909 [20] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-28 18:56:06,909 [20] ERROR Houselens.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-05-28 18:56:06,909 [20] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-28 18:56:07,017 [20] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-28 18:56:07,017 [20] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-28 18:56:07,017 [20] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-28 18:56:07,017 [20] ERROR Houselens.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-05-28 18:56:07,017 [20] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-28 19:01:06,998 [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-05-28 19:01:07,139 [60] 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-05-28 19:01:51,677 [44] 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-05-28 19:23:35,952 [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-05-28 19:23:55,808 [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-05-28 19:25:14,619 [111] 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-05-28 19:37:22,671 [42] 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-05-28 19:37:53,559 [42] 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-05-28 19:38:18,594 [62] 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-05-28 19:53:50,463 [162] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Called For Order 16590

2025-05-28 19:53:50,463 [162] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Response For Order 16590 :BadRequest

2025-05-28 19:53:50,463 [162] ERROR Houselens.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"juananegron@msn.com","PrismUserID":"juanitanegron","PhotoURLs":[],"ListingWebsite":"","PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":null,"ListingID":"16590","UserID":"e33c7e5c-c844-410a-a253-892788f8b1f9","Bedrooms":"4","Bathrooms":"2","PropertyType":"residential","MLSNumber":"NJBL2087970","MLSName":"BRIGHT","YearBuilt":0,"Description":"","LotSize":".32","ListingOrderState":"CANCELLED","Style":"Colonial"}

2025-05-28 20:08:21,195 [62] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Called For Order 16599

2025-05-28 20:08:21,195 [62] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Response For Order 16599 :OK

2025-05-28 20:08:21,195 [62] ERROR Houselens.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"juananegron@msn.com","PrismUserID":"juanitanegron","PhotoURLs":[],"ListingWebsite":"","PropertyAddress":"31 Meadow Lane, Mount Holly, NJ, USA 08060","PropertyCity":"Mount Holly","PropertyState":"NJ","PropertyZIP":"08060","Price":null,"SquareFeet":"2800","ListingID":"16599","UserID":"e33c7e5c-c844-410a-a253-892788f8b1f9","Bedrooms":"4","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":".32","ListingOrderState":"SCHEDULED","Style":""}

2025-05-28 20:09:28,456 [152] 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-05-28 20:10:10,070 [15] 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-05-28 20:10:10,070 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset

2025-05-28 20:13:18,439 [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-05-28 20:17:40,604 [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-05-28 20:19:20,322 [65] 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-05-28 20:19:30,735 [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-05-28 20:20:43,698 [118] 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-05-28 20:24:48,629 [14] 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-05-28 20:27:30,788 [52] 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-05-28 20:33:46,200 [71] 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-05-28 20:34:01,680 [71] 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-05-28 20:39:34,677 [161] 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-05-28 20:40:14,130 [74] 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-05-28 20:40:31,279 [74] 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-05-28 20:40:46,446 [119] ERROR Houselens.Helper.LogHelper [(null)] - Message: ===============================================
inside from imagenai
WorkorderId from imagenai: 05557f3f-d09e-482d-94f7-00398824c689

2025-05-28 20:40:46,587 [119] ERROR Houselens.Helper.LogHelper [(null)] - Message: Profile : HouseLens_AIProfile_RAW_031723

2025-05-28 20:40:46,602 [119] ERROR Houselens.Helper.LogHelper [(null)] - Message: projectUuid from imagenai: 683774d94adc7bd0d61b053d

2025-05-28 20:40:47,009 [119] ERROR Houselens.Helper.LogHelper [(null)] - Message: Raw image count: 151

2025-05-28 20:41:09,020 [161] ERROR Houselens.Helper.LogHelper [(null)] - Message: Upload image done from imagenai

2025-05-28 20:41:09,020 [161] ERROR Houselens.Helper.LogHelper [(null)] - Message: SendProjectForEdit done from imagenai

2025-05-28 20:47:41,700 [44] 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-05-28 20:50:38,851 [44] 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-05-28 20:56:52,388 [45] 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-05-28 21:01:40,285 [149] 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-05-28 21:02:37,384 [117] 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-05-28 21:06:34,377 [114] 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-05-28 21:08:55,549 [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-05-28 21:13:22,272 [75] ERROR PayPal.Api.HttpConnection [(null)] - Error response:
2025-05-28 21:13:22,272 [75] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"668e1f562fb67","message":"Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.","information_link":"https://developer.paypal.com/docs/api/payments.billing-agreements#errors"}
2025-05-28 21:13:22,272 [75] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request.
2025-05-28 21:13:22,272 [75] ERROR PayPal.PayPalException [(null)] - Payments Exception: 
   Error:    MERCHANT_ACCOUNT_DENIED
   Message:  Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.
   URI:      https://developer.paypal.com/docs/api/payments.billing-agreements#errors
   Debug ID: 668e1f562fb67

2025-05-28 21:13:22,272 [75] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-28 21:13:22,272 [75] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader)
   at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
2025-05-28 21:13:22,272 [75] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at Houselens.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
   at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname)
2025-05-28 21:16:06,667 [64] 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-05-28 21:20:22,184 [163] 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-05-28 21:25:14,904 [52] ERROR Houselens.Helper.LogHelper [(null)] - Message: inside imagenai callback, projectid: 683774d94adc7bd0d61b053d, status: Completed, action: edit

2025-05-28 21:25:15,228 [55] ERROR Houselens.Helper.LogHelper [(null)] - Message: number of edited picture: 55

2025-05-28 21:25:15,244 [55] ERROR Houselens.Helper.LogHelper [(null)] - Message: clientFolderId: ded7d5ba-f19c-4156-a198-05814507b75f

2025-05-28 21:25:17,941 [156] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (1)-HDR.dng

2025-05-28 21:25:19,918 [61] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (10)-HDR.dng

2025-05-28 21:25:21,966 [45] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (100)-HDR.dng

2025-05-28 21:25:24,271 [149] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (103).dng

2025-05-28 21:25:26,624 [77] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (104).dng

2025-05-28 21:25:29,208 [8] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (105)-HDR.dng

2025-05-28 21:25:31,437 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (109)-HDR.dng

2025-05-28 21:25:33,633 [156] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (112)-HDR.dng

2025-05-28 21:25:35,855 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (115)-HDR.dng

2025-05-28 21:25:38,349 [55] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (120).dng

2025-05-28 21:25:40,633 [107] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (121)-HDR.dng

2025-05-28 21:25:42,557 [162] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (124)-HDR.dng

2025-05-28 21:25:44,940 [124] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (127).dng

2025-05-28 21:25:47,238 [44] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (128).dng

2025-05-28 21:25:49,366 [118] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (129)-HDR.dng

2025-05-28 21:25:51,599 [45] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (13)-HDR.dng

2025-05-28 21:25:54,272 [85] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (133)-HDR.dng

2025-05-28 21:25:57,189 [124] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (138).dng

2025-05-28 21:26:01,726 [85] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (139)-HDR.dng

2025-05-28 21:26:07,821 [156] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (140)-HDR.dng

2025-05-28 21:26:11,462 [44] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (145)-HDR.dng

2025-05-28 21:26:15,280 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (148)-HDR.dng

2025-05-28 21:26:17,935 [45] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (16)-HDR.dng

2025-05-28 21:26:21,004 [149] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (19)-HDR.dng

2025-05-28 21:26:23,725 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (22)-HDR.dng

2025-05-28 21:26:26,845 [14] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (25)-HDR.dng

2025-05-28 21:26:29,995 [156] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (28)-HDR.dng

2025-05-28 21:26:33,899 [8] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (31)-HDR.dng

2025-05-28 21:26:36,573 [107] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (32)-HDR.dng

2025-05-28 21:26:39,637 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (37)-HDR.dng

2025-05-28 21:26:42,971 [46] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (4)-HDR.dng

2025-05-28 21:26:45,925 [55] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (40)-HDR.dng

2025-05-28 21:26:49,404 [156] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (43)-HDR.dng

2025-05-28 21:26:52,152 [61] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (46)-HDR.dng

2025-05-28 21:26:57,132 [149] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (49)-HDR.dng

2025-05-28 21:27:00,115 [162] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (52)-HDR.dng

2025-05-28 21:27:04,114 [149] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (55).dng

2025-05-28 21:27:07,410 [107] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (56).dng

2025-05-28 21:27:11,015 [107] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (57)-HDR.dng

2025-05-28 21:27:14,651 [156] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (61)-HDR.dng

2025-05-28 21:27:17,644 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (64)-HDR.dng

2025-05-28 21:27:21,411 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (67).dng

2025-05-28 21:27:24,831 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (68).dng

2025-05-28 21:27:28,339 [46] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (69)-HDR.dng

2025-05-28 21:27:31,637 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (7)-HDR.dng

2025-05-28 21:27:35,354 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (73)-HDR.dng

2025-05-28 21:27:38,262 [44] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (76)-HDR.dng

2025-05-28 21:27:42,386 [162] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (79)-HDR.dng

2025-05-28 21:27:45,530 [8] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (82)-HDR.dng

2025-05-28 21:27:49,164 [8] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (85)-HDR.dng

2025-05-28 21:27:52,806 [77] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (88)-HDR.dng

2025-05-28 21:27:56,154 [149] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (91).dng

2025-05-28 21:27:59,598 [149] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (92)-HDR.dng

2025-05-28 21:28:04,173 [75] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (96).dng

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

2025-05-28 21:28:07,160 [7] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-28 21:28:07,160 [7] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader)
   at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
2025-05-28 21:28:07,160 [7] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at Houselens.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
   at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname)
2025-05-28 21:28:08,141 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (97)-HDR.dng

2025-05-28 21:28:59,959 [42] ERROR Houselens.Helper.LogHelper [(null)] - Message: inside imagenai callback, projectid: 683774d94adc7bd0d61b053d, status: Completed, action: export

2025-05-28 21:29:00,184 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: number of exported picture: 55

2025-05-28 21:29:00,215 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: clientFolderId: ded7d5ba-f19c-4156-a198-05814507b75f

2025-05-28 21:29:01,190 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (1)-HDR.jpg

2025-05-28 21:29:02,246 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (10)-HDR.jpg

2025-05-28 21:29:03,239 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (100)-HDR.jpg

2025-05-28 21:29:04,254 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (103).jpg

2025-05-28 21:29:05,360 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (104).jpg

2025-05-28 21:29:06,250 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (105)-HDR.jpg

2025-05-28 21:29:07,105 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (109)-HDR.jpg

2025-05-28 21:29:08,206 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (112)-HDR.jpg

2025-05-28 21:29:09,112 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (115)-HDR.jpg

2025-05-28 21:29:10,294 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (120).jpg

2025-05-28 21:29:11,381 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (121)-HDR.jpg

2025-05-28 21:29:12,589 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (124)-HDR.jpg

2025-05-28 21:29:13,891 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (127).jpg

2025-05-28 21:29:15,171 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (128).jpg

2025-05-28 21:29:16,275 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (129)-HDR.jpg

2025-05-28 21:29:17,150 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (13)-HDR.jpg

2025-05-28 21:29:18,352 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (133)-HDR.jpg

2025-05-28 21:29:19,524 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (138).jpg

2025-05-28 21:29:20,680 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (139)-HDR.jpg

2025-05-28 21:29:21,862 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (140)-HDR.jpg

2025-05-28 21:29:23,233 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (145)-HDR.jpg

2025-05-28 21:29:24,467 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (148)-HDR.jpg

2025-05-28 21:29:25,704 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (16)-HDR.jpg

2025-05-28 21:29:26,844 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (19)-HDR.jpg

2025-05-28 21:29:27,937 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (22)-HDR.jpg

2025-05-28 21:29:28,812 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (25)-HDR.jpg

2025-05-28 21:29:29,788 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (28)-HDR.jpg

2025-05-28 21:29:30,694 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (31)-HDR.jpg

2025-05-28 21:29:31,739 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (32)-HDR.jpg

2025-05-28 21:29:32,708 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (37)-HDR.jpg

2025-05-28 21:29:33,692 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (4)-HDR.jpg

2025-05-28 21:29:34,779 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (40)-HDR.jpg

2025-05-28 21:29:35,701 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (43)-HDR.jpg

2025-05-28 21:29:36,792 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (46)-HDR.jpg

2025-05-28 21:29:37,612 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (49)-HDR.jpg

2025-05-28 21:29:38,628 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (52)-HDR.jpg

2025-05-28 21:29:39,737 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (55).jpg

2025-05-28 21:29:40,932 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (56).jpg

2025-05-28 21:29:42,046 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (57)-HDR.jpg

2025-05-28 21:29:42,905 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (61)-HDR.jpg

2025-05-28 21:29:43,948 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (64)-HDR.jpg

2025-05-28 21:29:44,932 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (67).jpg

2025-05-28 21:29:46,031 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (68).jpg

2025-05-28 21:29:46,953 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (69)-HDR.jpg

2025-05-28 21:29:47,900 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (7)-HDR.jpg

2025-05-28 21:29:48,728 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (73)-HDR.jpg

2025-05-28 21:29:49,853 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (76)-HDR.jpg

2025-05-28 21:29:50,817 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (79)-HDR.jpg

2025-05-28 21:29:51,910 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (82)-HDR.jpg

2025-05-28 21:29:52,841 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (85)-HDR.jpg

2025-05-28 21:29:53,794 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (88)-HDR.jpg

2025-05-28 21:29:54,840 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (91).jpg

2025-05-28 21:29:55,856 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (92)-HDR.jpg

2025-05-28 21:29:57,018 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (96).jpg

2025-05-28 21:29:58,025 [17] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success for:1409 East Lafayette Avenue, Baltimore, MD, 21213- (97)-HDR.jpg

2025-05-28 21:39:52,184 [36] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 21:39:52,278 [36] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 21:40:03,174 [87] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 21:40:18,295 [71] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 21:40:19,273 [71] 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-05-28 21:40:27,017 [71] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 21:40:31,627 [46] ERROR Houselens.Helper.LogHelper [(null)] - Message: responseDto row count: 1

2025-05-28 21:40:31,643 [46] ERROR Houselens.Helper.LogHelper [(null)] - Message: Save uploaded files response: Success

2025-05-28 21:40:32,041 [46] ERROR Houselens.Helper.LogHelper [(null)] - Message: Add files success

2025-05-28 21:40:53,142 [46] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 21:40:53,142 [61] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 21:48:04,896 [128] ERROR PayPal.Api.HttpConnection [(null)] - Error response:
2025-05-28 21:48:04,896 [128] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"e42d5e3683e3a","message":"Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.","information_link":"https://developer.paypal.com/docs/api/payments.billing-agreements#errors"}
2025-05-28 21:48:04,896 [128] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request.
2025-05-28 21:48:04,896 [128] ERROR PayPal.PayPalException [(null)] - Payments Exception: 
   Error:    MERCHANT_ACCOUNT_DENIED
   Message:  Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.
   URI:      https://developer.paypal.com/docs/api/payments.billing-agreements#errors
   Debug ID: e42d5e3683e3a

2025-05-28 21:48:04,896 [128] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-28 21:48:04,896 [128] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader)
   at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
2025-05-28 21:48:04,896 [128] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at Houselens.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
   at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname)
2025-05-28 22:09:41,231 [84] ERROR Houselens.Helper.LogHelper [(null)] - Message: Conversion failed when converting the nvarchar value '412 Butler Road, Mt. Juliet, TN 37122' to data type int.
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-05-28 22:09:41,231 [84] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_WorkOrder_FetchWorkordersByQueryString

2025-05-28 22:09:41,231 [84] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrdersBySearchString(SearchByQueryDTO workOrderSearchObj)
   at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrdersBySearchString(SearchByQueryDTO workOrderSearchObj)
2025-05-28 22:27:57,851 [45] ERROR PayPal.Api.HttpConnection [(null)] - Error response:
2025-05-28 22:27:57,851 [45] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"25a726d2d4390","message":"Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.","information_link":"https://developer.paypal.com/docs/api/payments.billing-agreements#errors"}
2025-05-28 22:27:57,851 [45] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request.
2025-05-28 22:27:57,851 [45] ERROR PayPal.PayPalException [(null)] - Payments Exception: 
   Error:    MERCHANT_ACCOUNT_DENIED
   Message:  Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.
   URI:      https://developer.paypal.com/docs/api/payments.billing-agreements#errors
   Debug ID: 25a726d2d4390

2025-05-28 22:27:57,851 [45] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-28 22:27:57,851 [45] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader)
   at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
2025-05-28 22:27:57,851 [45] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at Houselens.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
   at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname)
2025-05-28 23:25:56,054 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: ddbdb095-0c62-41c0-ba99-a0cd2657908b

2025-05-28 23:25:58,283 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: 31642d8a-a71c-407a-8249-b804413bd093

2025-05-28 23:26:00,555 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: 93fee8aa-782c-4c48-a6ac-d69f42b66437

2025-05-28 23:26:02,487 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: d0dc6c25-cc18-4018-978d-9a413a8ed8d1

2025-05-28 23:26:04,538 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: 05557f3f-d09e-482d-94f7-00398824c689

2025-05-28 23:26:06,484 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: f102c6c3-4fd1-4880-a48f-f5943aa8055f

2025-05-28 23:26:08,451 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: 198a618e-e103-4fdb-b335-39b437eae434

2025-05-28 23:26:10,898 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: 66666086-ac76-4ad6-b5de-7538bcb1ca66

2025-05-28 23:26:12,817 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: 35143871-b2bd-40f4-bb86-b402290fd92e

2025-05-28 23:26:14,878 [86] ERROR Houselens.Helper.LogHelper [(null)] - Message: WorkorderId: 246543bd-fcb6-4a17-8011-d5f5f785b1fe

2025-05-28 23:51:45,618 [34] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Called For Order 16601

2025-05-28 23:51:45,618 [34] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Response For Order 16601 :BadRequest

2025-05-28 23:51:45,618 [34] ERROR Houselens.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"leeomalley01@gmail.com","PrismUserID":"lomalley","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"16601","UserID":"ccad584a-5158-4773-8063-fb24ab3762bc","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-05-28 23:55:58,991 [58] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-28 23:56:08,278 [134] ERROR Houselens.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID
2025-05-29 00:25:51,948 [108] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Called For Order 16602

2025-05-29 00:25:51,948 [108] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Response For Order 16602 :BadRequest

2025-05-29 00:25:51,948 [108] ERROR Houselens.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"leeomalley01@gmail.com","PrismUserID":"lomalley","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"16602","UserID":"ccad584a-5158-4773-8063-fb24ab3762bc","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-05-29 00:26:37,240 [108] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Called For Order 16603

2025-05-29 00:26:37,255 [108] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Response For Order 16603 :BadRequest

2025-05-29 00:26:37,255 [108] ERROR Houselens.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"leeomalley01@gmail.com","PrismUserID":"lomalley","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"16603","UserID":"ccad584a-5158-4773-8063-fb24ab3762bc","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-05-29 00:34:53,196 [45] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Called For Order 16602

2025-05-29 00:34:53,196 [45] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Response For Order 16602 :OK

2025-05-29 00:34:53,196 [45] ERROR Houselens.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"leeomalley01@gmail.com","PrismUserID":"lomalley","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":"153 Lexington Ave, Westwood, NJ, USA","PropertyCity":"Westwood","PropertyState":"NJ","PropertyZIP":"07675","Price":"325","SquareFeet":"1332","ListingID":"16602","UserID":"ccad584a-5158-4773-8063-fb24ab3762bc","Bedrooms":null,"Bathrooms":"1","PropertyType":"Single family detached ","MLSNumber":"NJMLS","MLSName":"NJMLS","YearBuilt":0,"Description":null,"LotSize":"7100","ListingOrderState":"SUBMITTED","Style":"Traditional "}

2025-05-29 00:36:07,792 [106] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:36:07,792 [106] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-29 00:36:07,792 [106] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 00:36:07,792 [106] ERROR Houselens.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-05-29 00:36:07,792 [106] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-29 00:37:24,314 [106] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:37:24,314 [106] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-29 00:37:24,314 [106] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 00:37:24,314 [106] ERROR Houselens.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-05-29 00:37:24,314 [106] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-29 00:37:24,377 [106] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:37:24,377 [106] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-29 00:37:24,377 [106] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 00:37:24,377 [106] ERROR Houselens.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-05-29 00:37:24,377 [106] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-29 00:38:40,077 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:40,077 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:40,077 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:41,282 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:41,282 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:41,282 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:41,469 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:41,469 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:41,469 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:42,032 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:42,032 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:42,032 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:42,313 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:42,313 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:42,313 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:42,563 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:42,563 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:42,563 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:42,798 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:42,798 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:42,798 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:42,970 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:42,970 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:42,970 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:43,220 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:43,220 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:43,220 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:43,519 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:43,519 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:43,519 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:45,330 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:45,330 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:45,330 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:45,501 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:45,501 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:45,501 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:45,689 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:45,689 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:45,689 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:45,957 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:45,957 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:45,957 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:46,238 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:46,238 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:46,238 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:46,473 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:46,473 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:46,473 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:46,707 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:46,707 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:46,707 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:46,910 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:46,910 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:46,910 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:47,616 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:47,616 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:47,616 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:47,788 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:47,788 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:47,788 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:47,960 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:47,960 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:47,960 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:48,122 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:48,122 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:48,122 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:48,279 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:48,279 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:48,279 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:48,451 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:48,451 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:48,451 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:49,076 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:49,076 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:49,076 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:49,638 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:49,638 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:49,638 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:50,024 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:50,024 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:50,024 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:50,285 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:50,301 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:50,301 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:50,582 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:50,582 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:50,582 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:50,843 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:50,843 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:50,843 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:53,256 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:53,256 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:53,256 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:54,361 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:54,361 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:54,361 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:54,627 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:54,627 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:54,627 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:56,462 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:56,462 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:56,462 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:56,932 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:56,932 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:56,932 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:57,151 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:57,151 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:57,151 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:57,370 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:57,370 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:57,370 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:57,526 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:57,526 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:57,526 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:57,792 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:57,792 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:57,792 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:58,088 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:58,088 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:58,088 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:59,482 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:59,482 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:59,482 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:38:59,826 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:38:59,826 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:38:59,826 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:39:00,044 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:39:00,044 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:39:00,044 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:39:00,201 [15] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:39:00,201 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:39:00,201 [15] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:41:54,731 [121] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:41:54,731 [121] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-29 00:41:54,731 [121] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 00:41:54,731 [121] ERROR Houselens.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-05-29 00:41:54,731 [121] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-29 00:41:54,794 [121] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:41:54,794 [121] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-29 00:41:54,794 [121] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 00:41:54,794 [121] ERROR Houselens.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-05-29 00:41:54,794 [121] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-29 00:43:10,187 [71] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:10,187 [71] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-29 00:43:10,187 [71] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 00:43:10,187 [71] ERROR Houselens.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-05-29 00:43:10,187 [71] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-29 00:43:47,536 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:47,536 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:47,536 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:51,585 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:51,585 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:51,585 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:51,772 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:51,772 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:51,772 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:52,397 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:52,397 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:52,397 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:52,725 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:52,725 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:52,725 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:53,171 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:53,171 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:53,171 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:53,401 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:53,401 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:53,401 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:53,602 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:53,602 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:53,602 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:53,805 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:53,805 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:53,805 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:54,258 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:54,258 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:54,258 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:55,562 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:55,562 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:55,562 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:55,741 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:55,741 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:55,741 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:55,929 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:55,929 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:55,929 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:56,194 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:56,194 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:56,194 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:56,507 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:56,507 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:56,507 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:56,757 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:56,757 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:56,757 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:57,007 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:57,007 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:57,007 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:43:57,194 [53] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:43:57,194 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_SearchBrokerageFirm

2025-05-29 00:43:57,194 [53] ERROR Houselens.Helper.LogHelper [(null)] - Message: Object reference not set to an instance of an object.
Stack Trace:    at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.SearchBrokerageFirm(String searchText, String firmId)
   at Grid_API.ServiceLayer.GridAPIService.SearchBrokerageFirm(String searchText, String tokenId, String firmId)
2025-05-29 00:44:50,799 [110] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:44:50,799 [110] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-29 00:44:50,799 [110] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 00:44:50,799 [110] ERROR Houselens.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-05-29 00:44:50,799 [110] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-29 00:45:45,522 [14] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:45:45,522 [14] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-29 00:45:45,522 [14] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 00:45:45,522 [14] ERROR Houselens.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-05-29 00:45:45,522 [14] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-29 00:46:07,059 [84] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Called For Order 16604

2025-05-29 00:46:07,059 [84] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Response For Order 16604 :BadRequest

2025-05-29 00:46:07,059 [84] ERROR Houselens.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"leeomalley01@gmail.com","PrismUserID":"lomalley","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"16604","UserID":"ccad584a-5158-4773-8063-fb24ab3762bc","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-05-29 00:52:50,485 [62] ERROR Houselens.Helper.LogHelper [(null)] - Message: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).
Stack Trace:    at System.Guid.TryParseGuidWithNoStyle(String guidString, GuidResult& result)
   at System.Guid.TryParseGuid(String g, GuidStyles flags, GuidResult& result)
   at System.Guid.Parse(String input)
   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-05-29 00:52:56,380 [62] ERROR Houselens.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 Houselens.Service_DataAccessLayer.CommonDataAccessLayer.FetchData(String sp, SqlCommand cmd, Boolean isReturnMessage, Boolean isStatus)
2025-05-29 00:52:56,380 [62] ERROR Houselens.Helper.LogHelper [(null)] - Message: Executing Script: Proc_Grid_Area_FetchAreaByArtistFirm

2025-05-29 00:52:56,380 [62] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 00:52:56,380 [62] ERROR Houselens.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-05-29 00:52:56,380 [62] 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.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
   at Grid_API.BusinessLayer.Grid_APIBusinessLayer.FetchAreaBasedOnArtistFirm(String artistFirmID, String searchText, String artistId)
2025-05-29 00:56:21,992 [141] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Called For Order 16606

2025-05-29 00:56:21,992 [141] ERROR Houselens.Helper.LogHelper [(null)] - Message: Prism API Response For Order 16606 :BadRequest

2025-05-29 00:56:21,992 [141] ERROR Houselens.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"leeomalley01@gmail.com","PrismUserID":"lomalley","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"16606","UserID":"ccad584a-5158-4773-8063-fb24ab3762bc","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null}

2025-05-29 01:18:43,761 [134] ERROR PayPal.Api.HttpConnection [(null)] - Error response:
2025-05-29 01:18:43,761 [134] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"bc1eb2af7c369","message":"Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.","information_link":"https://developer.paypal.com/docs/api/payments.billing-agreements#errors"}
2025-05-29 01:18:43,761 [134] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request.
2025-05-29 01:18:43,761 [134] ERROR PayPal.PayPalException [(null)] - Payments Exception: 
   Error:    MERCHANT_ACCOUNT_DENIED
   Message:  Profile ID is not valid for this account.  Please resubmit request with the correct profile ID.
   URI:      https://developer.paypal.com/docs/api/payments.billing-agreements#errors
   Debug ID: bc1eb2af7c369

2025-05-29 01:18:43,761 [134] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

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

2025-05-29 01:22:10,539 [119] ERROR Houselens.Helper.LogHelper [(null)] - Message: GenericException

2025-05-29 01:22:10,539 [119] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader)
   at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
2025-05-29 01:22:10,539 [119] ERROR Houselens.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request.
Stack Trace:    at Houselens.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException)
   at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname)
   at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname)