------------------------------------------- 12/6/2021 4:16:16 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 4:16:16 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 4:57:16 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 4:57:16 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 12/6/2021 6:00:02 AM processDataUsingPostTableXML ### dtFinalFav Count = 5 12/6/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/6/2021 6:00:02 AM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Dec06113001827 ### 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 12/6/2021 6:00:02 AM Post Favourite ### After Fill DataSet 12/6/2021 6:00:02 AM Excel Favourite Report ### Html Case 12/6/2021 6:00:02 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 06Dec2021060002.html 12/6/2021 6:00:02 AM Excel Favourite Report ### After Checking File Exist Or Create New File 12/6/2021 6:00:02 AM Excel Favourite Report ### After Writing to File 12/6/2021 6:00:02 AM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Dec06113001827 12/6/2021 6:00:02 AM processDataUsingPostTableXML ### Create Zip 12/6/2021 6:00:02 AM processDataUsingPostTableXML ### Added PendingXml 12/6/2021 6:00:02 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 12/6/2021 6:00:02 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 12/6/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/6/2021 6:00:02 AM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Dec06113001887 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30AM',7 12/6/2021 6:00:02 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30AM',7, Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/6/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/6/2021 6:00:02 AM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Dec06113001933 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30AM',7 12/6/2021 6:00:02 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30AM',7, Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/6/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/6/2021 6:00:02 AM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Dec06113001987 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30AM',7 12/6/2021 6:00:02 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30AM',7, Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/6/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/6/2021 6:00:02 AM processDataUsingPostTableXML strScript for DataFUS -test 2021Dec06113002047 ### exec [prDistributorFileUploadStatus] '000000000000001','Dec 6 2021 11:30AM',EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','','' 12/6/2021 6:00:02 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Dec 6 2021 11:30AM',EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','','', Error: ### Incorrect syntax near the keyword 'EXEC'. 12/6/2021 6:00:02 AM processDataUsingPostTableXML ### Finished 12/6/2021 6:00:02 AM processDataUsingPostTableXML ### End ------------------------------------------- 12/6/2021 6:05:10 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 6:05:10 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 6:33:29 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 6:33:35 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 6:33:35 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 7:08:47 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 7:08:47 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 7:12:19 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 7:12:19 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 7:59:43 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 7:59:50 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 7:59:50 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 11:31:21 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 11:31:21 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 12:01:07 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 12:01:07 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 12:01:17 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Ambiguous column name 'LastEditDate'. at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod) at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader) at System.Data.Odbc.OdbcCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at GenClass.ExecuteSQL(String ConnectionString, String sql) ------------------------------------------- 12/6/2021 12:21:04 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 12:21:04 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 1:10:43 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/6/2021 1:10:43 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/6/2021 1:18:08 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) ------------------------------------------- 12/6/2021 1:18:47 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) ------------------------------------------- 12/6/2021 1:19:30 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) 12/6/2021 6:00:03 PM processDataUsingPostTableXML ### dtFinalFav Count = 4 12/6/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/6/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Dec06233002857 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30PM',7 12/6/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30PM',7, Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/6/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/6/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Dec06233002910 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30PM',7 12/6/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30PM',7, Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/6/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/6/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Dec06233002967 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30PM',7 12/6/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 6 2021 11:30PM',7, Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/6/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/6/2021 6:00:03 PM processDataUsingPostTableXML strScript for DataFUS -test 2021Dec06233003020 ### exec [prDistributorFileUploadStatus] '000000000000001','Dec 6 2021 11:30PM',EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','','' 12/6/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Dec 6 2021 11:30PM',EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','','', Error: ### Incorrect syntax near the keyword 'EXEC'. 12/6/2021 6:00:03 PM processDataUsingPostTableXML ### Finished 12/6/2021 6:00:03 PM processDataUsingPostTableXML ### End