--------------------------------------------------------------- Log Entry : 1/10/2024 9:25:04 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"abc","sCode":"abccode1","sAltName":"","iWarehouse":13,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 9:25:20 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"nhbt","sCode":"abccode1","sAltName":"","iWarehouse":14,"iUser":2,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 9:56:41 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"string","sCode":"string","sAltName":"string","iWarehouse":0,"iUser":0,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 9:58:23 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"","sCode":"","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 9:58:31 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"test","sCode":"","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 9:58:51 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"test","sCode":"code10.1","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 10:00:23 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"test","sCode":"code10.1","sAltName":"alt10","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 10:00:36 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"test","sCode":"code10.1","sAltName":"alt10","iWarehouse":14,"iUser":2,"bGroup":false,"iParentId":3} --------------------------------------------------------------- Log Entry : 1/10/2024 10:48:51 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"","sCode":"","sAltName":"","iWarehouse":0,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 10:48:54 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"","sCode":"","sAltName":"","iWarehouse":0,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 10:48:59 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"ss","sCode":"","sAltName":"","iWarehouse":0,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 10:49:04 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"ss","sCode":"ww","sAltName":"","iWarehouse":0,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 10:49:25 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"ss","sCode":"ww","sAltName":"","iWarehouse":0,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 10:49:29 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"ss","sCode":"ww","sAltName":"","iWarehouse":13,"iUser":3,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 11:35:26 AM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'set'. 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.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 Sang.VanSales.WebApi.General.ClassDB.ExecuteNonQuery(String commandText, CommandType commandType, SqlParameter[] parameters) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\General\ClassDB.cs:line 98 at Sang.VanSales.WebApi.Controllers.TransactionController.SuspendAllTransactions(SuspendObjTrans obj) in C:\sMax\Sang.VanSales.WebApi\Sang.VanSales.WebApi\Controllers\TransactionController.cs:line 84 ClientConnectionId:aff87a99-1857-4ca4-a9e2-e070120d7768 Error Number:156,State:1,Class:15 --------------------------------------------------------------- Log Entry : 1/10/2024 3:32:00 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"","sCode":"","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 3:32:16 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"DriveMan","sCode":"","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 3:32:20 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"DriveMan","sCode":"agb4","sAltName":"","iWarehouse":0,"iUser":2,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 1/10/2024 3:32:26 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"DriveMan","sCode":"agb4","sAltName":"","iWarehouse":14,"iUser":2,"bGroup":false,"iParentId":0}