------------------------------------------- 1/18/2021 4:41:33 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 4:41:33 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 4:54:24 AM Linking Class, FillGrid Function ### After OdbcConnection ### Linking Class, FillGrid Function ### ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function 'prItemUnLinked' expects parameter '@distAreaFilter', which was not supplied. ------------------------------------------- 1/18/2021 5:20:02 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 5:20:02 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 5:21:56 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 5:21:56 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 5:23:33 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 5:23:33 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 5:23:47 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.End() at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 1/18/2021 5:24:36 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 5:24:36 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 5:28:08 AM UserDetails ASPX.CS, Page_Load Event ### After New OdbcConnection ### QueryExecuter.aspx.cs :btnExecute ### System.ArgumentNullException: Value cannot be null. Parameter name: path1 at System.IO.Path.Combine(String path1, String path2) at QueryExecuter.WriteQueryLog(String Type, String Message) at QueryExecuter.btnExecute_Click(Object sender, EventArgs e) ------------------------------------------- 1/18/2021 6:24:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 6:24:07 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 6:30:11 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 6:30:11 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 6:30:22 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.End() at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 1/18/2021 6:30:31 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() ------------------------------------------- 1/18/2021 6:30: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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 1/18/2021 6:30:42 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'YEAR', 'DIVISION', '0000000000009962021Jan18063042', '0', '<>0', 'SALE', '000000000000996', 0, '', '','YEAR','0','','3','3','False','False','True','1' ------------------------------------------- 1/18/2021 6:32:02 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 6:32:02 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 6:32:15 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.End() at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 1/18/2021 6:32:22 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() ------------------------------------------- 1/18/2021 6:32:28 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() ------------------------------------------- 1/18/2021 6:32:28 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() ------------------------------------------- 1/18/2021 6:33:04 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'YEAR', 'DIVISION', '0000000000009982021Jan18063304', '0', '<>0', 'SALE', '000000000000998', 0, '', '','YEAR','0','','3','3','False','False','True','1' ------------------------------------------- 1/18/2021 6:47:51 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 6:47:51 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 7:04:19 AM Export Class, Export To Text Function ### Export Class, Export Master Excel Function, End ### 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) ------------------------------------------- 1/18/2021 7:05:07 AM Export Class, Export To Text Function ### Export Class, Export Master Excel Function, End ### 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) ------------------------------------------- 1/18/2021 8:04:09 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 8:04:09 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 9:40:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/18/2021 9:40:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/18/2021 9:57:32 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### ERROR [22001] [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. ------------------------------------------- 1/18/2021 9:57:32 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ZylemMasterTemplateImporting page, SaveData ### Insert into USERMASTER (Id,Name,Address,Pin,Telephone,Fax,Login,Password,Type,EmailId,BranchId,LoginStatus,AreaId,ERPCode,LoginDateTime,IsActive,LASTEDITDATE,CreatedBy,CreatedDate,EditedBy,DeletedBy,DeletedDate,DeleteFlag,GSTNumber,Latitude,Longitude) Values('000000000075286','Sai Maruthi Agencies','Voletivaripalem','123','9848124502','789','','','4','bayersupport@sapl.net','000000000000039','','000000000006628','AP01649','','1','01/18/2021 15:25:08','000000000000005','','','','','','37ADZPV8583F1ZCP','','') 1/18/2021 6:00:02 PM processDataUsingPostTableXML ### dtFinalFav Count = 3 1/18/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 1/18/2021 6:00:03 PM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Jan18233002800 ### 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 1/18/2021 6:00:03 PM Post Favourite ### After Fill DataSet 1/18/2021 6:00:03 PM Excel Favourite Report ### Html Case 1/18/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 18Jan2021060003.html 1/18/2021 6:00:03 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/18/2021 6:00:03 PM Excel Favourite Report ### After Writing to File 1/18/2021 6:00:03 PM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Jan18233002800 1/18/2021 6:00:03 PM processDataUsingPostTableXML ### Create Zip 1/18/2021 6:00:03 PM processDataUsingPostTableXML ### Added PendingXml 1/18/2021 6:00:03 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/18/2021 6:00:03 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/18/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 1/18/2021 6:00:03 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Jan18233002837 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'ES' 1/18/2021 6:00:23 PM Post Favourite ### After Fill DataSet 1/18/2021 6:00:23 PM Excel Favourite Report ### Excel Case 1/18/2021 6:00:23 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 18Jan2021060023.xls 1/18/2021 6:00:23 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/18/2021 6:00:23 PM Excel Favourite Report ### After Writing to File 1/18/2021 6:00:23 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Jan18233002837 1/18/2021 6:00:23 PM processDataUsingPostTableXML ### Create Zip 1/18/2021 6:00:23 PM processDataUsingPostTableXML ### Added PendingXml 1/18/2021 6:00:23 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/18/2021 6:00:23 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/18/2021 6:00:23 PM ProcessData ### Inside Pre Processed Report 1/18/2021 6:00:23 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Jan18233002877 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'CS' 1/18/2021 6:01:02 PM Post Favourite ### After Fill DataSet 1/18/2021 6:01:02 PM Excel Favourite Report ### Excel Case 1/18/2021 6:01:02 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 18Jan2021060102.xls 1/18/2021 6:01:02 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/18/2021 6:01:02 PM Excel Favourite Report ### After Writing to File 1/18/2021 6:01:02 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Jan18233002877 1/18/2021 6:01:02 PM processDataUsingPostTableXML ### Create Zip 1/18/2021 6:01:02 PM processDataUsingPostTableXML ### Added PendingXml 1/18/2021 6:01:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/18/2021 6:01:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/18/2021 6:01:02 PM processDataUsingPostTableXML ### Finished 1/18/2021 6:01:02 PM processDataUsingPostTableXML ### End