------------------------------------------- 4/29/2021 3:41:08 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 3:42: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() ------------------------------------------- 4/29/2021 3:42:23 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() ------------------------------------------- 4/29/2021 3:42: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() ------------------------------------------- 4/29/2021 3:42: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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 4/29/2021 3:43:32 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,BRAND', 'YRMNTH', '0000000000009982021Apr29034332', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','True','1' ------------------------------------------- 4/29/2021 4:02:06 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,ITEM,ITEMALIAS,DATE', 'YRMNTH', '0000000000009982021Apr29040206', '0', '<>0', 'SALE', '000000000000998', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','True','1' ------------------------------------------- 4/29/2021 4:40:30 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 4:40:30 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 5:32:02 AM Export Class, Export To Text Function ### Export Class, Export Master Excel Function, End ### 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) ------------------------------------------- 4/29/2021 5:32:14 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() ------------------------------------------- 4/29/2021 5:32: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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 4/29/2021 5:32: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.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 4/29/2021 5:32:51 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,DATE', 'YEAR', '0000000000000052021Apr29053251', '0', '<>0', 'SALE', '000000000000005', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','True','1' ------------------------------------------- 4/29/2021 5:33:01 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,DATE', 'YEAR', '0000000000000052021Apr29053301', '0', '<>0', 'SALE', '000000000000005', 0, '', '','DISTRIBUTOR','0','','3','3','False','False','True','1' ------------------------------------------- 4/29/2021 5:33:13 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,DATE', 'YEAR', '0000000000000052021Apr29053313', '0', '<>0', 'SALE', '000000000000005', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','True','1' ------------------------------------------- 4/29/2021 5:36:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 5:36:02 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 6:16:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 6:16:01 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 6:24:59 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### SubMenu.aspx.cs :PageLoad Operation ### System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at SubMenu.Page_Load(Object sender, EventArgs e) ------------------------------------------- 4/29/2021 6:33:20 AM AreaTree Class, AddToAuditLog Function ### After ExecuteNonQuery ### SubMenu.aspx.cs :PageLoad Operation ### System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at SubMenu.Page_Load(Object sender, EventArgs e) ------------------------------------------- 4/29/2021 6:41:40 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :PageLoad Operation ### System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at SubMenu.Page_Load(Object sender, EventArgs e) ------------------------------------------- 4/29/2021 6:50:00 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :PageLoad Operation ### System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at SubMenu.Page_Load(Object sender, EventArgs e) ------------------------------------------- 4/29/2021 6:50:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 6:50:01 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 6:58:21 AM GenClass Class, ExecuteSQLStmt Function ### After ExecuteNonQuery ### SubMenu.aspx.cs :PageLoad Operation ### System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at SubMenu.Page_Load(Object sender, EventArgs e) ------------------------------------------- 4/29/2021 6:58:22 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 6:58:22 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 6:58:23 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 6:58:23 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 7:45:27 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 7:45:27 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 8:07:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 8:07:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 8:29:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 8:29:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 9:04:42 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 9:04:42 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 9:25:35 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 9:25:35 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 9:27:15 AM Error in FolderExplorer.aspx.cs:In Page_Load() ### Before binding of the ddlFolderPath dropdownlist ### FolderExplorer.aspx.cs :ImgBtnDownload_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 FolderExplorer.ImgBtnDownload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 4/29/2021 9:59:57 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 9:59:57 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 10:07:59 AM Error in FolderExplorer.aspx.cs:In Page_Load() ### Before binding of the ddlFolderPath dropdownlist ### FolderExplorer.aspx.cs :ImgBtnDownload_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 FolderExplorer.ImgBtnDownload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 4/29/2021 10:20:58 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 10:21:23 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 10:34:40 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 10:34:40 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 11:03:18 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) ------------------------------------------- 4/29/2021 11:03:25 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() ------------------------------------------- 4/29/2021 11:03: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() ------------------------------------------- 4/29/2021 11:03:32 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() ------------------------------------------- 4/29/2021 11:03:59 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,DATE', 'YEAR', '0000000000000052021Apr29110359', '0', '<>0', 'SALE', '000000000000005', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','True','1' ------------------------------------------- 4/29/2021 11:04:56 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 11:04:56 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 11:33:08 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 11:33:08 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 11:37:14 AM Export Class, Export To Text Function ### Export Class, Export Master Excel Function, End ### QueryExecuterForSettings.aspx.cs:In Export_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 QueryExecuterForSettings.btnExcel_Click(Object sender, EventArgs e) ------------------------------------------- 4/29/2021 11:37:28 AM Export Class, Export To Text Function ### Export Class, Export Master Excel Function, End ### QueryExecuterForSettings.aspx.cs:In Export_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 QueryExecuterForSettings.btnExcel_Click(Object sender, EventArgs e) ------------------------------------------- 4/29/2021 11:37:34 AM Export Class, Export To Text Function ### Export Master Excel Function, After StringBuilder Object ### QueryExecuterForSettings.aspx.cs:In Export_Click ### System.NullReferenceException: Object reference not set to an instance of an object. at Export.Export_Productivity_Dashboard(String CName, String ReportTitle, String Control, String WC, String Criteria, DataSet oDS, Boolean isColumnHeader, Boolean isSrno) at QueryExecuterForSettings.btnExcel_Click(Object sender, EventArgs e) ------------------------------------------- 4/29/2021 11:37:43 AM Export Class, Export To Text Function ### Export Master Excel Function, After StringBuilder Object ### QueryExecuterForSettings.aspx.cs:In Export_Click ### System.NullReferenceException: Object reference not set to an instance of an object. at Export.Export_Productivity_Dashboard(String CName, String ReportTitle, String Control, String WC, String Criteria, DataSet oDS, Boolean isColumnHeader, Boolean isSrno) at QueryExecuterForSettings.btnExcel_Click(Object sender, EventArgs e) ------------------------------------------- 4/29/2021 11:51:11 AM 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) ------------------------------------------- 4/29/2021 11:51:17 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 11:51:17 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 11:51:43 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 11:51:43 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 12:01:16 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. ------------------------------------------- 4/29/2021 12:01:45 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. ------------------------------------------- 4/29/2021 12:02:04 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. ------------------------------------------- 4/29/2021 12:23:19 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. ------------------------------------------- 4/29/2021 12:23:41 PM AddLink Class, Update_ItemLink Function ### After Insert ItemLinkHistory ### AddLink Class, Update_ItemLink Function ### Update DateItemLink : FromDate is : 15 Apr 2021 ------------------------------------------- 4/29/2021 12:23:42 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. ------------------------------------------- 4/29/2021 12:35:19 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 12:35:19 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 4/29/2021 2:09:44 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 4/29/2021 2:09:44 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 4/29/2021 6:00:02 PM processDataUsingPostTableXML ### dtFinalFav Count = 4 4/29/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 4/29/2021 6:00:02 PM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Apr29233002103 ### 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 4/29/2021 6:00:02 PM Post Favourite ### After Fill DataSet 4/29/2021 6:00:02 PM Excel Favourite Report ### Html Case 4/29/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 29Apr2021060002.html 4/29/2021 6:00:02 PM Excel Favourite Report ### After Checking File Exist Or Create New File 4/29/2021 6:00:02 PM Excel Favourite Report ### After Writing to File 4/29/2021 6:00:02 PM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Apr29233002103 4/29/2021 6:00:02 PM processDataUsingPostTableXML ### Create Zip 4/29/2021 6:00:02 PM processDataUsingPostTableXML ### Added PendingXml 4/29/2021 6:00:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 4/29/2021 6:00:02 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 4/29/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 4/29/2021 6:00:02 PM processDataUsingPostTableXML strScript for Bayer Zylem S3 Daily Audit Log 2021Apr29233002150 ### EXEC prZylemAuditLogReport '','','','','','','','' 4/29/2021 6:00:03 PM Post Favourite ### After Fill DataSet 4/29/2021 6:00:03 PM Export_Master_Excel ### Start 4/29/2021 6:00:03 PM Export_Master_Excel ### Before Creating Object 4/29/2021 6:00:03 PM Export_Master_Excel:NewFormatAuditLog() ### Data Bind Completed. 4/29/2021 6:00:03 PM Export_Master_Excel ### End 4/29/2021 6:00:03 PM Excel Favourite Report ### Audit log report 4/29/2021 6:00:03 PM processDataUsingPostTableXML ### Write PendingXml Bayer Zylem S3 Daily Audit Log 2021Apr29233002150 4/29/2021 6:00:03 PM processDataUsingPostTableXML ### Create Zip 4/29/2021 6:00:03 PM processDataUsingPostTableXML ### Added PendingXml 4/29/2021 6:00:03 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 4/29/2021 6:00:03 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 4/29/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 4/29/2021 6:00:03 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Apr29233002200 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'ES' 4/29/2021 6:00:03 PM Post Favourite ### After Fill DataSet 4/29/2021 6:00:03 PM Excel Favourite Report ### Excel Case 4/29/2021 6:00:03 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 29Apr2021060003.xls 4/29/2021 6:00:03 PM Excel Favourite Report ### After Checking File Exist Or Create New File 4/29/2021 6:00:03 PM Excel Favourite Report ### After Writing to File 4/29/2021 6:00:03 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Apr29233002200 4/29/2021 6:00:03 PM processDataUsingPostTableXML ### Create Zip 4/29/2021 6:00:04 PM processDataUsingPostTableXML ### Added PendingXml 4/29/2021 6:00:04 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 4/29/2021 6:00:04 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 4/29/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 4/29/2021 6:00:04 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Apr29233002247 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'CS' 4/29/2021 6:00:04 PM Post Favourite ### After Fill DataSet 4/29/2021 6:00:04 PM Excel Favourite Report ### Excel Case 4/29/2021 6:00:05 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 29Apr2021060004.xls 4/29/2021 6:00:05 PM Excel Favourite Report ### After Checking File Exist Or Create New File 4/29/2021 6:00:05 PM Excel Favourite Report ### After Writing to File 4/29/2021 6:00:05 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Apr29233002247 4/29/2021 6:00:05 PM processDataUsingPostTableXML ### Create Zip 4/29/2021 6:00:05 PM processDataUsingPostTableXML ### Added PendingXml 4/29/2021 6:00:05 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 4/29/2021 6:00:05 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 4/29/2021 6:00:05 PM processDataUsingPostTableXML ### Finished 4/29/2021 6:00:05 PM processDataUsingPostTableXML ### End