--------------------------------------------------------------- Log Entry : 8/13/2024 9:59:33 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Kitkat","sCode":"Kitkat","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":3,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":15,"Body":[]} --------------------------------------------------------------- Log Entry : 8/13/2024 10:00:47 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"PhulkaRoti","sCode":"PhulkaRoti","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":3,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":19,"Body":[{"iUnit":3,"sBarcode":"","nConversion":434.0},{"iUnit":1,"sBarcode":"","nConversion":3000.0}]} --------------------------------------------------------------- Log Entry : 8/13/2024 10:00:47 AM - ------------------------------------------------------------- VanSalesController Method:PostProduct System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting numeric to data type numeric. The data for table-valued parameter "@t_type_ProductUnit" doesn't conform to the table type of the parameter. SQL Server error is: 8115, state: 8 The statement has been terminated. 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 Sang.VanSales.WebApi.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.VanSales.WebApi.Controllers.VanSalesController.PostProduct(InsProductDetails obj) ClientConnectionId:1ac5e6db-6305-4c14-99b7-fefa9375e1e2 Error Number:8115,State:8,Class:16 --------------------------------------------------------------- Log Entry : 8/13/2024 10:11:51 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"PhulkaRoti","sCode":"PhulkaRoticode","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":3,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":19,"Body":[{"iUnit":3,"sBarcode":"","nConversion":434.0},{"iUnit":1,"sBarcode":"","nConversion":3000.0}]} --------------------------------------------------------------- Log Entry : 8/13/2024 10:11:51 AM - ------------------------------------------------------------- VanSalesController Method:PostProduct System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting numeric to data type numeric. The data for table-valued parameter "@t_type_ProductUnit" doesn't conform to the table type of the parameter. SQL Server error is: 8115, state: 8 The statement has been terminated. 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 Sang.VanSales.WebApi.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.VanSales.WebApi.Controllers.VanSalesController.PostProduct(InsProductDetails obj) ClientConnectionId:c7c5c05c-23c2-4ded-b7c3-f5a0909a2b9d Error Number:8115,State:8,Class:16 --------------------------------------------------------------- Log Entry : 8/13/2024 10:12:05 AM - ------------------------------------------------------------- check Product {"iId":0,"sName":"PhulkaRoti","sCode":"PhulkaRoticode","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":3,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":19,"Body":[{"iUnit":3,"sBarcode":"","nConversion":434.0},{"iUnit":1,"sBarcode":"","nConversion":222.0}]} --------------------------------------------------------------- Log Entry : 8/13/2024 10:27:04 AM - ------------------------------------------------------------- TransactionController Method:PostOffload System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_Web_Ins_Offload' expects parameter '@iVWarehouse', 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.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 Sang.VanSales.WebApi.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.VanSales.WebApi.Controllers.TransactionController.PostOffload(InsOffload obj) ClientConnectionId:8f7640bb-0900-42cf-8ebb-7f3e6fc1b0f9 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 8/13/2024 10:31:15 AM - ------------------------------------------------------------- TransactionController Method:PostOffload System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'xsp_t_Web_Ins_Offload' expects parameter '@iVWarehouse', 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.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 Sang.VanSales.WebApi.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.VanSales.WebApi.Controllers.TransactionController.PostOffload(InsOffload obj) ClientConnectionId:122df842-3458-44fc-9bfd-f89c4eb18744 Error Number:201,State:4,Class:16 --------------------------------------------------------------- Log Entry : 8/13/2024 10:31:44 AM - ------------------------------------------------------------- TransactionController Method:PostStockIn System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. 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 Sang.VanSales.WebApi.General.ClassDB.GetDataSet(String commandText, CommandType commandType, SqlParameter[] parameters) at Sang.VanSales.WebApi.Controllers.TransactionController.PostStockIn(StockIn obj) ClientConnectionId:122df842-3458-44fc-9bfd-f89c4eb18744 Error Number:50000,State:3,Class:16 --------------------------------------------------------------- Log Entry : 8/13/2024 1:52:58 PM - ------------------------------------------------------------- check Product {"iId":2100,"sName":"PhulkaRoti","sCode":"PhulkaRoticode","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":19,"Body":[{"iUnit":1,"sBarcode":"","nConversion":222.0},{"iUnit":3,"sBarcode":"","nConversion":434.0}]} --------------------------------------------------------------- Log Entry : 8/13/2024 1:53:21 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"ed","sCode":"de3","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":0,"Body":[]} --------------------------------------------------------------- Log Entry : 8/13/2024 1:53:31 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"ed","sCode":"de3","sAltName":"","iType":2,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":0,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"1231","iBaseUnit":1,"Body":[]} --------------------------------------------------------------- Log Entry : 8/13/2024 8:03:13 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) ClientConnectionId:05db799b-7953-4f09-a67a-1a2e1162bd00 Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 8/13/2024 8:03:21 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) ClientConnectionId:a5212695-f418-49ed-8e48-45561917d549 Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 8/13/2024 8:03:24 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) ClientConnectionId:a5212695-f418-49ed-8e48-45561917d549 Error Number:242,State:3,Class:16 --------------------------------------------------------------- Log Entry : 8/13/2024 8:03:33 PM - ------------------------------------------------------------- ReportsController Method: VanSales System.Data.SqlClient.SqlException (0x80131904): The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. at Sang.VanSales.WebApi.General.ClassDB.GetDataTable(String commandText, CommandType commandType, List`1 parameters) at Sang.VanSales.WebApi.Controllers.ReportsController.GetReport(ReportModel obj) ClientConnectionId:60b31bdd-a7ab-4edb-b5b5-21c1891f0d6f Error Number:242,State:3,Class:16