------------------------------------------- 7/19/2021 5:43:34 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 5:43:35 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 7/19/2021 6:08:23 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 6:08:23 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 7/19/2021 6:50:04 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) ------------------------------------------- 7/19/2021 7:01:37 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 7:01:37 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 7/19/2021 7:40:20 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 7:40:20 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 7/19/2021 7:45:38 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 7:45:38 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 7/19/2021 7:58:28 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 7/19/2021 7:58:30 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 7/19/2021 7:58:32 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 7/19/2021 7:58:40 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 7/19/2021 8:06:02 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 8:06:08 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 8:06:08 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 7/19/2021 8:06:35 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 7/19/2021 8:06:35 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 7/19/2021 8:07:09 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 7/19/2021 8:07:12 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 7/19/2021 8:19:58 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 8:19:58 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 7/19/2021 8:27:31 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 8:27:31 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 7/19/2021 8:40:14 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) ------------------------------------------- 7/19/2021 9:45:39 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 9:45:39 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 7/19/2021 10:30:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 7/19/2021 10:30:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 7/19/2021 6:00:04 PM processDataUsingPostTableXML ### dtFinalFav Count = 5 7/19/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 7/19/2021 6:00:04 PM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Jul19233003973 ### 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 7/19/2021 6:00:04 PM Post Favourite ### After Fill DataSet 7/19/2021 6:00:04 PM Excel Favourite Report ### Html Case 7/19/2021 6:00:04 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 19Jul2021060004.html 7/19/2021 6:00:04 PM Excel Favourite Report ### After Checking File Exist Or Create New File 7/19/2021 6:00:04 PM Excel Favourite Report ### After Writing to File 7/19/2021 6:00:04 PM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Jul19233003973 7/19/2021 6:00:04 PM processDataUsingPostTableXML ### Create Zip 7/19/2021 6:00:04 PM processDataUsingPostTableXML ### Added PendingXml 7/19/2021 6:00:04 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 7/19/2021 6:00:04 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 7/19/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 7/19/2021 6:00:04 PM processDataUsingPostTableXML strScript for Bayer Zylem S3 Daily Audit Log 2021Jul19233004020 ### EXEC prZylemAuditLogReport '','','','','','','','' 7/19/2021 6:00:04 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. 7/19/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 7/19/2021 6:00:04 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Jul19233004067 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' 7/19/2021 6:02:52 PM Post Favourite ### After Fill DataSet 7/19/2021 6:02:52 PM Excel Favourite Report ### Excel Case 7/19/2021 6:02:52 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 19Jul2021060252.xls 7/19/2021 6:02:52 PM Excel Favourite Report ### After Checking File Exist Or Create New File 7/19/2021 6:02:52 PM Excel Favourite Report ### After Writing to File 7/19/2021 6:02:53 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Jul19233004067 7/19/2021 6:02:53 PM processDataUsingPostTableXML ### Create Zip 7/19/2021 6:02:53 PM processDataUsingPostTableXML ### Added PendingXml 7/19/2021 6:02:53 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 7/19/2021 6:02:53 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 7/19/2021 6:02:53 PM ProcessData ### Inside Pre Processed Report 7/19/2021 6:02:53 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Jul19233004107 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'CS' 7/19/2021 6:02:58 PM Post Favourite ### After Fill DataSet 7/19/2021 6:02:58 PM Excel Favourite Report ### Excel Case 7/19/2021 6:03:00 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 19Jul2021060258.xls 7/19/2021 6:03:00 PM Excel Favourite Report ### After Checking File Exist Or Create New File 7/19/2021 6:03:00 PM Excel Favourite Report ### After Writing to File 7/19/2021 6:03:00 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Jul19233004107 7/19/2021 6:03:00 PM processDataUsingPostTableXML ### Create Zip 7/19/2021 6:03:01 PM processDataUsingPostTableXML ### Added PendingXml 7/19/2021 6:03:01 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 7/19/2021 6:03:01 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 7/19/2021 6:03:01 PM ProcessData ### Inside Pre Processed Report 7/19/2021 6:03:01 PM processDataUsingPostTableXML strScript for Bayer Zylem S3 unmapped product count 2021Jul19233004157 ### EXEC prUnMappedproductCount_BAYER 7/19/2021 6:04:48 PM Post Favourite ### After Fill DataSet 7/19/2021 6:04:48 PM Excel Favourite Report ### Excel Case 7/19/2021 6:04:48 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_Bayer Zylem S3 unmapped product count 19Jul2021060448.xls 7/19/2021 6:04:48 PM Excel Favourite Report ### After Checking File Exist Or Create New File 7/19/2021 6:04:48 PM Excel Favourite Report ### After Writing to File 7/19/2021 6:04:48 PM processDataUsingPostTableXML ### Write PendingXml Bayer Zylem S3 unmapped product count 2021Jul19233004157 7/19/2021 6:04:48 PM processDataUsingPostTableXML ### Create Zip 7/19/2021 6:04:48 PM processDataUsingPostTableXML ### Added PendingXml 7/19/2021 6:04:48 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 7/19/2021 6:04:48 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 7/19/2021 6:04:48 PM processDataUsingPostTableXML ### Finished 7/19/2021 6:04:48 PM processDataUsingPostTableXML ### End