------------------------------------------- 6/10/2021 4:26:28 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 4:26:28 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/10/2021 4:38:42 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 4:38:42 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/10/2021 8:56:29 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 8:56:29 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/10/2021 9:16:24 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 9:16:24 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/10/2021 10:06:22 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 10:06:22 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/10/2021 10:10:47 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 10:10:47 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/10/2021 10:19:23 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.AbortCurrentThread() at FolderExplorer.ImgBtnDownload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 6/10/2021 10:28:45 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 10:28:45 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/10/2021 10:29:34 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 6/10/2021 10:29:36 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 6/10/2021 10:29:38 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 6/10/2021 10:30:55 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 6/10/2021 10:47:42 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.AbortCurrentThread() at FolderExplorer.ImgBtnDownload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 6/10/2021 11:06:49 AM Error in ImportOneDistributor.aspx.cs:In Page_Load() ### Before binding of the ddlDistributor dropdownlist ### Completed Updating Has Transaction Flag ### 6/10/2021 11:06:49 AM ------------------------------------------- 6/10/2021 11:26:16 AM Error in FolderExplorer.aspx.cs:In Page_Load() ### Before binding of the ddlFolderPath dropdownlist ### FolderExplorer.aspx.cs :ImgBtnUpload_Click() ### System.IO.DirectoryNotFoundException: Could not find a part of the path 'D:\BAYER\Zylem\ZylemImportFolders\Receive\'. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode) at System.Web.HttpPostedFile.SaveAs(String filename) at FolderExplorer.ImgBtnUpload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 6/10/2021 11:38:04 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.AbortCurrentThread() at FolderExplorer.ImgBtnDownload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 6/10/2021 12:40:20 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 12:40:20 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/10/2021 12:45:27 PM 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.AbortCurrentThread() at FolderExplorer.ImgBtnDownload_Click(Object sender, ImageClickEventArgs e) ------------------------------------------- 6/10/2021 1:09:48 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 1:09:48 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 6/10/2021 1:10:48 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 6/10/2021 1:10:48 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 6/10/2021 6:00:03 PM processDataUsingPostTableXML ### dtFinalFav Count = 5 6/10/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 6/10/2021 6:00:03 PM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Jun10233002957 ### 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/10/2021 6:00:03 PM Post Favourite ### After Fill DataSet 6/10/2021 6:00:03 PM Excel Favourite Report ### Html Case 6/10/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 10Jun2021060003.html 6/10/2021 6:00:03 PM Excel Favourite Report ### After Checking File Exist Or Create New File 6/10/2021 6:00:03 PM Excel Favourite Report ### After Writing to File 6/10/2021 6:00:03 PM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Jun10233002957 6/10/2021 6:00:03 PM processDataUsingPostTableXML ### Create Zip 6/10/2021 6:00:03 PM processDataUsingPostTableXML ### Added PendingXml 6/10/2021 6:00:03 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/10/2021 6:00:03 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/10/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 6/10/2021 6:00:03 PM processDataUsingPostTableXML strScript for Bayer Zylem S3 Daily Audit Log 2021Jun10233003000 ### EXEC prZylemAuditLogReport '','','','','','','','' 6/10/2021 6:00:03 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/10/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 6/10/2021 6:00:03 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Jun10233003050 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 6/10/2021 6:00:04 PM Post Favourite ### After Fill DataSet 6/10/2021 6:00:04 PM Excel Favourite Report ### Excel Case 6/10/2021 6:00:05 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 10Jun2021060004.xls 6/10/2021 6:00:05 PM Excel Favourite Report ### After Checking File Exist Or Create New File 6/10/2021 6:00:05 PM Excel Favourite Report ### After Writing to File 6/10/2021 6:00:05 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Jun10233003050 6/10/2021 6:00:05 PM processDataUsingPostTableXML ### Create Zip 6/10/2021 6:00:05 PM processDataUsingPostTableXML ### Added PendingXml 6/10/2021 6:00:05 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/10/2021 6:00:05 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/10/2021 6:00:05 PM ProcessData ### Inside Pre Processed Report 6/10/2021 6:00:05 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Jun10233003097 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'CS' 6/10/2021 6:00:08 PM Post Favourite ### After Fill DataSet 6/10/2021 6:00:08 PM Excel Favourite Report ### Excel Case 6/10/2021 6:00:09 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 10Jun2021060008.xls 6/10/2021 6:00:09 PM Excel Favourite Report ### After Checking File Exist Or Create New File 6/10/2021 6:00:09 PM Excel Favourite Report ### After Writing to File 6/10/2021 6:00:09 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Jun10233003097 6/10/2021 6:00:09 PM processDataUsingPostTableXML ### Create Zip 6/10/2021 6:00:10 PM processDataUsingPostTableXML ### Added PendingXml 6/10/2021 6:00:10 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/10/2021 6:00:10 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/10/2021 6:00:10 PM ProcessData ### Inside Pre Processed Report 6/10/2021 6:00:10 PM processDataUsingPostTableXML strScript for Bayer Zylem S3 unmapped product count 2021Jun10233003137 ### EXEC prUnMappedproductCount_BAYER 6/10/2021 6:01:34 PM Post Favourite ### After Fill DataSet 6/10/2021 6:01:34 PM Excel Favourite Report ### Excel Case 6/10/2021 6:01:35 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_Bayer Zylem S3 unmapped product count 10Jun2021060134.xls 6/10/2021 6:01:35 PM Excel Favourite Report ### After Checking File Exist Or Create New File 6/10/2021 6:01:35 PM Excel Favourite Report ### After Writing to File 6/10/2021 6:01:35 PM processDataUsingPostTableXML ### Write PendingXml Bayer Zylem S3 unmapped product count 2021Jun10233003137 6/10/2021 6:01:35 PM processDataUsingPostTableXML ### Create Zip 6/10/2021 6:01:35 PM processDataUsingPostTableXML ### Added PendingXml 6/10/2021 6:01:35 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 6/10/2021 6:01:35 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 6/10/2021 6:01:35 PM processDataUsingPostTableXML ### Finished 6/10/2021 6:01:35 PM processDataUsingPostTableXML ### End