2025-10-04 16:02:01,914 [12] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 16:02:41,786 [23] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 16:06:10,877 [25] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 16:20:51,126 [74] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 16:21:58,646 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.AddUpdateData(String commandKey, SqlCommand& cmd, Boolean isReturnmsg, Boolean isStatuscode) 2025-10-04 16:21:58,646 [34] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset 2025-10-04 16:22:00,487 [11] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.AddUpdateData(String commandKey, SqlCommand& cmd, Boolean isReturnmsg, Boolean isStatuscode) 2025-10-04 16:22:00,487 [11] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset 2025-10-04 16:22:03,475 [77] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.AddUpdateData(String commandKey, SqlCommand& cmd, Boolean isReturnmsg, Boolean isStatuscode) 2025-10-04 16:22:03,475 [77] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Executing Script: dbo.Proc_BOS_FileChest_UpdateAsset 2025-10-04 16:28:08,394 [40] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 16:30:52,404 [33] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24410 2025-10-04 16:30:52,404 [33] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24410 :OK 2025-10-04 16:30:52,404 [33] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"jmarcellino@weichert.com","PrismUserID":"jmarcellino","PhotoURLs":["https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F235f88bc-5ae2-486b-a366-ac0a01bf86dd.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F424ac683-57d4-4906-e857-779270a3db2a.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F07609f3a-60ec-4eb5-9a9c-6b77e9ccd2b7.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F29dda499-eb37-4629-b9c1-5cfa9d5b5936.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fd35309be-41ec-48a9-c948-9fd3ab8202d2.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F49483e9f-5bf6-4d02-abdd-0d7017fc4885.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F97d17503-c508-4d04-e3e0-b72718e07f63.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F2b9654cb-b22b-46e5-d198-a8d7a6169527.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fb2f67b09-fb90-43f5-adc5-3d7f361bc07b.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F1497c0dc-7b86-406a-c713-f9759d7d6272.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ff85fdbbc-17e4-44a1-e9cb-d3e8ee9279c8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fff0f5cb8-298b-4c8c-df30-51091adf523a.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F97e700c2-3880-4a2d-9ffe-08f6af7f5077.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F1f7d2253-40c2-4709-c7e9-44952f31ae38.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4bb63970-f144-4473-ab2c-624cb9cc2cbf.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3d512cf9-304b-4a23-a451-42320cf9d8fd.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F125f83ce-2a98-4efa-db8a-401146a8827e.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F6baef445-e125-48a9-c8a2-43b055c99337.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F0bc7e47a-d15d-4371-ed0f-de6fa40a4137.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F3c953486-ebdf-4b7f-f663-3b019ddd3597.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F99446753-6351-49b3-80d2-714e802bb098.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F20cc1b20-fc48-4c5a-9214-ec024c8a2ed4.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F8a5ff7ac-71c9-43b6-ca0f-d78df2bdd7b1.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F5b3205ac-6c9a-4829-8dd0-e5e1b53ac0f9.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fe36fb3bc-0eb0-4282-fe30-2ad6225966c2.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fcc83144e-7e74-4577-99d9-5e66efd82a4b.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F46e7048e-6c80-40bb-99ba-5c3c97b2e9e7.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F05e5b90a-84cb-412e-95d1-8461bc55612a.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F178c0b15-cfbc-4d0b-9968-87690e270725.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F72be6431-4cb1-4d9d-a87f-e89f0ede4812.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F1ff5571a-7afb-4f3d-b352-31b860c97132.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F9f403ad8-44f5-4ded-f14a-cdec65266e6f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F80931da2-2b46-4fe9-c0a2-d6b71a4aa201.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F0e7689cd-e523-44cf-83c0-9aae76994c5d.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F4af41e84-82d3-49f1-9447-4442b8141f6a.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Ff4b5c846-a87e-4c16-e780-aaee924b2a8f.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F16af175d-dca3-47b5-99f1-d452cbfea829.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2F115fd1e9-f1d5-41ec-fd79-ef4c213ef0a8.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdf33d407-1ed8-4f5b-8aca-b08744256185.jpg","https://s3.amazonaws.com/houselens-enterprise-editors-upload/enterpriseuploads%2Fdc24da99-bade-4508-e971-9a6838f3c845.jpg"],"ListingWebsite":"","PropertyAddress":"2 2nd Avenue, Seaside Heights, NJ, USA 08751","PropertyCity":"Seaside Heights","PropertyState":"NJ","PropertyZIP":"08751","Price":null,"SquareFeet":"1100","ListingID":"24410","UserID":"3ae3885e-d59e-44e6-91ec-362ad0992332","Bedrooms":"3","Bathrooms":"2","PropertyType":"","MLSNumber":"","MLSName":"","YearBuilt":0,"Description":"","LotSize":"","ListingOrderState":"COMPLETED","Style":""} 2025-10-04 17:24:39,736 [14] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-04 17:24:39,736 [78] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-04 18:31:28,185 [25] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-10-04 18:31:28,185 [25] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"bf18791c681d4","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-10-04 18:31:28,185 [25] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-10-04 18:31:28,185 [25] 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: bf18791c681d4 2025-10-04 18:31:28,200 [25] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-10-04 18:31:28,200 [25] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request. Stack Trace: at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader) at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname) 2025-10-04 18:31:28,200 [25] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname) at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname) 2025-10-04 18:55:10,817 [142] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-04 18:55:10,817 [143] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-04 18:55:38,061 [143] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 18:55:40,353 [143] ERROR Grid_API.Helper.LogHelper [(null)] - Message: =============================================== inside from imagenai WorkorderId from imagenai: cd148794-ed9d-43f1-ac7b-a175248f09fe 2025-10-04 18:55:40,525 [143] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Profile : HouseLens_AIProfile_RAW_031723 2025-10-04 18:55:40,557 [143] ERROR Grid_API.Helper.LogHelper [(null)] - Message: projectUuid from imagenai: 68e16db3977f2121d1a9e0b1 2025-10-04 18:55:40,988 [143] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Raw image count: 61 2025-10-04 18:55:44,982 [107] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Upload image done from imagenai 2025-10-04 18:55:44,998 [107] ERROR Grid_API.Helper.LogHelper [(null)] - Message: SendProjectForEdit done from imagenai 2025-10-04 19:05:08,696 [117] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 19:23:14,433 [80] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 19:27:46,445 [115] ERROR Grid_API.Helper.LogHelper [(null)] - Message: inside imagenai callback, projectid: 68e16db3977f2121d1a9e0b1, status: Failed, action: edit 2025-10-04 19:27:46,445 [115] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Edit failed for project:68e16db3977f2121d1a9e0b1 2025-10-04 19:32:58,307 [100] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 19:48:57,521 [110] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 22:46:22,751 [219] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: cd148794-ed9d-43f1-ac7b-a175248f09fe 2025-10-04 22:46:28,569 [219] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 0bfcb1dc-69f1-402d-a73c-18307c693760 2025-10-04 22:46:33,922 [219] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: ca6d7864-d75f-4f3d-a077-a629f15b69fd 2025-10-04 23:50:08,062 [202] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 23:50:25,427 [189] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The request was aborted: The connection was closed unexpectedly. Stack Trace: at System.Net.HttpWebRequest.GetResponse() at Grid_API.ServiceLayer.GridAPIService.GetZillowDetailsByAddress(String tokenId, String url) 2025-10-04 23:55:35,116 [189] ERROR Grid_API.Helper.LogHelper [(null)] - Message: WorkorderId: 03cd3901-469e-43d0-afd3-ad41d0b66874 2025-10-05 00:00:32,892 [189] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.IsTokenValid(String tokenId) 2025-10-05 00:00:40,135 [109] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.IsTokenValid(String tokenId) 2025-10-05 00:01:21,129 [109] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The wait operation timed out Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Grid_API.Service_DataAccessLayer.CommonDataAccessLayer.IsTokenValid(String tokenId) 2025-10-05 00:18:17,988 [197] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-05 00:18:31,500 [197] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-05 00:18:41,564 [197] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-05 01:29:49,538 [50] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-05 01:30:13,006 [50] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-05 10:23:01,652 [198] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-10-05 10:23:01,652 [198] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"7a8036356bdb3","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-10-05 10:23:01,652 [198] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-10-05 10:23:01,652 [198] 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: 7a8036356bdb3 2025-10-05 10:23:01,652 [198] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-10-05 10:23:01,652 [198] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request. Stack Trace: at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader) at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname) 2025-10-05 10:23:01,652 [198] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname) at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname) 2025-10-05 10:50:53,820 [199] ERROR PayPal.Api.HttpConnection [(null)] - Error response: 2025-10-05 10:50:53,820 [199] ERROR PayPal.Api.HttpConnection [(null)] - {"name":"MERCHANT_ACCOUNT_DENIED","debug_id":"37d5760c3366d","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-10-05 10:50:53,820 [199] ERROR PayPal.Api.HttpConnection [(null)] - The remote server returned an error: (400) Bad Request. 2025-10-05 10:50:53,820 [199] 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: 37d5760c3366d 2025-10-05 10:50:53,820 [199] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-10-05 10:50:53,820 [199] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request. Stack Trace: at PayPal.Api.PayPalResource.ConfigureAndExecute[T](APIContext apiContext, HttpMethod httpMethod, String resource, String payload, String endpoint, Boolean setAuthorizationHeader) at PayPal.Api.Agreement.Get(APIContext apiContext, String agreementId) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname) 2025-10-05 10:50:53,820 [199] ERROR Grid_API.Helper.LogHelper [(null)] - Message: The remote server returned an error: (400) Bad Request. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchPreferredAgentForUser(String userID, String nickname) at Grid_API.ServiceLayer.GridAPIService.FetchPreferredAgentForUser(String tokenID, String userID, String nickname) 2025-10-05 12:45:00,384 [182] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Generating weekly invoice on: 20251005 12:45:00.384 2025-10-05 12:55:01,157 [120] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Sending weekly invoice on: 20251005 12:55:01.157 2025-10-05 13:59:59,995 [192] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Generating weekly invoice on: 20251005 13:59:59.995 2025-10-05 14:00:10,691 [192] ERROR Grid_API.Helper.LogHelper [(null)] - Message: GenericException 2025-10-05 14:00:10,691 [192] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Cannot insert the value NULL into column 'InvoiceNo', table 'Grid_Enterprise.dbo.Grid_Artist_InvoiceItem'; column does not allow nulls. INSERT fails. The statement has been terminated. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.CreateInvoices3(String userID, String startDate, String endDate) 2025-10-05 14:00:10,691 [192] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Cannot insert the value NULL into column 'InvoiceNo', table 'Grid_Enterprise.dbo.Grid_Artist_InvoiceItem'; column does not allow nulls. INSERT fails. The statement has been terminated. Stack Trace: at Grid_API.Helper.CustomApplicationException..ctor(String exceptionMessage, Exception innerException) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.CreateInvoices3(String userID, String startDate, String endDate) at Grid_API.ServiceLayer.GridAPIService.CreateInvoices3(String tokenID, String userID, String startDate, String endDate) 2025-10-05 14:02:59,507 [192] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-05 14:09:59,949 [195] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Sending weekly invoice on: 20251005 14:09:59.949 2025-10-05 14:16:30,925 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24464 2025-10-05 14:16:30,925 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24464 :BadRequest 2025-10-05 14:16:30,925 [118] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"jtsui@weichert.com","PrismUserID":"jasminetsui","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":null,"PropertyCity":null,"PropertyState":null,"PropertyZIP":null,"Price":null,"SquareFeet":"0","ListingID":"24464","UserID":"a05932bf-dded-4f6c-b528-552fcadb488d","Bedrooms":"0","Bathrooms":"0","PropertyType":null,"MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":null,"LotSize":null,"ListingOrderState":"CREATED","Style":null} 2025-10-05 14:21:12,868 [187] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Called For Order 24465 2025-10-05 14:21:12,868 [187] ERROR Grid_API.Helper.LogHelper [(null)] - Message: Prism API Response For Order 24465 :OK 2025-10-05 14:21:12,868 [187] ERROR Grid_API.Helper.LogHelper [(null)] - Message: API Data: {"StoreID":1,"EmailAddress":"jtsui@weichert.com","PrismUserID":"jasminetsui","PhotoURLs":[],"ListingWebsite":null,"PropertyAddress":"65 Duley Ave, Edison, NJ, USA","PropertyCity":"Edison","PropertyState":"NJ","PropertyZIP":"08817","Price":"175","SquareFeet":"1000","ListingID":"24465","UserID":"a05932bf-dded-4f6c-b528-552fcadb488d","Bedrooms":null,"Bathrooms":"2","PropertyType":"Single family","MLSNumber":null,"MLSName":null,"YearBuilt":0,"Description":"3 bedrooms with a den","LotSize":"5000","ListingOrderState":"SUBMITTED","Style":"cap cod"} 2025-10-05 14:54:07,196 [74] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-05 15:03:16,080 [33] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-05 15:03:50,667 [33] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID 2025-10-05 18:25:28,501 [175] ERROR Grid_API.UserManagement_ServiceLayer.UserManagementService [(null)] - Invalid tokenID