------------------------------------------- 11/9/2021 4:43:52 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 4:43:53 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 11/9/2021 5:22:26 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 5:22:26 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 11/9/2021 5:39:27 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 5:39:27 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 11/9/2021 5:39:45 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 5:39:53 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 5:39:53 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 11/9/2021 6:00:03 AM processDataUsingPostTableXML ### dtFinalFav Count = 5 11/9/2021 6:00:03 AM ProcessData ### Inside Pre Processed Report 11/9/2021 6:00:03 AM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Nov09113003370 ### 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 11/9/2021 6:00:03 AM Post Favourite ### After Fill DataSet 11/9/2021 6:00:03 AM Excel Favourite Report ### Html Case 11/9/2021 6:00:03 AM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 09Nov2021060003.html 11/9/2021 6:00:03 AM Excel Favourite Report ### After Checking File Exist Or Create New File 11/9/2021 6:00:03 AM Excel Favourite Report ### After Writing to File 11/9/2021 6:00:03 AM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Nov09113003370 11/9/2021 6:00:03 AM processDataUsingPostTableXML ### Create Zip 11/9/2021 6:00:04 AM processDataUsingPostTableXML ### Added PendingXml 11/9/2021 6:00:04 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 11/9/2021 6:00:04 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 11/9/2021 6:00:04 AM ProcessData ### Inside Pre Processed Report 11/9/2021 6:00:04 AM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Nov09113003433 ### exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30AM','7' 11/9/2021 6:00:04 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 11/9/2021 6:00:04 AM ProcessData ### Inside Pre Processed Report 11/9/2021 6:00:04 AM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Nov09113003487 ### exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30AM','7' 11/9/2021 6:00:04 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 11/9/2021 6:00:04 AM ProcessData ### Inside Pre Processed Report 11/9/2021 6:00:04 AM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Nov09113003537 ### exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30AM','7' 11/9/2021 6:00:04 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 11/9/2021 6:00:04 AM ProcessData ### Inside Pre Processed Report 11/9/2021 6:00:04 AM processDataUsingPostTableXML strScript for DataFUS -test 2021Nov09113003590 ### exec [prDistributorFileUploadStatus] '000000000000001','Nov 9 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 11/9/2021 6:00:04 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Nov 9 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 11/9/2021 6:00:04 AM processDataUsingPostTableXML ### Finished 11/9/2021 6:00:04 AM processDataUsingPostTableXML ### End ------------------------------------------- 11/9/2021 7:43:38 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 7:43:38 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 11/9/2021 7:56:49 AM GenClass Class, InsertTimeStamp Function ### After ExecuteNonQuery ### RetailMasterListingReport.aspx.cs :btnGo_Click() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'PIN'. at System.Data.Odbc.OdbcDataReader.NextResult(Boolean disposing, Boolean allresults) at System.Data.Odbc.OdbcDataReader.FirstResult() 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 RetailMasterListingReport.btnGo_Click(Object sender, EventArgs e) ------------------------------------------- 11/9/2021 8:06:09 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 8:06:18 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 8:06:26 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 8:06:26 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 11/9/2021 9:50:31 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 9:50:39 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 9:50:39 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 11/9/2021 10:11:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 11:15:05 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 11:15:05 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 11/9/2021 11:16:50 AM GenClass Class, InsertTimeStamp Function ### After ExecuteNonQuery ### RetailMasterListingReport.aspx.cs :btnGo_Click() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'PIN'. at System.Data.Odbc.OdbcDataReader.NextResult(Boolean disposing, Boolean allresults) at System.Data.Odbc.OdbcDataReader.FirstResult() 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 RetailMasterListingReport.btnGo_Click(Object sender, EventArgs e) ------------------------------------------- 11/9/2021 11:20:17 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 11:20:18 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 11/9/2021 11:20:51 AM GenClass Class, InsertTimeStamp Function ### After ExecuteNonQuery ### RetailMasterListingReport.aspx.cs :btnGo_Click() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'PIN'. at System.Data.Odbc.OdbcDataReader.NextResult(Boolean disposing, Boolean allresults) at System.Data.Odbc.OdbcDataReader.FirstResult() 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 RetailMasterListingReport.btnGo_Click(Object sender, EventArgs e) ------------------------------------------- 11/9/2021 11:28:13 AM GenClass Class, InsertTimeStamp Function ### After ExecuteNonQuery ### RetailMasterListingReport.aspx.cs :btnGo_Click() ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'PIN'. at System.Data.Odbc.OdbcDataReader.NextResult(Boolean disposing, Boolean allresults) at System.Data.Odbc.OdbcDataReader.FirstResult() 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 RetailMasterListingReport.btnGo_Click(Object sender, EventArgs e) ------------------------------------------- 11/9/2021 1:40:24 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 11/9/2021 1:40:24 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 11/9/2021 6:00:03 PM processDataUsingPostTableXML ### dtFinalFav Count = 4 11/9/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 11/9/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Nov09233002847 ### exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30PM','7' 11/9/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 11/9/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 11/9/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Nov09233002900 ### exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30PM','7' 11/9/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 11/9/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 11/9/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Nov09233002957 ### exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30PM','7' 11/9/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Nov 9 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 11/9/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 11/9/2021 6:00:03 PM processDataUsingPostTableXML strScript for DataFUS -test 2021Nov09233003010 ### exec [prDistributorFileUploadStatus] '000000000000001','Nov 9 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 11/9/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Nov 9 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 11/9/2021 6:00:03 PM processDataUsingPostTableXML ### Finished 11/9/2021 6:00:03 PM processDataUsingPostTableXML ### End