------------------------------------------- 12/1/2021 3:21:22 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 3:21:22 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 3:29:24 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 3:29:30 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 3:29:30 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 3:34:44 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 3:34:44 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 5:08:38 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 5:08:38 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page 12/1/2021 6:00:02 AM processDataUsingPostTableXML ### dtFinalFav Count = 5 12/1/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/1/2021 6:00:02 AM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Dec01113001850 ### 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/1/2021 6:00:02 AM Post Favourite ### After Fill DataSet 12/1/2021 6:00:02 AM Excel Favourite Report ### Html Case 12/1/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 01Dec2021060002.html 12/1/2021 6:00:02 AM Excel Favourite Report ### After Checking File Exist Or Create New File 12/1/2021 6:00:02 AM Excel Favourite Report ### After Writing to File 12/1/2021 6:00:02 AM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Dec01113001850 12/1/2021 6:00:02 AM processDataUsingPostTableXML ### Create Zip 12/1/2021 6:00:02 AM processDataUsingPostTableXML ### Added PendingXml 12/1/2021 6:00:02 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 12/1/2021 6:00:02 AM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 12/1/2021 6:00:02 AM ProcessData ### Inside Pre Processed Report 12/1/2021 6:00:03 AM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Dec01113001910 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30AM','7' 12/1/2021 6:00:03 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/1/2021 6:00:03 AM ProcessData ### Inside Pre Processed Report 12/1/2021 6:00:03 AM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Dec01113001963 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30AM','7' 12/1/2021 6:00:03 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/1/2021 6:00:03 AM ProcessData ### Inside Pre Processed Report 12/1/2021 6:00:03 AM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Dec01113002010 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30AM','7' 12/1/2021 6:00:03 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30AM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/1/2021 6:00:03 AM ProcessData ### Inside Pre Processed Report 12/1/2021 6:00:03 AM processDataUsingPostTableXML strScript for DataFUS -test 2021Dec01113002070 ### exec [prDistributorFileUploadStatus] '000000000000001','Dec 1 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 12/1/2021 6:00:03 AM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Dec 1 2021 11:30AM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 12/1/2021 6:00:03 AM processDataUsingPostTableXML ### Finished 12/1/2021 6:00:03 AM processDataUsingPostTableXML ### End ------------------------------------------- 12/1/2021 7:14:07 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 7:14:07 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 7:50:37 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 7:50:38 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 8:50:42 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 8:50:42 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 8:54:34 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 8:54:34 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 9:59:31 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 9:59:31 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 10:39:15 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 10:39:16 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 11:28:00 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 11:28:00 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 12:49:16 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 12:49:16 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 12:49:48 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. 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/1/2021 12:49:54 PM 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/1/2021 12:49:56 PM 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/1/2021 12:49:59 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. 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/1/2021 12:50:12 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. 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/1/2021 12:50:13 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. 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/1/2021 1:33:20 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. 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/1/2021 1:33:22 PM 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/1/2021 1:34:08 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ProClaimzAPI ASPX.CS, Get():URL: ### https://localhost:44342/api/menu/GetSingleSignOnUserDetails?clientUserId=4 ------------------------------------------- 12/1/2021 1:34:10 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### ProClaimzAPI ASPX.CS, Get():URL: ### https://localhost:44342/api/menu/GetMenuAccessRightDetails/4 ------------------------------------------- 12/1/2021 1:34:28 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. 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/1/2021 1:34:32 PM 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/1/2021 1:36:39 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. 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/1/2021 1:37:26 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 12/1/2021 1:37:26 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 12/1/2021 1:37:35 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### GenClass Class, ExecuteSQL Function ### System.Data.Odbc.OdbcException (0x80131937): ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'IsDelete'. 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/1/2021 1:37:53 PM GenClass Class, FillDropDown Function ### After OdbcConnection ### QueryExecuter.aspx.cs :btnExecute ### System.ArgumentNullException: Value cannot be null. Parameter name: path1 at System.IO.Path.Combine(String path1, String path2) at QueryExecuter.WriteQueryLog(String Type, String Message) at QueryExecuter.btnExecute_Click(Object sender, EventArgs e) 12/1/2021 6:00:03 PM processDataUsingPostTableXML ### dtFinalFav Count = 4 12/1/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/1/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-ES 2021Dec01233002847 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30PM','7' 12/1/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/1/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/1/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-Common 2021Dec01233002910 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30PM','7' 12/1/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/1/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/1/2021 6:00:03 PM processDataUsingPostTableXML strScript for Data File Upload Status-CS 2021Dec01233002963 ### exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30PM','7' 12/1/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000004','Dec 1 2021 11:30PM','7', Error: ### Procedure or function 'prDistributorFileUploadStatus' expects parameter '@StateId', which was not supplied. 12/1/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 12/1/2021 6:00:03 PM processDataUsingPostTableXML strScript for DataFUS -test 2021Dec01233003027 ### exec [prDistributorFileUploadStatus] '000000000000001','Dec 1 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''' 12/1/2021 6:00:03 PM processDataUsingPostTableXML,Error while executing procedure :exec [prDistributorFileUploadStatus] '000000000000001','Dec 1 2021 11:30PM','EXEC [prDistributorFileUploadStatus] '000000000000001','','7','','','','',''', Error: ### Incorrect syntax near '000000000000001'. 12/1/2021 6:00:03 PM processDataUsingPostTableXML ### Finished 12/1/2021 6:00:03 PM processDataUsingPostTableXML ### End