------------------------------------------- 1/14/2021 3:20:39 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 3:20:39 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 3:46:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 3:46:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 5:25:52 AM 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) ------------------------------------------- 1/14/2021 5:26:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 5:26:01 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 6:21:08 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 6:21:08 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 6:28:51 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 6:29:04 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 6:29:04 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 6:29:17 AM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 6:51:20 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 6:51:21 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 6:57:14 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 6:57:14 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 7:50:01 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 7:50:01 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 9:22:49 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 9:22:49 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 10:14:25 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 10:14:25 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 10:23:12 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 10:23:12 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 10:26:39 AM Error in ImportOneDistributor.aspx.cs:In Page_Load() ### Before binding of the ddlDistributor dropdownlist ### 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) ------------------------------------------- 1/14/2021 10:26:41 AM Error in ImportOneDistributor.aspx.cs:In Page_Load() ### Before binding of the ddlDistributor dropdownlist ### 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) ------------------------------------------- 1/14/2021 11:46:36 AM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 11:46:36 AM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:31:32 PM Export Class, Export To Text Function ### Export Class, Export Master Excel Function, End ### ZylemMasterTemplateImporting.aspx.cs :ReadCSVToTable() ### System.ArgumentException: Input array is longer than the number of columns in this table. at System.Data.DataRow.set_ItemArray(Object[] value) at ZylemMasterTemplateImporting.ReadCSVToTable(String path, String fileName, String columnName) ------------------------------------------- 1/14/2021 12:34:46 PM GenClass Class, FillCombo Function ### After Filling DataSet ### ZylemMasterTemplateImporting.aspx.cs :ReadCSVToTable() ### System.ArgumentException: Input array is longer than the number of columns in this table. at System.Data.DataRow.set_ItemArray(Object[] value) at ZylemMasterTemplateImporting.ReadCSVToTable(String path, String fileName, String columnName) ------------------------------------------- 1/14/2021 12:45:22 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:45:27 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:45:28 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:45:33 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:45:38 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:45:41 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:45:46 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:45:46 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:45:48 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:45:54 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:46:00 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:46:03 PM Error in ZylemAuditLog.aspx.cs:In Page_Load() ### Before defining the connectionstring ### ZylemAuditLog.aspx.cs :btnSearch_Click() ### System.Data.Odbc.OdbcException: ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'id'. ERROR [42S22] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Id'. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]0 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.Odbc.OdbcCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.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 ZylemAuditLog.btSearch_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 12:50:29 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:50:29 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:51:35 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:51:39 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:51:39 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:52:04 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:52:04 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:53:19 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:53:19 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:53:47 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:53:47 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:54:28 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:54:51 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:55:37 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:55:50 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:56:09 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:58:52 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:58:52 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:59:05 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:59:06 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:59:37 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 12:59:37 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 1:00:12 PM Error in Login.aspx.cs :btLogin_Click() ### Before Update() ### In the btnLoginTop_Click ### NewLogin.aspx page ------------------------------------------- 1/14/2021 1:00:12 PM CLogin Class, Check Function ### After Reading ExecuteReader ### In btnLoginTop_Click in if (loginType == 1 || loginType == 0) ### NewLogin.aspx page ------------------------------------------- 1/14/2021 1:11:42 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SubMenu.aspx.cs :DynamicButton_Click ### System.Threading.ThreadAbortException: Thread was being aborted. at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.End() at SubMenu.DynamicButton_Click(Object sender, EventArgs e) ------------------------------------------- 1/14/2021 1:11:50 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 1/14/2021 1:11:53 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 1/14/2021 1:11:57 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### SalesAnalysis.aspx.cs :getCols ### System.ArgumentOutOfRangeException: Length cannot be less than zero. Parameter name: length at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length, Boolean fAlwaysCopy) at ReportCriterias.getColumns() ------------------------------------------- 1/14/2021 1:12:43 PM GenClass Class, ReturnScaler Function ### Before OdbcConnection ### Procedure Exec ### exec prSalesAnalysis 'DISTRIBUTOR,DEALERCODE,MONTH', 'YEAR', '0000000000000042021Jan14011243', '0', '<>0', 'SALE', '000000000000004', 0, '', '','DISTRIBUTOR','1','','3','3','False','False','True','1' 1/14/2021 6:00:02 PM processDataUsingPostTableXML ### dtFinalFav Count = 3 1/14/2021 6:00:02 PM ProcessData ### Inside Pre Processed Report 1/14/2021 6:00:02 PM processDataUsingPostTableXML strScript for BAYER QA Distributor File Upload Status 2021Jan14233002507 ### 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 1/14/2021 6:00:02 PM Post Favourite ### After Fill DataSet 1/14/2021 6:00:02 PM Excel Favourite Report ### Html Case 1/14/2021 6:00:02 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_BAYER QA Distributor File Upload Status 14Jan2021060002.html 1/14/2021 6:00:02 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/14/2021 6:00:02 PM Excel Favourite Report ### After Writing to File 1/14/2021 6:00:02 PM processDataUsingPostTableXML ### Write PendingXml BAYER QA Distributor File Upload Status 2021Jan14233002507 1/14/2021 6:00:02 PM processDataUsingPostTableXML ### Create Zip 1/14/2021 6:00:03 PM processDataUsingPostTableXML ### Added PendingXml 1/14/2021 6:00:03 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/14/2021 6:00:03 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/14/2021 6:00:03 PM ProcessData ### Inside Pre Processed Report 1/14/2021 6:00:03 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking ES 2021Jan14233002507 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'ES' 1/14/2021 6:00:23 PM Post Favourite ### After Fill DataSet 1/14/2021 6:00:23 PM Excel Favourite Report ### Excel Case 1/14/2021 6:00:23 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking ES 14Jan2021060023.xls 1/14/2021 6:00:23 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/14/2021 6:00:23 PM Excel Favourite Report ### After Writing to File 1/14/2021 6:00:23 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking ES 2021Jan14233002507 1/14/2021 6:00:23 PM processDataUsingPostTableXML ### Create Zip 1/14/2021 6:00:23 PM processDataUsingPostTableXML ### Added PendingXml 1/14/2021 6:00:23 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/14/2021 6:00:23 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/14/2021 6:00:23 PM ProcessData ### Inside Pre Processed Report 1/14/2021 6:00:23 PM processDataUsingPostTableXML strScript for GenerateUnlinkedCustomerLinking CS 2021Jan14233002513 ### EXEC [pr_CR_Bayer_GenerateUnlinkedCustomerLinking_M2] 'CS' 1/14/2021 6:00:58 PM Post Favourite ### After Fill DataSet 1/14/2021 6:00:58 PM Excel Favourite Report ### Excel Case 1/14/2021 6:00:58 PM Excel Favourite Report ### Before Checking File Exist For Path D:\BAYER\Zylem\ZylemImportFolders\REPORTS\000000000000001_GenerateUnlinkedCustomerLinking CS 14Jan2021060058.xls 1/14/2021 6:00:58 PM Excel Favourite Report ### After Checking File Exist Or Create New File 1/14/2021 6:00:58 PM Excel Favourite Report ### After Writing to File 1/14/2021 6:00:58 PM processDataUsingPostTableXML ### Write PendingXml GenerateUnlinkedCustomerLinking CS 2021Jan14233002513 1/14/2021 6:00:58 PM processDataUsingPostTableXML ### Create Zip 1/14/2021 6:00:58 PM processDataUsingPostTableXML ### Added PendingXml 1/14/2021 6:00:58 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport start ### 1/14/2021 6:00:58 PM processDataUsingPostTableXML,impXML.updateXmlNodeFavouriteReport end True ### 1/14/2021 6:00:58 PM processDataUsingPostTableXML ### Finished 1/14/2021 6:00:58 PM processDataUsingPostTableXML ### End