**********************************************************  
 Time Of Error            : 14-11-2025 08:02:29
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 11:52:20
 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 'AND IsCancel=0 AND DATE(DATE)=DATE(NOW())' 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.ExecuteScalar()
   at MySqlHelper.ExecuteScalar(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\ODBCHelper.cs:line 1013
   at MySqlHelper.ExecuteScalar(MySqlConnection connection, CommandType commandType, String commandText) in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\ODBCHelper.cs:line 989
   at StockReports.ExecuteScalar(String strQuery) in d:\Itdose\Livecode\Pathsquare\App_Code\BuisnessLogic\Finance\StockReports.cs:line 645
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 306
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 12:01:44
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 13:27:34
 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 'AND IsCancel=0 AND DATE(DATE)=DATE(NOW())' 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.ExecuteScalar()
   at MySqlHelper.ExecuteScalar(MySqlConnection connection, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\ODBCHelper.cs:line 1013
   at MySqlHelper.ExecuteScalar(MySqlConnection connection, CommandType commandType, String commandText) in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\ODBCHelper.cs:line 989
   at StockReports.ExecuteScalar(String strQuery) in d:\Itdose\Livecode\Pathsquare\App_Code\BuisnessLogic\Finance\StockReports.cs:line 645
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 306
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 14:28:47
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 14:28:49
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 14:33:20
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 14:33:34
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 14:33:43
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 14:54:15
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 16:37:56
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 16:38:16
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 17:34:01
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:06:39
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:06:45
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:06:49
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:06:53
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:07:01
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:10:51
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:10:53
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:18:34
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:25:40
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 18:31:14
 Error Message            : There is no row at position 300.
 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.RemoveAt(Int32 index)
   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:\Itdose\Livecode\Pathsquare\Design\Lab\Services\PatientLabSearch.asmx:line 775
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101


  **********************************************************  
 Time Of Error            : 14-11-2025 20:11:48
 Error Message            : Object reference not set to an instance of an object.
 Error Exeption            : 
 Error Place              :    at Centre.get_Id() in d:\Itdose\Livecode\Pathsquare\App_Code\DataLinkLayer\Centre.cs:line 21
   at Design_Welcome.LoadData() in d:\Itdose\Livecode\Pathsquare\Design\Welcome.aspx.cs:line 308
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.16.1.101