--------------------------------------------------------------- Log Entry : 5/6/2024 10:24:22 AM - ------------------------------------------------------------- check customer {"iId":0,"sName":"linet","sCode":"991","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 5/6/2024 10:30:31 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"headphones","sCode":"436","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"235436546547","iBaseUnit":15,"Body":[]} --------------------------------------------------------------- Log Entry : 5/6/2024 10:30:39 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"headphones","sCode":"87","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"235436546547","iBaseUnit":15,"Body":[]} --------------------------------------------------------------- Log Entry : 5/6/2024 10:31:06 AM - ------------------------------------------------------------- check Product {"iId":1074,"sName":"headphones","sCode":"hp","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":15,"Body":[]} --------------------------------------------------------------- Log Entry : 5/6/2024 10:32:37 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Meat","sCode":"324","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"2098","iBaseUnit":1,"Body":[]} --------------------------------------------------------------- Log Entry : 5/6/2024 10:33:35 AM - ------------------------------------------------------------- check Product {"iId":1075,"sName":"Meat","sCode":"324","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"2098","iBaseUnit":1,"Body":[]} --------------------------------------------------------------- Log Entry : 5/6/2024 10:58:16 AM - ------------------------------------------------------------- path=C:\inetpub\wwwroot\Sang.Vansales.Web.Api\Report\RequestRPT.rpt --------------------------------------------------------------- Log Entry : 5/6/2024 10:58:19 AM - ------------------------------------------------------------- iTransid=1097 --------------------------------------------------------------- Log Entry : 5/6/2024 10:58:19 AM - ------------------------------------------------------------- iDoctype=6 --------------------------------------------------------------- Log Entry : 5/6/2024 10:58:19 AM - ------------------------------------------------------------- TransactionController Method: MaxTrans System.Runtime.InteropServices.COMException (0x8002000B): Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) at CrystalDecisions.ReportAppServer.DataDefModel.FieldsClass.get_Item(Int32 Index) at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions.get_Item(Int32 index) at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions.get_Item(String fieldName) at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetParameterValue(String name, Object val) at Sang.VanSales.WebApi.Controllers.TransactionController.CrystalPrint(Int32 iTransId, Int32 iDoctype) --------------------------------------------------------------- Log Entry : 5/6/2024 10:58:20 AM - ------------------------------------------------------------- path=C:\inetpub\wwwroot\Sang.Vansales.Web.Api\Report\RequestRPT.rpt --------------------------------------------------------------- Log Entry : 5/6/2024 10:58:20 AM - ------------------------------------------------------------- iTransid=1097 --------------------------------------------------------------- Log Entry : 5/6/2024 10:58:20 AM - ------------------------------------------------------------- iDoctype=6 --------------------------------------------------------------- Log Entry : 5/6/2024 10:58:20 AM - ------------------------------------------------------------- TransactionController Method: MaxTrans System.Runtime.InteropServices.COMException (0x8002000B): Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX)) at CrystalDecisions.ReportAppServer.DataDefModel.FieldsClass.get_Item(Int32 Index) at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions.get_Item(Int32 index) at CrystalDecisions.CrystalReports.Engine.ParameterFieldDefinitions.get_Item(String fieldName) at CrystalDecisions.CrystalReports.Engine.ReportDocument.SetParameterValue(String name, Object val) at Sang.VanSales.WebApi.Controllers.TransactionController.CrystalPrint(Int32 iTransId, Int32 iDoctype) --------------------------------------------------------------- Log Entry : 5/6/2024 11:55:39 AM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_SuspendTransactions' expects parameter '@iTransId', which was not supplied. 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:9f340f11-6695-4abd-b987-2f109a1fb115 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 5/6/2024 11:57:41 AM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_SuspendTransactions' expects parameter '@iTransId', which was not supplied. 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:ac72b449-0443-4323-9bbf-94e6dd26d875 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 5/6/2024 11:59:29 AM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_SuspendTransactions' expects parameter '@iTransId', which was not supplied. 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:ac72b449-0443-4323-9bbf-94e6dd26d875 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 5/6/2024 12:16:59 PM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_SuspendTransactions' expects parameter '@iTransId', which was not supplied. 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:ffb55558-fa29-4c75-8f0f-aaf43215eea1 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 5/6/2024 12:17:24 PM - ------------------------------------------------------------- TransactionController Method:SuspendAllTransactions System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_SuspendTransactions' expects parameter '@iTransId', which was not supplied. 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:ffb55558-fa29-4c75-8f0f-aaf43215eea1 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 5/6/2024 1:57:20 PM - ------------------------------------------------------------- TransactionController Method:DeleteAllTransactions System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_WEB_DeleteTransactions' expects parameter '@iTransId', which was not supplied. 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:974944eb-e936-4c25-8daa-f645184ce2cb Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 5/6/2024 1:57:48 PM - ------------------------------------------------------------- TransactionController Method:DeleteAllTransactions System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_WEB_DeleteTransactions' expects parameter '@iTransId', which was not supplied. 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:974944eb-e936-4c25-8daa-f645184ce2cb Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 5/6/2024 3:34:02 PM - ------------------------------------------------------------- TransactionController Method:GetAllTransactionSummary System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'iSuspend'. at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.VanSales.WebApi.Controllers.TransactionController.GetAllTransactionSummary(Int32 DisplayLength, Int32 DisplayStart, Int32 iUserId, Int32 iMaster, Int32 iDocType, String Search) ClientConnectionId:97555fd0-322c-4bbe-8349-5f8d7220445c Error Number:207,State:1,Class:16