------------------------------------------- 12/3/2021 4:07:54 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/3/2021 4:07:54 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/3/2021 4:46:59 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/3/2021 4:47:00 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/3/2021 4:47:18 AM GenClass Class, ReturnScaler Function ### Before binding grdTracker ### TrackingDetails.aspx.cs:CreateDynamicGrid() ### System.Web.HttpException (0x80004005): DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'. at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) at TrackingDetails.CreateDynamicGrid(DataTable dt) ------------------------------------------- 12/3/2021 5:04:58 AM GenClass Class, ReturnScaler Function ### Before binding grdTracker ### TrackingDetails.aspx.cs:CreateDynamicGrid() ### System.Web.HttpException (0x80004005): DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'. at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) at TrackingDetails.CreateDynamicGrid(DataTable dt) ------------------------------------------- 12/3/2021 5:13:50 AM GenClass Class, ReturnScaler Function ### Before binding grdTracker ### TrackingDetails.aspx.cs:CreateDynamicGrid() ### System.Web.HttpException (0x80004005): DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'. at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) at TrackingDetails.CreateDynamicGrid(DataTable dt) ------------------------------------------- 12/3/2021 5:15:04 AM GenClass Class, ReturnScaler Function ### Before binding grdTracker ### TrackingDetails.aspx.cs:CreateDynamicGrid() ### System.Web.HttpException (0x80004005): DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'. at System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) at System.Web.UI.WebControls.DataGrid.CreateControlHierarchy(Boolean useDataSource) at System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) at TrackingDetails.CreateDynamicGrid(DataTable dt) 12/3/2021 6:00:02 AM processDataUsingPostTableXML ### dtFinalFav Count = 5 12/3/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/3/2021 6:00:02 AM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Dec03113001807 ### 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/3/2021 6:00:02 AM Post Favourite ### After Fill DataSet 12/3/2021 6:00:02 AM Excel Favourite Report ### Html Case 12/3/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 03Dec2021060002.html 12/3/2021 6:00:02 AM Excel Favourite Report ### After Checking File Exist Or Create New File 12/3/2021 6:00:02 AM Excel Favourite Report ### After Writing to File 12/3/2021 6:00:02 AM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Dec03113001807 12/3/2021 6:00:02 AM processDataUsingPostTableXML ### Create Zip 12/3/2021 6:00:02 AM processDataUsingPostTableXML ### Added PendingXml 12/3/2021 6:00:02 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 12/3/2021 6:00:02 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 12/3/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/3/2021 6:00:02 AM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Dec03113001860 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30AM','7' 12/3/2021 6:00:02 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/3/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/3/2021 6:00:02 AM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Dec03113001923 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30AM','7' 12/3/2021 6:00:02 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/3/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/3/2021 6:00:02 AM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Dec03113001970 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30AM','7' 12/3/2021 6:00:02 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/3/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/3/2021 6:00:02 AM processDataUsingPostTableXML strScript for DataFUS -test 2021Dec03113002030 ### exec [prDistributorFileUploadStatus] '000000000000001','Dec 3 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 12/3/2021 6:00:02 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Dec 3 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 12/3/2021 6:00:02 AM processDataUsingPostTableXML ### Finished 12/3/2021 6:00:02 AM processDataUsingPostTableXML ### End ------------------------------------------- 12/3/2021 6:15:38 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/3/2021 6:15:38 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/3/2021 6:16:58 AM Error in RetailMasterListingReport.aspx.cs :btnExcel_Click() ### Before Export() ### ### Dataset to Datatable ------------------------------------------- 12/3/2021 6:40:37 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/3/2021 6:40:37 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/3/2021 7:12:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/3/2021 7:12:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/3/2021 7:16:05 AM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DBO.TRACKER_2'. 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/3/2021 6:00:03 PM processDataUsingPostTableXML ### dtFinalFav Count = 4 12/3/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/3/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Dec03233002840 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30PM','7' 12/3/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/3/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/3/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Dec03233002910 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30PM','7' 12/3/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/3/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/3/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Dec03233002963 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30PM','7' 12/3/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 3 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/3/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/3/2021 6:00:03 PM processDataUsingPostTableXML strScript for DataFUS -test 2021Dec03233003037 ### exec [prDistributorFileUploadStatus] '000000000000001','Dec 3 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 12/3/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Dec 3 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 12/3/2021 6:00:03 PM processDataUsingPostTableXML ### Finished 12/3/2021 6:00:03 PM processDataUsingPostTableXML ### End