--------------------------------------------------------------- Log Entry : 1/23/2024 10:13:44 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"","sCode":"","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":null,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:14:09 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"hg","sCode":"","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":null,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:14:17 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"hg","sCode":"cv","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":null,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:15:57 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"hg","sCode":"cv","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":null,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:17:17 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"hg","sCode":"cv","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":1,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:17:32 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"hg","sCode":"cv","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":1,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:17:50 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"hg","sCode":"cv","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":1,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:29:59 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"","sCode":"","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":null,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:30:15 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"fgg","sCode":"hhhj","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":null,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:30:26 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"fgg","sCode":"hhhj","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"","sPhone":"","iType":2,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:30:39 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"fgg","sCode":"hhhj","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"999988888844444","sPhone":"","iType":2,"iUser":2,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 1/23/2024 10:34:40 AM - ------------------------------------------------------------- TransactionController Method:DeleteRouteplan System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value 'string' to data type int. 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) at Sang.VanSales.WebApi.Controllers.TransactionController.DeleteRouteplan(DeleteRouteplan obj) ClientConnectionId:19f4a5e6-d1a2-4d18-9bc5-10fd2cb31a1b Error Number:245,State:1,Class:16 --------------------------------------------------------------- Log Entry : 1/23/2024 11:33:00 AM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'iSuspend'. Invalid column name 'iSuspendedBy'. Invalid column name 'iSuspendedOn'. 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) at Sang.VanSales.WebApi.Controllers.TransactionController.SuspendAllTransactions(SuspendObjTrans obj) ClientConnectionId:fe6a1cc9-4d80-4cc9-a444-b018fc4f4529 Error Number:207,State:1,Class:16 --------------------------------------------------------------- Log Entry : 1/23/2024 11:44:57 AM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'iSuspend'. Invalid column name 'iSuspendedBy'. Invalid column name 'iSuspendedOn'. 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) at Sang.VanSales.WebApi.Controllers.TransactionController.SuspendAllTransactions(SuspendObjTrans obj) ClientConnectionId:9ef3bdde-bb5a-4508-8156-2630290bab94 Error Number:207,State:1,Class:16 --------------------------------------------------------------- Log Entry : 1/23/2024 11:59:24 AM - ------------------------------------------------------------- TransactionController Method:GetNextDocNo System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value 'ROUT-1-12' to data type int. at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.VanSales.WebApi.Controllers.TransactionController.GetNextDocNo(Int32 iUser, Int32 iDocType) ClientConnectionId:f38a2aff-57b0-49d0-be8d-1a3ef920cb7d Error Number:245,State:1,Class:16 --------------------------------------------------------------- Log Entry : 1/23/2024 11:59:37 AM - ------------------------------------------------------------- TransactionController Method:GetNextDocNo System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value 'ROUT-1-12' to data type int. at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.VanSales.WebApi.Controllers.TransactionController.GetNextDocNo(Int32 iUser, Int32 iDocType) ClientConnectionId:f38a2aff-57b0-49d0-be8d-1a3ef920cb7d Error Number:245,State:1,Class:16 --------------------------------------------------------------- Log Entry : 1/23/2024 12:00:35 PM - ------------------------------------------------------------- TransactionController Method:GetNextDocNo System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value 'ROUT-1-12' to data type int. at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.VanSales.WebApi.Controllers.TransactionController.GetNextDocNo(Int32 iUser, Int32 iDocType) ClientConnectionId:41b8084e-80bf-4e38-aeaf-25cd9e865f94 Error Number:245,State:1,Class:16 --------------------------------------------------------------- Log Entry : 1/23/2024 12:33:58 PM - ------------------------------------------------------------- TransactionController Method:PostRouteplan System.NullReferenceException: Object reference not set to an instance of an object. at Sang.VanSales.WebApi.Controllers.TransactionController.PostRouteplan(Route obj) --------------------------------------------------------------- Log Entry : 1/23/2024 1:13:37 PM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'iSuspend'. Invalid column name 'iSuspendedBy'. Invalid column name 'iSuspendedOn'. 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) at Sang.VanSales.WebApi.Controllers.TransactionController.SuspendAllTransactions(SuspendObjTrans obj) ClientConnectionId:47e233bd-8745-462c-9f4f-58ac37ce5bd5 Error Number:207,State:1,Class:16 --------------------------------------------------------------- Log Entry : 1/23/2024 2:11:40 PM - ------------------------------------------------------------- TransactionController Method:DeleteAllTransactions 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) at Sang.VanSales.WebApi.Controllers.TransactionController.DeleteAllTransactions(DeleteObjTrans obj) ClientConnectionId:4c87f199-fedd-4e36-8da1-438412b4b58c Error Number:156,State:1,Class:15