------------------------------------------- 9/8/2021 4:46:35 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/8/2021 4:46:35 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/8/2021 5:12:15 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/8/2021 5:12:15 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/8/2021 5:30:49 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/8/2021 5:30:49 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 9/8/2021 6:00:03 AM processDataUsingPostTableXML ### dtFinalFav Count = 9 9/8/2021 6:00:03 AM ProcessData ### Inside Pre Processed Report 9/8/2021 6:00:03 AM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Sep08113003437 ### 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 9/8/2021 6:00:04 AM Post Favourite ### After Fill DataSet 9/8/2021 6:00:04 AM Excel Favourite Report ### Html Case 9/8/2021 6:00:04 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 08Sep2021060004.html 9/8/2021 6:00:04 AM Excel Favourite Report ### After Checking File Exist Or Create New File 9/8/2021 6:00:04 AM Excel Favourite Report ### After Writing to File 9/8/2021 6:00:04 AM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Sep08113003437 9/8/2021 6:00:04 AM processDataUsingPostTableXML ### Create Zip 9/8/2021 6:00:04 AM processDataUsingPostTableXML ### Added PendingXml 9/8/2021 6:00:04 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 9/8/2021 6:00:04 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 9/8/2021 6:00:04 AM ProcessData ### Inside Pre Processed Report 9/8/2021 6:00:04 AM processDataUsingPostTableXML strScript for Bayer Zylem S3 Daily Audit Log 2021Sep08113003493 ### EXEC prZylemAuditLogReport '','','','','','','','' 9/8/2021 6:00:04 AM 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. 9/8/2021 6:00:04 AM ProcessData ### Inside Pre Processed Report 9/8/2021 6:00:04 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Sep08113003547 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' ------------------------------------------- 9/8/2021 6:01:35 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.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 9/8/2021 6:01:38 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.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) 9/8/2021 6:02:51 AM Post Favourite ### After Fill DataSet 9/8/2021 6:02:51 AM Excel Favourite Report ### Excel Case 9/8/2021 6:02:52 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 08Sep2021060251.xls 9/8/2021 6:02:52 AM Excel Favourite Report ### After Checking File Exist Or Create New File 9/8/2021 6:02:52 AM Excel Favourite Report ### After Writing to File 9/8/2021 6:02:52 AM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Sep08113003547 9/8/2021 6:02:52 AM processDataUsingPostTableXML ### Create Zip 9/8/2021 6:02:52 AM processDataUsingPostTableXML ### Added PendingXml 9/8/2021 6:02:52 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 9/8/2021 6:02:52 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 9/8/2021 6:02:52 AM ProcessData ### Inside Pre Processed Report 9/8/2021 6:02:52 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Sep08113003597 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'CS' 9/8/2021 6:02:58 AM Post Favourite ### After Fill DataSet 9/8/2021 6:02:58 AM Excel Favourite Report ### Excel Case 9/8/2021 6:03:00 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 08Sep2021060258.xls 9/8/2021 6:03:00 AM Excel Favourite Report ### After Checking File Exist Or Create New File 9/8/2021 6:03:00 AM Excel Favourite Report ### After Writing to File 9/8/2021 6:03:01 AM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Sep08113003597 9/8/2021 6:03:01 AM processDataUsingPostTableXML ### Create Zip 9/8/2021 6:03:02 AM processDataUsingPostTableXML ### Added PendingXml 9/8/2021 6:03:02 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 9/8/2021 6:03:02 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 9/8/2021 6:03:02 AM ProcessData ### Inside Pre Processed Report 9/8/2021 6:03:02 AM processDataUsingPostTableXML strScript for Bayer Zylem S3 unmapped product count 2021Sep08113003653 ### EXEC prUnMappedproductCount_BAYER ------------------------------------------- 9/8/2021 6:04:13 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) 9/8/2021 6:05:21 AM Post Favourite ### After Fill DataSet 9/8/2021 6:05:21 AM Excel Favourite Report ### Excel Case 9/8/2021 6:05:21 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_Bayer Zylem S3 unmapped product count 08Sep2021060521.xls 9/8/2021 6:05:21 AM Excel Favourite Report ### After Checking File Exist Or Create New File 9/8/2021 6:05:21 AM Excel Favourite Report ### After Writing to File 9/8/2021 6:05:21 AM processDataUsingPostTableXML ### Write PendingXml Bayer Zylem S3 unmapped product count 2021Sep08113003653 9/8/2021 6:05:21 AM processDataUsingPostTableXML ### Create Zip 9/8/2021 6:05:21 AM processDataUsingPostTableXML ### Added PendingXml 9/8/2021 6:05:21 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 9/8/2021 6:05:21 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 9/8/2021 6:05:21 AM ProcessData ### Inside Pre Processed Report 9/8/2021 6:05:21 AM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Sep08113003710 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30AM','7' 9/8/2021 6:05:21 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/8/2021 6:05:21 AM ProcessData ### Inside Pre Processed Report 9/8/2021 6:05:21 AM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Sep08113003760 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30AM','7' 9/8/2021 6:05:21 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/8/2021 6:05:21 AM ProcessData ### Inside Pre Processed Report 9/8/2021 6:05:21 AM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Sep08113003810 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30AM','7' 9/8/2021 6:05:21 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/8/2021 6:05:21 AM ProcessData ### Inside Pre Processed Report 9/8/2021 6:05:21 AM processDataUsingPostTableXML strScript for DataFUS -test 2021Sep08113003863 ### exec [prDistributorFileUploadStatus] '000000000000001','Sep 8 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 9/8/2021 6:05:21 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Sep 8 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 9/8/2021 6:05:21 AM processDataUsingPostTableXML ### Finished 9/8/2021 6:05:21 AM processDataUsingPostTableXML ### End ------------------------------------------- 9/8/2021 6:11:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/8/2021 6:11:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/8/2021 6:24:47 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/8/2021 6:24:55 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/8/2021 6:25:16 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/8/2021 6:25:16 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/8/2021 6:25:29 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.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 9/8/2021 7:34:10 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/8/2021 7:34:10 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/8/2021 7:52:56 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 9/8/2021 7:52:57 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 9/8/2021 7:52:59 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 9/8/2021 7:53:02 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 9/8/2021 10:02:00 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/8/2021 10:02:00 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 9/8/2021 6:00:04 PM processDataUsingPostTableXML ### dtFinalFav Count = 5 9/8/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/8/2021 6:00:04 PM processDataUsingPostTableXML strScript for Bayer Zylem S3 Daily Audit Log 2021Sep08233004223 ### EXEC prZylemAuditLogReport '','','','','','','','' 9/8/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. 9/8/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/8/2021 6:00:04 PM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Sep08233004277 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30PM','7' 9/8/2021 6:00:04 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/8/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/8/2021 6:00:04 PM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Sep08233004330 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30PM','7' 9/8/2021 6:00:04 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/8/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/8/2021 6:00:04 PM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Sep08233004380 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30PM','7' 9/8/2021 6:00:04 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 8 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/8/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/8/2021 6:00:04 PM processDataUsingPostTableXML strScript for DataFUS -test 2021Sep08233004437 ### exec [prDistributorFileUploadStatus] '000000000000001','Sep 8 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 9/8/2021 6:00:04 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Sep 8 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 9/8/2021 6:00:04 PM processDataUsingPostTableXML ### Finished 9/8/2021 6:00:04 PM processDataUsingPostTableXML ### End