------------------------------------------- 3/1/2021 4:54:26 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 3/1/2021 4:54:26 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 3/1/2021 5:43:34 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 3/1/2021 5:43:34 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 3/1/2021 5:45:29 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ZylemMasterTemplateImporting.aspx.cs :ReadCSVToTable() ### System.ArgumentException: Input array is longer than the number of columns in this table. at System.Data.DataRow.set_ItemArray(Object[] value) at ZylemMasterTemplateImporting.ReadCSVToTable(String path, String fileName, String columnName) ------------------------------------------- 3/1/2021 5:49:03 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ZylemMasterTemplateImporting.aspx.cs :ReadCSVToTable() ### System.ArgumentException: Input array is longer than the number of columns in this table. at System.Data.DataRow.set_ItemArray(Object[] value) at ZylemMasterTemplateImporting.ReadCSVToTable(String path, String fileName, String columnName) ------------------------------------------- 3/1/2021 5:58:51 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ZylemMasterTemplateImporting.aspx.cs :ReadCSVToTable() ### System.ArgumentException: Input array is longer than the number of columns in this table. at System.Data.DataRow.set_ItemArray(Object[] value) at ZylemMasterTemplateImporting.ReadCSVToTable(String path, String fileName, String columnName) ------------------------------------------- 3/1/2021 6:04:49 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ZylemMasterTemplateImporting.aspx.cs :ReadCSVToTable() ### System.ArgumentException: Input array is longer than the number of columns in this table. at System.Data.DataRow.set_ItemArray(Object[] value) at ZylemMasterTemplateImporting.ReadCSVToTable(String path, String fileName, String columnName) ------------------------------------------- 3/1/2021 6:08:09 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ZylemMasterTemplateImporting.aspx.cs :ReadCSVToTable() ### System.ArgumentException: Input array is longer than the number of columns in this table. at System.Data.DataRow.set_ItemArray(Object[] value) at ZylemMasterTemplateImporting.ReadCSVToTable(String path, String fileName, String columnName) ------------------------------------------- 3/1/2021 6:26:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 3/1/2021 6:26:24 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### GenClass Class, ReturnScaler Function ### System.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '000000000000041'. 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.ExecuteScalar() at GenClass.ReturnScaler(String connectionString, String Query) ------------------------------------------- 3/1/2021 6:49:06 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 3/1/2021 6:49:06 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 3/1/2021 6:51:23 AM GenClass Class, FillDropDown Function ### After getting ds from getDatasetForColumns() ### EditTracker.aspx.cs:fillValuesInControls() ### System.ArgumentException: Column '[Dealer Name]' does not belong to table Table. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at EditTracker.fillValuesInControls() ------------------------------------------- 3/1/2021 6:51:57 AM GenClass Class, FillDropDown Function ### After getting ds from getDatasetForColumns() ### EditTracker.aspx.cs:fillValuesInControls() ### System.ArgumentException: Column '[Dealer Name]' does not belong to table Table. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at EditTracker.fillValuesInControls() ------------------------------------------- 3/1/2021 6:53:04 AM GenClass Class, FillDropDown Function ### After getting ds from getDatasetForColumns() ### EditTracker.aspx.cs:fillValuesInControls() ### System.ArgumentException: Column '[Dealer Name]' does not belong to table Table. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at EditTracker.fillValuesInControls() ------------------------------------------- 3/1/2021 6:56:58 AM GenClass Class, FillDropDown Function ### After getting ds from getDatasetForColumns() ### EditTracker.aspx.cs:fillValuesInControls() ### System.ArgumentException: Column '[Dealer Name]' does not belong to table Table. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at EditTracker.fillValuesInControls() ------------------------------------------- 3/1/2021 6:57:08 AM GenClass Class, FillDropDown Function ### After getting ds from getDatasetForColumns() ### EditTracker.aspx.cs:fillValuesInControls() ### System.ArgumentException: Column '[Dealer Name]' does not belong to table Table. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at EditTracker.fillValuesInControls() ------------------------------------------- 3/1/2021 6:58:03 AM GenClass Class, FillDropDown Function ### After getting ds from getDatasetForColumns() ### EditTracker.aspx.cs:fillValuesInControls() ### System.ArgumentException: Column '[Dealer Name]' does not belong to table Table. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at EditTracker.fillValuesInControls() ------------------------------------------- 3/1/2021 7:04:37 AM GenClass Class, FillDropDown Function ### After getting ds from getDatasetForColumns() ### EditTracker.aspx.cs:fillValuesInControls() ### System.ArgumentException: Column '[Dealer Name]' does not belong to table Table. at System.Data.DataRow.GetDataColumn(String columnName) at System.Data.DataRow.get_Item(String columnName) at EditTracker.fillValuesInControls() ------------------------------------------- 3/1/2021 7:47:38 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 3/1/2021 7:47:39 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 3/1/2021 9:58:42 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 3/1/2021 9:58:42 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 3/1/2021 10:08:38 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 3/1/2021 10:10:46 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 3/1/2021 10:10:56 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 3/1/2021 10:11:00 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 3/1/2021 10:11:30 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM', 'MNTHYR,MONTH', '0000000000009982021Mar01101130', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','True','1' ------------------------------------------- 3/1/2021 10:11:57 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 3/1/2021 10:12:00 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 3/1/2021 10:12:08 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 3/1/2021 10:12:14 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM', 'MONTH,MNTHYR', '0000000000009982021Mar01101214', '0', '>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','True','1' ------------------------------------------- 3/1/2021 10:12:37 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM', 'MONTH,MNTHYR', '0000000000009982021Mar01101237', '0', '>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','True','1' ------------------------------------------- 3/1/2021 10:13:30 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 3/1/2021 10:13:33 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM', 'YRMNTH', '0000000000009982021Mar01101333', '0', '>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','True','1' ------------------------------------------- 3/1/2021 12:18:54 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 3/1/2021 12:19:07 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 3/1/2021 12:19:07 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 3/1/2021 6:00:03 PM processDataUsingPostTableXML ### dtFinalFav Count = 3 3/1/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 3/1/2021 6:00:03 PM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Mar01233003460 ### 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 3/1/2021 6:00:03 PM Post Favourite ### After Fill DataSet 3/1/2021 6:00:03 PM Excel Favourite Report ### Html Case 3/1/2021 6:00:03 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 01Mar2021060003.html 3/1/2021 6:00:03 PM Excel Favourite Report ### After Checking File Exist Or Create New File 3/1/2021 6:00:03 PM Excel Favourite Report ### After Writing to File 3/1/2021 6:00:03 PM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Mar01233003460 3/1/2021 6:00:03 PM processDataUsingPostTableXML ### Create Zip 3/1/2021 6:00:04 PM processDataUsingPostTableXML ### Added PendingXml 3/1/2021 6:00:04 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 3/1/2021 6:00:04 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 3/1/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 3/1/2021 6:00:04 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Mar01233003517 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'ES' 3/1/2021 6:00:28 PM Post Favourite ### After Fill DataSet 3/1/2021 6:00:28 PM Excel Favourite Report ### Excel Case 3/1/2021 6:00:28 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 01Mar2021060028.xls 3/1/2021 6:00:29 PM Excel Favourite Report ### After Checking File Exist Or Create New File 3/1/2021 6:00:29 PM Excel Favourite Report ### After Writing to File 3/1/2021 6:00:29 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Mar01233003517 3/1/2021 6:00:29 PM processDataUsingPostTableXML ### Create Zip 3/1/2021 6:00:29 PM processDataUsingPostTableXML ### Added PendingXml 3/1/2021 6:00:29 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 3/1/2021 6:00:29 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 3/1/2021 6:00:29 PM ProcessData ### Inside Pre Processed Report 3/1/2021 6:00:29 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Mar01233003557 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'CS' 3/1/2021 6:00:29 PM Post Favourite ### After Fill DataSet 3/1/2021 6:00:29 PM Excel Favourite Report ### Excel Case 3/1/2021 6:00:29 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 01Mar2021060029.xls 3/1/2021 6:00:29 PM Excel Favourite Report ### After Checking File Exist Or Create New File 3/1/2021 6:00:29 PM Excel Favourite Report ### After Writing to File 3/1/2021 6:00:29 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Mar01233003557 3/1/2021 6:00:29 PM processDataUsingPostTableXML ### Create Zip 3/1/2021 6:00:30 PM processDataUsingPostTableXML ### Added PendingXml 3/1/2021 6:00:30 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 3/1/2021 6:00:30 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 3/1/2021 6:00:30 PM processDataUsingPostTableXML ### Finished 3/1/2021 6:00:30 PM processDataUsingPostTableXML ### End