Time Stamp: 06/20/2025 07:52:45 AM Exception Type: Error Message: Incorrect syntax near ')'. Source: .Net SqlClient Data Provider Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Stack Trace: at System.Data.SqlClient.SqlConnection.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.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 SFA.DataLayer.DataObjects.Db.GetDataSet(String spName, DbParam[] spParams, Nullable`1 Timeout) at SFA.DataLayer.DataObjects.Db.GetDataSet(String spName, DbParam[] spParams) at SFA.DataLayer.DataObjects.Db.GetDataTable(String spName, DbParam[] spParams) at SFA.DataLayer.DataObjects.UserDeviceLogInLogDao.GetUserDeviceLogInLogSearch(String SortExpression, Int32 MaximumRows, Int32 StartRowIndex, String searchString, String UserCode) ======================================================================= Time Stamp: 06/20/2025 07:52:45 AM Exception Type: Error Message: Incorrect syntax near ')'. Source: .Net SqlClient Data Provider Target Site: Void OnError(System.Data.SqlClient.SqlException, Boolean, System.Action`1[System.Action]) Stack Trace: at System.Data.SqlClient.SqlConnection.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.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 SFA.DataLayer.DataObjects.Db.GetDataSet(String spName, DbParam[] spParams, Nullable`1 Timeout) at SFA.DataLayer.DataObjects.Db.GetDataSet(String spName, DbParam[] spParams) at SFA.DataLayer.DataObjects.Db.GetDataTable(String spName, DbParam[] spParams) at SFA.DataLayer.DataObjects.Db.GetDataRow(String spName, DbParam[] spParams) at SFA.DataLayer.DataObjects.UserDeviceLogInLogDao.GetUserDeviceLogInLogCountSearch(String searchString, String UserCode) ======================================================================= Time Stamp: 06/20/2025 06:17:03 PM Exception Type: Error Message: Thread was being aborted. Source: App_Web_exportdata.aspx.f9b0821e.wiso5ia8 Target Site: SFA.BusinessLayer.BusinessObjects.OrdersReport GetTrxHeaderSearchReportExport_Preseller(System.String, System.String, System.String, Boolean) Stack Trace: at pages_ExportData.GetTrxHeaderSearchReportExport_Preseller(String SortExpression, String searchString, String UserCode, Boolean IsLoaded) at pages_ExportData.ExportManagePresellerOrders(String strFileName) ======================================================================= Time Stamp: 06/20/2025 06:32:33 PM Exception Type: Error Message: Thread was being aborted. Source: App_Web_exportdata.aspx.f9b0821e.wiso5ia8 Target Site: SFA.BusinessLayer.BusinessObjects.OrdersReport GetTrxHeaderSearchReportExport_Preseller(System.String, System.String, System.String, Boolean) Stack Trace: at pages_ExportData.GetTrxHeaderSearchReportExport_Preseller(String SortExpression, String searchString, String UserCode, Boolean IsLoaded) at pages_ExportData.ExportManagePresellerOrders(String strFileName) ======================================================================= Time Stamp: 06/20/2025 06:44:37 PM Exception Type: Error Message: Thread was being aborted. Source: App_Web_exportdata.aspx.f9b0821e.wiso5ia8 Target Site: SFA.BusinessLayer.BusinessObjects.OrdersReport GetTrxHeaderSearchReportExport_Preseller(System.String, System.String, System.String, Boolean) Stack Trace: at pages_ExportData.GetTrxHeaderSearchReportExport_Preseller(String SortExpression, String searchString, String UserCode, Boolean IsLoaded) at pages_ExportData.ExportManagePresellerOrders(String strFileName) ======================================================================= Time Stamp: 06/20/2025 06:48:11 PM Exception Type: Error Message: Thread was being aborted. Source: App_Web_exportdata.aspx.f9b0821e.wiso5ia8 Target Site: SFA.BusinessLayer.BusinessObjects.OrdersReport GetTrxHeaderSearchReportExport_Preseller(System.String, System.String, System.String, Boolean) Stack Trace: at pages_ExportData.GetTrxHeaderSearchReportExport_Preseller(String SortExpression, String searchString, String UserCode, Boolean IsLoaded) at pages_ExportData.ExportManagePresellerOrders(String strFileName) =======================================================================