**********************************************************  
 Time Of Error            : 7/15/2021 10:54:51 AM
 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: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' inner join investigation_master im on pli.Investigation_ID = im.Investigation' at line 1
   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:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 488
   at MySqlHelper.ExecuteDataset(MySqlConnection connection, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 460
   at StockReports.GetDataTable(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 566
   at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, 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 slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Live_Code\360diagnostics\Design\Lab\Services\PatientLabSearch.asmx:line 1174
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 7/15/2021 10:54:51 AM
 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: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%' inner join investigation_master im on pli.Investigation_ID = im.Investigation' at line 1
   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:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 488
   at MySqlHelper.ExecuteDataset(MySqlConnection connection, CommandType commandType, String commandText) in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\ODBCHelper.cs:line 460
   at StockReports.GetDataTable(String strQuery) in d:\Live_Code\360diagnostics\App_Code\BuisnessLogic\Finance\StockReports.cs:line 566
   at PatientLabSearch.Search(String LabNo, String UHID_hosp, String IPDNo_hosp, 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 slidenumber, String BarCodeNo, String SearchByDate, String OutLab, String OutCentre, String CPTCode, String ColourCode, String CardNo, String _CheckCount, String PrintFlag, String _action, String TestCentre, String DispatchNo, Int32 IsIntimateToDoctor, Int32 IsIntimateToPatient, Int32 IsIntimateToNhPanel, Int32 IsDocumentPending, String CovidStatus) in d:\Live_Code\360diagnostics\Design\Lab\Services\PatientLabSearch.asmx:line 1174
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 7/15/2021 12:15:57 PM
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20
   at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 287
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 7/15/2021 2:38:01 PM
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20
   at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 287
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 7/15/2021 3:20:22 PM
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20
   at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 287
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 7/15/2021 4:23:21 PM
 Error Message            : There is no row at position 0.
 Error Exeption            : 
 Error Place              :    at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
   at System.Data.RBTree`1.get_Item(Int32 index)
   at System.Data.DataRowCollection.get_Item(Int32 index)
   at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 282
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 7/15/2021 5:34:25 PM
 Error Message            : There is no row at position 0.
 Error Exeption            : 
 Error Place              :    at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)
   at System.Data.RBTree`1.get_Item(Int32 index)
   at System.Data.DataRowCollection.get_Item(Int32 index)
   at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 282
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 7/15/2021 5:46:05 PM
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20
   at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 287
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147


  **********************************************************  
 Time Of Error            : 7/15/2021 5:52:26 PM
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Live_Code\360diagnostics\App_Code\DataLinkLayer\Centre.cs:line 20
   at Design_Welcome.LoadData() in d:\Live_Code\360diagnostics\Design\Welcome.aspx.cs:line 287
 Error On Machine         : WIN-EHNI66M25H8
 Error Machine IP Address : 172.31.36.147