2025-10-08 09:34:39.291 +05:30 b89d2cdf-e79a-4acb-8eb4-7f07f9b30e9d ERR Failed to delete Sales in Focus. 2025-10-08 09:57:00.827 +05:30 a6816dab-fe7b-4b55-b869-06c1eef5fe90 ERR Failed to delete Sales in Focus. 2025-10-08 10:14:48.180 +05:30 685063f3-3cdd-4078-b984-69bc34ee9b75 ERR Failed to delete Sales in Focus. 2025-10-08 10:21:02.875 +05:30 62754cce-ba8b-487b-87e4-e43f82bf4eb7 ERR Failed to delete Sales in Focus. 2025-10-08 10:32:30.250 +05:30 9f4561f4-c7f5-47e9-949a-6cdea23205ac ERR Failed to delete Sales in Focus. 2025-10-08 10:35:28.693 +05:30 cfc1d943-7023-4d51-99ce-491bdb180c2e ERR Failed to delete Sales in Focus. 2025-10-08 10:39:57.118 +05:30 d5a85a01-c674-4fa1-91fe-7b4c8f964997 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:40:33.706 +05:30 29c6ce86-f6e1-484d-9e26-10acd1934275 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:43:00.967 +05:30 1e2823c7-a477-4be8-990e-a13ad33e7a31 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:46:28.719 +05:30 70775ee9-4f7e-42e2-be43-e1ca4541e271 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:48:26.984 +05:30 c8eefe42-bd59-4185-99da-be1611a2db16 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:49:25.842 +05:30 f209e8f2-fc12-4e65-9667-ba7d9017a0a8 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:52:00.509 +05:30 69a3b129-124c-4e92-a109-0779ff0130d0 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:53:14.928 +05:30 73036c27-9616-4ad2-83ab-3703a6460474 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:53:43.492 +05:30 b35b9de1-6bdc-4428-8982-442e1afc9ad6 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:55:18.859 +05:30 b7062e6f-032e-4912-9539-4ce98afad6a3 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:56:53.090 +05:30 f342bd60-9938-483e-9cd5-14cba22c266c ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:59:18.587 +05:30 76891952-1055-402e-8af4-83eae585019d ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 10:59:54.770 +05:30 737bb514-5553-4696-a04e-c2666832180d ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 11:26:04.449 +05:30 d8481184-b6d7-484e-b471-c9310194a55b ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 11:26:32.209 +05:30 76fd50ce-5b2c-4e7c-a247-fb33f85f2b71 ERR Error getting session ID: Response status code does not indicate success: 503 (Service Unavailable). 2025-10-08 12:06:32.659 +05:30 c096117d-459a-4206-8d3d-58a2cbd515ee ERR Error occured executing stored procedure ssp_t_PostFocus: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'iVendor'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) ClientConnectionId:48ae0396-d41e-4157-9213-31f18054c146 Error Number:207,State:1,Class:16 2025-10-08 12:06:32.673 +05:30 c096117d-459a-4206-8d3d-58a2cbd515ee ERR Invalid column name 'iVendor'. 2025-10-08 12:06:32.677 +05:30 c096117d-459a-4206-8d3d-58a2cbd515ee ERR Error occurred.System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'iVendor'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.GsgRepository.GetScreenAndRequest(Int32 transId, Int32 be, Int32 docType) at Sang.FocusIntegration.Api.Services.GsgService.GetScreenAndRequest(Int32 transId, Int32 be, Int32 docType) at Sang.FocusIntegration.Api.Controllers.GsgController.PostToFocusGsgTransactions(Int32 transId, Int32 docType, Int32 be, Int32 countryId) ClientConnectionId:48ae0396-d41e-4157-9213-31f18054c146 Error Number:207,State:1,Class:16 2025-10-08 15:21:35.747 +05:30 12b80c91-21e6-42d1-8efa-1f217a81b8ba ERR Error Getting request for Receipt Transaction. System.ArgumentNullException: Value cannot be null. (Parameter 'value') at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) 2025-10-08 15:21:35.762 +05:30 12b80c91-21e6-42d1-8efa-1f217a81b8ba ERR Error occurred.System.ArgumentNullException: Value cannot be null. (Parameter 'value') at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) at Sang.FocusIntegration.Api.Controllers.VansaleController.PostToFocusVansaleTransactions(Int32 transId, Int32 docType, Boolean isEdit, Boolean isForIssue, Nullable`1 chequeDate) 2025-10-08 15:22:04.523 +05:30 485ab688-c9e3-4752-a8fa-1003e7b43cdc ERR Error Getting request for Receipt Transaction. System.ArgumentNullException: Value cannot be null. (Parameter 'value') at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) 2025-10-08 15:22:04.524 +05:30 485ab688-c9e3-4752-a8fa-1003e7b43cdc ERR Error occurred.System.ArgumentNullException: Value cannot be null. (Parameter 'value') at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) at Sang.FocusIntegration.Api.Controllers.VansaleController.PostToFocusVansaleTransactions(Int32 transId, Int32 docType, Boolean isEdit, Boolean isForIssue, Nullable`1 chequeDate) 2025-10-08 15:23:20.131 +05:30 e76ad9c9-b9f3-4099-9793-ae720fd6f2eb ERR Error Getting request for Receipt Transaction. System.ArgumentNullException: Value cannot be null. (Parameter 'value') at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) 2025-10-08 15:23:20.132 +05:30 e76ad9c9-b9f3-4099-9793-ae720fd6f2eb ERR Error occurred.System.ArgumentNullException: Value cannot be null. (Parameter 'value') at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) at Sang.FocusIntegration.Api.Controllers.VansaleController.PostToFocusVansaleTransactions(Int32 transId, Int32 docType, Boolean isEdit, Boolean isForIssue, Nullable`1 chequeDate) 2025-10-08 15:24:25.061 +05:30 e9df850a-b15f-4ec9-a883-8a2813e11afb ERR Error Getting request for Receipt Transaction. System.ArgumentNullException: Value cannot be null. (Parameter 'value') at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) 2025-10-08 15:24:25.062 +05:30 e9df850a-b15f-4ec9-a883-8a2813e11afb ERR Error occurred.System.ArgumentNullException: Value cannot be null. (Parameter 'value') at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings) at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) at Sang.FocusIntegration.Api.Controllers.VansaleController.PostToFocusVansaleTransactions(Int32 transId, Int32 docType, Boolean isEdit, Boolean isForIssue, Nullable`1 chequeDate) 2025-10-08 15:36:48.733 +05:30 f634acd8-b46e-434c-bae6-bf6f11c70571 ERR Failed to delete Sales in Focus. 2025-10-08 15:46:08.153 +05:30 2611227d-97ad-4a28-8a64-fb54414d3767 ERR Error occured executing stored procedure ssp_t_PostFocus: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'iVendor'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) ClientConnectionId:e5b571bb-2c42-4d44-97c6-97c4e26d9639 Error Number:207,State:1,Class:16 2025-10-08 15:46:08.156 +05:30 2611227d-97ad-4a28-8a64-fb54414d3767 ERR Invalid column name 'iVendor'. 2025-10-08 15:46:08.160 +05:30 2611227d-97ad-4a28-8a64-fb54414d3767 ERR Error occurred.System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'iVendor'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.CommonRepository.GetDataSet(String storedProcedureName, SqlParameter[] parameters, Boolean extendTimeOutToInfinity) at Sang.FocusIntegration.Api.Repositories.GsgRepository.GetScreenAndRequest(Int32 transId, Int32 be, Int32 docType) at Sang.FocusIntegration.Api.Services.GsgService.GetScreenAndRequest(Int32 transId, Int32 be, Int32 docType) at Sang.FocusIntegration.Api.Controllers.GsgController.PostToFocusGsgTransactions(Int32 transId, Int32 docType, Int32 be, Int32 countryId) ClientConnectionId:e5b571bb-2c42-4d44-97c6-97c4e26d9639 Error Number:207,State:1,Class:16 2025-10-08 18:54:16.674 +05:30 4d0784d8-7b53-4429-9d65-9b1d4f532bc3 ERR Failed to delete Sales in Focus. 2025-10-08 20:16:21.062 +05:30 2c5fac13-2e83-4fa4-a895-32a424e995ff ERR Failed to delete Sales in Focus. 2025-10-08 20:16:40.202 +05:30 0ca0f705-91e4-4b5c-8884-2c8c93183a2c ERR Failed to delete Sales in Focus. 2025-10-08 20:59:57.408 +05:30 875a4255-77a5-407f-8b0e-9f163f4baeac ERR Error occurred while excecuting procedure:xsp_t_Receipt_PT: System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 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) at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.FocusIntegration.Api.Repositories.CommonRepository.ExecuteScalar[T](String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) ClientConnectionId:93a376ec-bc36-4b2d-89fc-ed781f4200e9 Error Number:512,State:1,Class:16 2025-10-08 20:59:57.427 +05:30 875a4255-77a5-407f-8b0e-9f163f4baeac ERR Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 2025-10-08 20:59:57.430 +05:30 875a4255-77a5-407f-8b0e-9f163f4baeac ERR Error Getting request for Receipt Transaction. System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 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) at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.FocusIntegration.Api.Repositories.CommonRepository.ExecuteScalar[T](String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.FocusIntegration.Api.Repositories.VansaleRepository.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) ClientConnectionId:93a376ec-bc36-4b2d-89fc-ed781f4200e9 Error Number:512,State:1,Class:16 2025-10-08 20:59:57.431 +05:30 875a4255-77a5-407f-8b0e-9f163f4baeac ERR Error occurred.System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 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) at System.Data.SqlClient.SqlCommand.CompleteAsyncExecuteReader() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.FocusIntegration.Api.Repositories.CommonRepository.ExecuteScalar[T](String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.FocusIntegration.Api.Repositories.VansaleRepository.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) at Sang.FocusIntegration.Api.Services.VansaleService.GetRequest(Int32 transId, Int32 docType, Boolean isForIssue) at Sang.FocusIntegration.Api.Controllers.VansaleController.PostToFocusVansaleTransactions(Int32 transId, Int32 docType, Boolean isEdit, Boolean isForIssue, Nullable`1 chequeDate) ClientConnectionId:93a376ec-bc36-4b2d-89fc-ed781f4200e9 Error Number:512,State:1,Class:16