********************************************************** Time Of Error : 02-12-2024 10:27:01 Error Message : Fatal error encountered during command execution. Error Exeption : MySql.Data.MySqlClient.MySqlException: Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException: Unknown column 'fim.TestCode' in 'on clause' at MySql.Data.MySqlClient.MySqlStream.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet() at MySql.Data.MySqlClient.MySqlDataReader.NextResult() --- End of inner exception stack trace --- at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) Error Place : at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.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 MySqlHelper.ExecuteDataset(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\livecode\Pathsquare\App_Code\DataLinkLayer\ODBCHelper.cs:line 488 at MySqlHelper.ExecuteDataset(MySqlConnection connection, CommandType commandType, String commandText) in d:\livecode\Pathsquare\App_Code\DataLinkLayer\ODBCHelper.cs:line 460 at StockReports.GetDataTable(String strQuery) in d:\livecode\Pathsquare\App_Code\BuisnessLogic\Finance\StockReports.cs:line 567 at PatientLabSearch.Search_Dispatch(String LabNo, String UHID_hosp, String CentreSearch, String RegNo, String PName, String CentreID, String dtFrom, String dtTo, String Dept, String Status, String PhoneNo, String Mobile, String refrdby, String Ptype, String TimeFrm, String TimeTo, String FromLabNo, String ToLabNo, String PanelID, String CardNoFrom, String CardNoTo, String InvestigationID, String isUrgent, String ASM, String ZSM, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String Barcode, String FromBarcode, String ToBarcode, String pageNo, String pageSize) in d:\livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 758 Error On Machine : ITD-SAAS-02-SRV Error Machine IP Address : 10.1.6.101 ********************************************************** Time Of Error : 02-12-2024 11:09:12 Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21 at Design_Welcome.LoadData() in d:\livecode\Pathsquare\Design\Welcome.aspx.cs:line 308 Error On Machine : ITD-SAAS-02-SRV Error Machine IP Address : 10.1.6.101 ********************************************************** Time Of Error : 02-12-2024 11:10:21 Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21 at Design_Welcome.LoadData() in d:\livecode\Pathsquare\Design\Welcome.aspx.cs:line 308 Error On Machine : ITD-SAAS-02-SRV Error Machine IP Address : 10.1.6.101 ********************************************************** Time Of Error : 02-12-2024 21:13:21 Error Message : Object reference not set to an instance of an object. Error Exeption : Error Place : at Centre.get_Id() in d:\livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21 at Design_Welcome.LoadData() in d:\livecode\Pathsquare\Design\Welcome.aspx.cs:line 308 Error On Machine : ITD-SAAS-02-SRV Error Machine IP Address : 10.1.6.101