------------------------------------------- 1/8/2021 4:28:10 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/8/2021 4:28:10 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/8/2021 5:28:57 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/8/2021 5:28:57 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/8/2021 5:55:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/8/2021 5:55:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/8/2021 6:42:55 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/8/2021 6:42:55 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/8/2021 7:21:38 AM Export Class, Export To Text Function ### Export Class, Export Master Excel Function, End ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 1/8/2021 7:21:39 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 1/8/2021 7:21:41 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### Start ItemLink ------------------------------------------- 1/8/2021 7:21:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1296 ------------------------------------------- 1/8/2021 7:21:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1372 ------------------------------------------- 1/8/2021 7:21:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000395, Code: 2042 ------------------------------------------- 1/8/2021 7:21:42 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1297 ------------------------------------------- 1/8/2021 7:21:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1903 ------------------------------------------- 1/8/2021 7:21:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 2069 ------------------------------------------- 1/8/2021 7:21:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1713 ------------------------------------------- 1/8/2021 7:21:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1295 ------------------------------------------- 1/8/2021 7:21:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 2163 ------------------------------------------- 1/8/2021 7:21:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1302 ------------------------------------------- 1/8/2021 7:21:43 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1540 ------------------------------------------- 1/8/2021 7:21:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000591, Code: 5066 ------------------------------------------- 1/8/2021 7:21:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1298 ------------------------------------------- 1/8/2021 7:21:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1299 ------------------------------------------- 1/8/2021 7:21:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 2546 ------------------------------------------- 1/8/2021 7:21:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000591, Code: 5055 ------------------------------------------- 1/8/2021 7:21:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000591, Code: 5054 ------------------------------------------- 1/8/2021 7:21:44 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1848 ------------------------------------------- 1/8/2021 7:21:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 2036 ------------------------------------------- 1/8/2021 7:21:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1939 ------------------------------------------- 1/8/2021 7:21:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 2040 ------------------------------------------- 1/8/2021 7:21:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1904 ------------------------------------------- 1/8/2021 7:21:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1940 ------------------------------------------- 1/8/2021 7:21:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000591, Code: 5070 ------------------------------------------- 1/8/2021 7:21:45 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1732 ------------------------------------------- 1/8/2021 7:21:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1733 ------------------------------------------- 1/8/2021 7:21:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 2209 ------------------------------------------- 1/8/2021 7:21:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000493, Code: 3770 ------------------------------------------- 1/8/2021 7:21:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1783 ------------------------------------------- 1/8/2021 7:21:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 2039 ------------------------------------------- 1/8/2021 7:21:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1847 ------------------------------------------- 1/8/2021 7:21:46 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1568 ------------------------------------------- 1/8/2021 7:21:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1609 ------------------------------------------- 1/8/2021 7:21:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 1569 ------------------------------------------- 1/8/2021 7:21:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 2174 ------------------------------------------- 1/8/2021 7:21:47 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### ItemLinkCSV ### DistId: 000000000000398, Code: 2530 ------------------------------------------- 1/8/2021 7:21:47 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink ------------------------------------------- 1/8/2021 7:46:55 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/8/2021 8:59:52 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/8/2021 8:59:52 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/8/2021 9:07:06 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/8/2021 9:07:06 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/8/2021 10:29:23 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/8/2021 10:29:23 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/8/2021 11:10:06 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/8/2021 12:23:43 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/8/2021 12:23:43 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/8/2021 12:43:52 PM 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/8/2021 12:44:04 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 1/8/2021 12:44:10 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 1/8/2021 12:44:13 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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 1/8/2021 12:44:48 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,MONTH', 'YEAR', '0000000000000052021Jan08124448', '0', '<>0', 'SALE', '000000000000005', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','True','1' ------------------------------------------- 1/8/2021 12:45:52 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,MONTH', 'YEAR', '0000000000000052021Jan08124552', '0', '<>0', 'SALE', '000000000000005', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','True','1' ------------------------------------------- 1/8/2021 1:07:09 PM 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/8/2021 1:07:38 PM 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/8/2021 6:00:02 PM processDataUsingPostTableXML ### dtFinalFav Count = 3 1/8/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 1/8/2021 6:00:02 PM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Jan08233002253 ### 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/8/2021 6:00:02 PM Post Favourite ### After Fill DataSet 1/8/2021 6:00:02 PM Excel Favourite Report ### Html Case 1/8/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 08Jan2021060002.html 1/8/2021 6:00:02 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/8/2021 6:00:02 PM Excel Favourite Report ### After Writing to File 1/8/2021 6:00:02 PM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Jan08233002253 1/8/2021 6:00:02 PM processDataUsingPostTableXML ### Create Zip 1/8/2021 6:00:02 PM processDataUsingPostTableXML ### Added PendingXml 1/8/2021 6:00:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/8/2021 6:00:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/8/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 1/8/2021 6:00:02 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Jan08233002263 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'ES' 1/8/2021 6:00:05 PM Post Favourite ### After Fill DataSet 1/8/2021 6:00:05 PM Excel Favourite Report ### Excel Case 1/8/2021 6:00:05 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 08Jan2021060005.xls 1/8/2021 6:00:05 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/8/2021 6:00:05 PM Excel Favourite Report ### After Writing to File 1/8/2021 6:00:05 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Jan08233002263 1/8/2021 6:00:05 PM processDataUsingPostTableXML ### Create Zip 1/8/2021 6:00:05 PM processDataUsingPostTableXML ### Added PendingXml 1/8/2021 6:00:05 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/8/2021 6:00:05 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/8/2021 6:00:05 PM ProcessData ### Inside Pre Processed Report 1/8/2021 6:00:05 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Jan08233002263 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'CS' 1/8/2021 6:00:16 PM Post Favourite ### After Fill DataSet 1/8/2021 6:00:16 PM Excel Favourite Report ### Excel Case 1/8/2021 6:00:16 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 08Jan2021060016.xls 1/8/2021 6:00:16 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/8/2021 6:00:16 PM Excel Favourite Report ### After Writing to File 1/8/2021 6:00:16 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Jan08233002263 1/8/2021 6:00:16 PM processDataUsingPostTableXML ### Create Zip 1/8/2021 6:00:16 PM processDataUsingPostTableXML ### Added PendingXml 1/8/2021 6:00:16 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/8/2021 6:00:16 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/8/2021 6:00:16 PM processDataUsingPostTableXML ### Finished 1/8/2021 6:00:16 PM processDataUsingPostTableXML ### End