--------------------------------------------------------------- Log Entry : 6/11/2024 9:47:24 AM - ------------------------------------------------------------- TransactionController Method:GetNextDocNo System.Data.SqlClient.SqlException (0x80131904): Invalid object name 't_t_Replacement'. 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:aaa4b936-7f95-4910-96e5-33f097df06ab Error Number:208,State:1,Class:16 --------------------------------------------------------------- Log Entry : 6/11/2024 10:02:53 AM - ------------------------------------------------------------- TransactionController Method:GetNextDocNo System.Data.SqlClient.SqlException (0x80131904): Invalid object name 't_t_Replacement'. 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:99604818-21a8-4e9e-8a27-a0d70aeaf0bb Error Number:208,State:1,Class:16 --------------------------------------------------------------- Log Entry : 6/11/2024 12:56:09 PM - ------------------------------------------------------------- TransactionController Method:RouteplanDetails 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.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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.RouteplanDetails(Int32 iTransId) ClientConnectionId:f630bfd6-effa-4931-9e13-1f9662cba041 Error Number:245,State:1,Class:16 --------------------------------------------------------------- Log Entry : 6/11/2024 12:56:09 PM - ------------------------------------------------------------- TransactionController Method:RouteplanDetails 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.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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.RouteplanDetails(Int32 iTransId) ClientConnectionId:f630bfd6-effa-4931-9e13-1f9662cba041 Error Number:245,State:1,Class:16 --------------------------------------------------------------- Log Entry : 6/11/2024 12:56:16 PM - ------------------------------------------------------------- TransactionController Method:RouteplanDetails 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.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping) at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue) at System.Data.Common.DataAdapter.Fill(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) 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.RouteplanDetails(Int32 iTransId) ClientConnectionId:f630bfd6-effa-4931-9e13-1f9662cba041 Error Number:245,State:1,Class:16 --------------------------------------------------------------- Log Entry : 6/11/2024 4:11:30 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"princhu_salesman","sCode":"ps","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 6/11/2024 4:11:56 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"princhu_driver","sCode":"pd","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 6/11/2024 4:12:12 PM - ------------------------------------------------------------- check customer {"iId":1038,"sName":"princhu_web","sCode":"ps","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 6/11/2024 4:12:38 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"princhu","sCode":"pp","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":0} --------------------------------------------------------------- Log Entry : 6/11/2024 4:13:33 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"princhu","sCode":"pp","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":true,"iParentId":0} --------------------------------------------------------------- Log Entry : 6/11/2024 4:13:46 PM - ------------------------------------------------------------- check customer {"iId":1039,"sName":"princhu_driver","sCode":"pd","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":1041} --------------------------------------------------------------- Log Entry : 6/11/2024 4:14:00 PM - ------------------------------------------------------------- check customer {"iId":1038,"sName":"princhu_web","sCode":"ps","sAltName":"","iWarehouse":0,"iUser":1,"bGroup":false,"iParentId":1041} --------------------------------------------------------------- Log Entry : 6/11/2024 4:18:19 PM - ------------------------------------------------------------- check customer {"iId":0,"sName":"Pranima","sCode":"prani","sAltName":"","iCreditDays":"","fCreditAmount":0.00,"sAddress":"","sCity":"","sCountry":"","sPincode":"","sMobile":"098765123456789","sPhone":"","iType":1,"iUser":1,"sGeoLocation":"","sTRN_No":"","bGroup":0,"iParentId":0,"sEmail":"pranima@gmail.com","sContactPersonNo":"","sFax":"","sWebsite":""} --------------------------------------------------------------- Log Entry : 6/11/2024 4:20:24 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Icecream","sCode":"ici","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 : 6/11/2024 4:22:44 PM - ------------------------------------------------------------- check Product {"iId":0,"sName":"Rice flour","sCode":"rf","sAltName":"","iType":1,"fVatPer":0.0,"fTaxper":0.0,"fCostPrice":0.0,"fSellingPrice":0.0,"bBatch":1,"iUser":1,"bGroup":0,"iParentId":0,"sBarcode":"","iBaseUnit":1,"Body":[]}