------------------------------------------- 6/18/2021 3:37:26 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 3:37:41 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 3:38:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 3:38:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 3:38:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 3:38:42 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18033842', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:39:34 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18033934', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:40:55 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18034055', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:42:07 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18034207', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:45:15 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18034515', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:46:37 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18034637', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:50:31 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18035031', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:51:43 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18035143', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:52:07 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18035207', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:53:16 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18035316', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:53:59 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18035359', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 3:54:44 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18035444', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 4:28:10 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 4:28:13 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 4:28:13 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 4:55:33 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 4:55:33 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 5:11:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 5:11:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 5:12:24 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 6/18/2021 5:12:27 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 6/18/2021 5:12:41 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 6/18/2021 5:12:54 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 6/18/2021 5:14:13 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 17 Jun 2021 ------------------------------------------- 6/18/2021 5:15:03 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 6/18/2021 5:15:20 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 5:15:33 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 5:15:39 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 17 Jun 2021 ------------------------------------------- 6/18/2021 5:15:43 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 5:16:06 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 17 Jun 2021 ------------------------------------------- 6/18/2021 5:17:11 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000000000042021Jun18051711', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 5:17:22 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 17 Jun 2021 ------------------------------------------- 6/18/2021 5:17:24 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000000000042021Jun18051724', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 5:17:27 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000000000042021Jun18051727', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 5:17:31 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS', 'MNTHYR', '0000000000000042021Jun18051731', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 5:17:32 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 17 Jun 2021 ------------------------------------------- 6/18/2021 5:17:56 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 17 Jun 2021 ------------------------------------------- 6/18/2021 5:18:07 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 17 Jun 2021 ------------------------------------------- 6/18/2021 5:18:21 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 17 Jun 2021 ------------------------------------------- 6/18/2021 5:18:34 AM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 17 Jun 2021 ------------------------------------------- 6/18/2021 5:33:43 AM Linking Class, FillGrid Function ### After dgItemLink.DataBind() ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 6/18/2021 5:33:45 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 6/18/2021 5:33:46 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 6/18/2021 5:33:57 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 6/18/2021 5:38:50 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 5:38:50 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 6:15:28 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 6:15:28 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 6:54:41 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 6:54:53 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 6:54:53 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 6:55:33 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 6:55:40 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 6:56:05 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18065605', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 6:56:59 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18065659', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 6:57:43 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 6:57:43 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 6:57:59 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE', 'YRMNTH', '0000000000009982021Jun18065759', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' ------------------------------------------- 6/18/2021 7:04:39 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 7:04:39 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 7:30:58 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 7:30:58 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 7:40:04 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 7:40:04 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 8:00:59 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 6/18/2021 8:10:54 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 6/18/2021 8:10:56 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 6/18/2021 8:11:01 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 6/18/2021 8:11:10 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 6/18/2021 8:12:26 AM Linking Class, GetBranchId Function ### After ExecuteScalar ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 6/18/2021 8:12:27 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 6/18/2021 8:12:30 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 6/18/2021 8:12:33 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 6/18/2021 8:18:54 AM Export Class, Export To Text Function ### Export Class, Export Master Excel Function, End ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 6/18/2021 8:18:56 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 6/18/2021 8:18:57 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 6/18/2021 8:19:09 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 6/18/2021 9:21:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 9:21:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 9:23:08 AM Linking Class, FillGrid Function ### After OdbcConnection ### Linking Class, FillGrid Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. ------------------------------------------- 6/18/2021 9:23:08 AM Linking Class, FillGrid Function ### After call to the FillGrid function ### DiffReport.aspx.cs:In FillGrid() Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) 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, String srcTable) at DataQCItemLinkTransMismatch.FillGrid() ------------------------------------------- 6/18/2021 9:23:17 AM Linking Class, FillGrid Function ### After OdbcConnection ### Linking Class, FillGrid Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. ------------------------------------------- 6/18/2021 9:23:17 AM Linking Class, FillGrid Function ### After call to the FillGrid function ### DiffReport.aspx.cs:In FillGrid() Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) 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, String srcTable) at DataQCItemLinkTransMismatch.FillGrid() ------------------------------------------- 6/18/2021 9:23:23 AM Linking Class, FillGrid Function ### After OdbcConnection ### Linking Class, FillGrid Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. ------------------------------------------- 6/18/2021 9:23:23 AM Linking Class, FillGrid Function ### After call to the FillGrid function ### DiffReport.aspx.cs:In FillGrid() Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prCheckTransItemLinkedMissing' expects parameter '@BranchId', which was not supplied. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) 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, String srcTable) at DataQCItemLinkTransMismatch.FillGrid() ------------------------------------------- 6/18/2021 9:55:02 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 9:55:02 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 10:04:41 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 6/18/2021 10:04:41 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 6/18/2021 10:04:43 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 6/18/2021 10:04:45 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 6/18/2021 10:06:41 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 10:06:41 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 10:17:08 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 10:17:08 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 11:11:53 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 11:11:53 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 12:14:37 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 12:14:37 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 1:38:23 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/18/2021 1:38:23 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/18/2021 1:39:41 PM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 6/18/2021 1:39:50 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 1:39:53 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 1:40:02 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.Substring(Int32 startIndex, Int32 length) at ReportCriterias.getColumns() ------------------------------------------- 6/18/2021 1:40:52 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,DIVISION', 'MNTHYR', '0000000000000062021Jun18014052', '0', '<>0', 'SALE', '000000000000006', 0, '', '','DISTRIBUTOR','0','','2','3','False','False','True','1' 6/18/2021 6:00:02 PM processDataUsingPostTableXML ### dtFinalFav Count = 5 6/18/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 6/18/2021 6:00:02 PM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Jun18233002023 ### SELECT distinct cast(cast(t.distributorid as int) as varchar) + replace(convert(varchar(8), getdate(), 112)+convert(varchar(8), getdate(), 114), ':','') as ID,cast(getdate() as varchar(50)) as ScheduledDateTime,Distributor,t.LastImportDate,LastInvoiceDate FROM filewisehashcode t INNER JOIN (SELECT distributorid,MAX(LastImportDate) LastImportDate FROM filewisehashcode where filetype='IN' GROUP BY distributorid) MaxDate ON t.distributorid = MaxDate.distributorid AND t.LastImportDate = MaxDate.LastImportDate Inner join pdistributor pd on t.DistributorId=pd.DistributorId inner join usermaster um on pd.UserId=um.id where pd.IsActive =1 and t.MinDate IS NOT NULL and datediff(day,( CAST ( MaxDate.LastImportDate as Date)) ,( cast(GETDATE() as DATE) )) >10 6/18/2021 6:00:02 PM Post Favourite ### After Fill DataSet 6/18/2021 6:00:02 PM Excel Favourite Report ### Html Case 6/18/2021 6:00:02 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 18Jun2021060002.html 6/18/2021 6:00:02 PM Excel Favourite Report ### After Checking File Exist Or Create New File 6/18/2021 6:00:02 PM Excel Favourite Report ### After Writing to File 6/18/2021 6:00:02 PM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Jun18233002023 6/18/2021 6:00:02 PM processDataUsingPostTableXML ### Create Zip 6/18/2021 6:00:02 PM processDataUsingPostTableXML ### Added PendingXml 6/18/2021 6:00:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/18/2021 6:00:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/18/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 6/18/2021 6:00:02 PM processDataUsingPostTableXML strScript for Bayer Zylem S3 Daily Audit Log 2021Jun18233002080 ### EXEC prZylemAuditLogReport '','','','','','','','' 6/18/2021 6:00:02 PM processDataUsingPostTableXML,Error while executing procedure :EXEC prZylemAuditLogReport '','','','','','','','', Error: ### INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. 6/18/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 6/18/2021 6:00:02 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Jun18233002120 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 6/18/2021 6:00:04 PM Post Favourite ### After Fill DataSet 6/18/2021 6:00:04 PM Excel Favourite Report ### Excel Case 6/18/2021 6:00:04 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 18Jun2021060004.xls 6/18/2021 6:00:04 PM Excel Favourite Report ### After Checking File Exist Or Create New File 6/18/2021 6:00:04 PM Excel Favourite Report ### After Writing to File 6/18/2021 6:00:04 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Jun18233002120 6/18/2021 6:00:04 PM processDataUsingPostTableXML ### Create Zip 6/18/2021 6:00:04 PM processDataUsingPostTableXML ### Added PendingXml 6/18/2021 6:00:04 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/18/2021 6:00:04 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/18/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 6/18/2021 6:00:04 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Jun18233002167 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'CS' 6/18/2021 6:00:08 PM Post Favourite ### After Fill DataSet 6/18/2021 6:00:08 PM Excel Favourite Report ### Excel Case 6/18/2021 6:00:09 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 18Jun2021060008.xls 6/18/2021 6:00:09 PM Excel Favourite Report ### After Checking File Exist Or Create New File 6/18/2021 6:00:09 PM Excel Favourite Report ### After Writing to File 6/18/2021 6:00:09 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Jun18233002167 6/18/2021 6:00:09 PM processDataUsingPostTableXML ### Create Zip 6/18/2021 6:00:10 PM processDataUsingPostTableXML ### Added PendingXml 6/18/2021 6:00:10 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/18/2021 6:00:10 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/18/2021 6:00:10 PM ProcessData ### Inside Pre Processed Report 6/18/2021 6:00:10 PM processDataUsingPostTableXML strScript for Bayer Zylem S3 unmapped product count 2021Jun18233002213 ### EXEC prUnMappedproductCount_BAYER 6/18/2021 6:01:41 PM Post Favourite ### After Fill DataSet 6/18/2021 6:01:41 PM Excel Favourite Report ### Excel Case 6/18/2021 6:01:42 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_Bayer Zylem S3 unmapped product count 18Jun2021060141.xls 6/18/2021 6:01:42 PM Excel Favourite Report ### After Checking File Exist Or Create New File 6/18/2021 6:01:42 PM Excel Favourite Report ### After Writing to File 6/18/2021 6:01:42 PM processDataUsingPostTableXML ### Write PendingXml Bayer Zylem S3 unmapped product count 2021Jun18233002213 6/18/2021 6:01:42 PM processDataUsingPostTableXML ### Create Zip 6/18/2021 6:01:42 PM processDataUsingPostTableXML ### Added PendingXml 6/18/2021 6:01:42 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/18/2021 6:01:42 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/18/2021 6:01:42 PM processDataUsingPostTableXML ### Finished 6/18/2021 6:01:42 PM processDataUsingPostTableXML ### End