------------------------------------------- 9/15/2021 5:43:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/15/2021 5:43:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/15/2021 5:43:45 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/15/2021 5:43:45 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 9/15/2021 6:00:04 AM processDataUsingPostTableXML ### dtFinalFav Count = 9 9/15/2021 6:00:04 AM ProcessData ### Inside Pre Processed Report 9/15/2021 6:00:04 AM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Sep15113003580 ### 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/15/2021 6:00:04 AM Post Favourite ### After Fill DataSet 9/15/2021 6:00:04 AM Excel Favourite Report ### Html Case 9/15/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 15Sep2021060004.html 9/15/2021 6:00:04 AM Excel Favourite Report ### After Checking File Exist Or Create New File 9/15/2021 6:00:04 AM Excel Favourite Report ### After Writing to File 9/15/2021 6:00:04 AM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Sep15113003580 9/15/2021 6:00:04 AM processDataUsingPostTableXML ### Create Zip 9/15/2021 6:00:04 AM processDataUsingPostTableXML ### Added PendingXml 9/15/2021 6:00:04 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 9/15/2021 6:00:04 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 9/15/2021 6:00:04 AM ProcessData ### Inside Pre Processed Report 9/15/2021 6:00:04 AM processDataUsingPostTableXML strScript for Bayer Zylem S3 Daily Audit Log 2021Sep15113003633 ### EXEC prZylemAuditLogReport '','','','','','','','' 9/15/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/15/2021 6:00:04 AM ProcessData ### Inside Pre Processed Report 9/15/2021 6:00:04 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Sep15113003690 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'ES' ------------------------------------------- 9/15/2021 6:02:34 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\ReconciliationReport\'. 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/15/2021 6:03:00 AM Post Favourite ### After Fill DataSet 9/15/2021 6:03:00 AM Excel Favourite Report ### Excel Case 9/15/2021 6:03:01 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 15Sep2021060300.xls 9/15/2021 6:03:01 AM Excel Favourite Report ### After Checking File Exist Or Create New File 9/15/2021 6:03:01 AM Excel Favourite Report ### After Writing to File 9/15/2021 6:03:01 AM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Sep15113003690 9/15/2021 6:03:01 AM processDataUsingPostTableXML ### Create Zip 9/15/2021 6:03:01 AM processDataUsingPostTableXML ### Added PendingXml 9/15/2021 6:03:01 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 9/15/2021 6:03:01 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 9/15/2021 6:03:01 AM ProcessData ### Inside Pre Processed Report 9/15/2021 6:03:01 AM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Sep15113003740 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M3] 'CS' 9/15/2021 6:03:08 AM Post Favourite ### After Fill DataSet 9/15/2021 6:03:08 AM Excel Favourite Report ### Excel Case 9/15/2021 6:03:09 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 15Sep2021060308.xls 9/15/2021 6:03:09 AM Excel Favourite Report ### After Checking File Exist Or Create New File 9/15/2021 6:03:09 AM Excel Favourite Report ### After Writing to File 9/15/2021 6:03:10 AM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Sep15113003740 9/15/2021 6:03:10 AM processDataUsingPostTableXML ### Create Zip 9/15/2021 6:03:11 AM processDataUsingPostTableXML ### Added PendingXml 9/15/2021 6:03:11 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 9/15/2021 6:03:11 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 9/15/2021 6:03:11 AM ProcessData ### Inside Pre Processed Report 9/15/2021 6:03:11 AM processDataUsingPostTableXML strScript for Bayer Zylem S3 unmapped product count 2021Sep15113003797 ### EXEC prUnMappedproductCount_BAYER 9/15/2021 6:05:32 AM Post Favourite ### After Fill DataSet 9/15/2021 6:05:32 AM Excel Favourite Report ### Excel Case 9/15/2021 6:05:32 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_Bayer Zylem S3 unmapped product count 15Sep2021060532.xls 9/15/2021 6:05:32 AM Excel Favourite Report ### After Checking File Exist Or Create New File 9/15/2021 6:05:32 AM Excel Favourite Report ### After Writing to File 9/15/2021 6:05:33 AM processDataUsingPostTableXML ### Write PendingXml Bayer Zylem S3 unmapped product count 2021Sep15113003797 9/15/2021 6:05:33 AM processDataUsingPostTableXML ### Create Zip 9/15/2021 6:05:33 AM processDataUsingPostTableXML ### Added PendingXml 9/15/2021 6:05:33 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 9/15/2021 6:05:33 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 9/15/2021 6:05:33 AM ProcessData ### Inside Pre Processed Report 9/15/2021 6:05:33 AM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Sep15113003847 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30AM','7' 9/15/2021 6:05:33 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/15/2021 6:05:33 AM ProcessData ### Inside Pre Processed Report 9/15/2021 6:05:33 AM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Sep15113003900 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30AM','7' 9/15/2021 6:05:33 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/15/2021 6:05:33 AM ProcessData ### Inside Pre Processed Report 9/15/2021 6:05:33 AM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Sep15113003950 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30AM','7' 9/15/2021 6:05:33 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/15/2021 6:05:33 AM ProcessData ### Inside Pre Processed Report 9/15/2021 6:05:33 AM processDataUsingPostTableXML strScript for DataFUS -test 2021Sep15113004003 ### exec [prDistributorFileUploadStatus] '000000000000001','Sep 15 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 9/15/2021 6:05:33 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Sep 15 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 9/15/2021 6:05:33 AM processDataUsingPostTableXML ### Finished 9/15/2021 6:05:33 AM processDataUsingPostTableXML ### End ------------------------------------------- 9/15/2021 6:29:22 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/15/2021 6:29:22 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/15/2021 6:55:54 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/15/2021 6:55:54 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/15/2021 7:46:57 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/15/2021 7:46:57 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/15/2021 9:27:02 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 9/15/2021 9:27:02 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 9/15/2021 9:48:09 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 9/15/2021 9:48:11 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 9/15/2021 9:48:13 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 9/15/2021 9:48:24 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing ------------------------------------------- 9/15/2021 10:34:47 AM GenClass Class, FillCombo Function ### After Filling DataSet ### ItemLinkCSV ### Start ItemLink CSV Validation ------------------------------------------- 9/15/2021 10:34:49 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ItemLinkCSV ### End ItemLink CSV Validation ------------------------------------------- 9/15/2021 10:34:51 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### Start ItemLink CSV Importing ------------------------------------------- 9/15/2021 10:34:58 AM GenClass Class, ExecuteSQLQuery Function ### After ExecuteNonQuery ### ItemLinkCSV ### End ItemLink CSV Importing 9/15/2021 6:00:04 PM processDataUsingPostTableXML ### dtFinalFav Count = 5 9/15/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/15/2021 6:00:04 PM processDataUsingPostTableXML strScript for Bayer Zylem S3 Daily Audit Log 2021Sep15233003897 ### EXEC prZylemAuditLogReport '','','','','','','','' 9/15/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/15/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/15/2021 6:00:04 PM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Sep15233003953 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30PM','7' 9/15/2021 6:00:04 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/15/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/15/2021 6:00:04 PM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Sep15233004007 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30PM','7' 9/15/2021 6:00:04 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/15/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/15/2021 6:00:04 PM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Sep15233004060 ### exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30PM','7' 9/15/2021 6:00:04 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Sep 15 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 9/15/2021 6:00:04 PM ProcessData ### Inside Pre Processed Report 9/15/2021 6:00:04 PM processDataUsingPostTableXML strScript for DataFUS -test 2021Sep15233004117 ### exec [prDistributorFileUploadStatus] '000000000000001','Sep 15 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 9/15/2021 6:00:04 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Sep 15 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 9/15/2021 6:00:04 PM processDataUsingPostTableXML ### Finished 9/15/2021 6:00:04 PM processDataUsingPostTableXML ### End