**********************************************************  
 Time Of Error            : 19-01-2025 13:28:47
 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            : 19-01-2025 16:44:31
 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:\livecode\Pathsquare\App_Code\DataLinkLayer\ODBCHelper.cs:line 1013
   at MySqlHelper.ExecuteScalar(MySqlConnection connection, CommandType commandType, String commandText) in d:\livecode\Pathsquare\App_Code\DataLinkLayer\ODBCHelper.cs:line 989
   at StockReports.ExecuteScalar(String strQuery) in d:\livecode\Pathsquare\App_Code\BuisnessLogic\Finance\StockReports.cs:line 645
   at Design_Welcome.LoadData() in d:\livecode\Pathsquare\Design\Welcome.aspx.cs:line 306
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.1.6.101


  **********************************************************  
 Time Of Error            : 19-01-2025 18:21:11
 Error Message            : INSERT INTO patient_labobservation_OPD(LabObservation_ID, Result_Date, Result_Time, `Value`, Description,Test_ID,`MinValue`,`MaxValue`,LabObservationName,Priorty,InvPriorty,ReadingFormat,DisplayReading,IsOrganism,OrganismID,ParamEnteredBy,ParamEnteredByName,MacReading,dtMacEntry,MachineID,Method,PrintMethod,LedgerTransactionNo,`IsCommentField`,`ResultRequiredField`,`IsCritical`,`MinCritical`,`MaxCritical`,`Approved`,`ApprovedBy`,`ApprovedDate`,`ApprovedName`,`ResultEnteredBy`,`ResultEnteredDate`,`ResultEnteredName`,`AbnormalValue`,`IsBold`,`IsUnderLine`,`IsMic`,`PrintSeparate`,`flag`)VALUES (@LabObservation_ID, @Result_Date, @Result_Time, @Value, @Description,@Test_ID,@MinValue,@MaxValue,@LabObservationName,@Priorty,@InvPriorty,@ReadingFormat,@DisplayReading,@IsOrganism,@OrganismID,@ParamEnteredBy,@ParamEnteredByName,@MacReading,@dtMacEntry,@MachineID,@Method,@PrintMethod,@LedgerTransactionNo,@IsCommentField,@ResultRequiredField,@IsCritical,@MinCritical,@MaxCritical,@Approved,@ApprovedBy,@ApprovedDate,@ApprovedName,@ResultEnteredBy,@ResultEnteredDate,@ResultEnteredName,@AbnormalValue,@IsBold,@IsUnderLine,@IsMic,@PrintSeparate,@Flag)
 Error Exeption            : 
 Error Place              :    at Patient_LabObservation_OPD.Insert() in d:\livecode\Pathsquare\App_Code\DataLinkLayer\PatientLabObservation_OPD.cs:line 707
   at PatientResultEntry.SaveLabObservationOpdData(List`1 data, String ResultStatus, String predatetime, String notappreason, String ApprovedBy, String ApprovalName, String Vial_ID, String Inv_Method, String isDLC) in d:\livecode\Pathsquare\Design\Lab\MachineResultEntry.aspx.cs:line 1125
 Error On Machine         : ITD-SAAS-02-SRV
 Error Machine IP Address : 10.1.6.101