**********************************************************  
 Time Of Error            : 10/13/2015 6:32:40 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 'S SO FULL DISCOUNT C/O MR. SATYENDRA SIR',UpdateID='LSHHI7',UpdateName='Govind S' 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.ExecuteNonQuery()
   at LabOPD.LabPrescriptionOPDEditOnlyPatientData(String PatientType, String Title, String PName, String PatientID, String Age, String Gender, String Phone, String Mobile, String Relation, String RelationName, String House_No, String City, String ReferedBy, String ReportReceivingType, String LedgerTransactionNo, String DOB_ShowFormat, Int32 rdDOB, String Source, String OtherDr, String CancelResult, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Area, String State, String proid, String referlab) in d:\Live Code\ArthDiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 2088
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 6:32:43 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 'S SO FULL DISCOUNT C/O MR. SATYENDRA SIR',UpdateID='LSHHI7',UpdateName='Govind S' 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.ExecuteNonQuery()
   at LabOPD.LabPrescriptionOPDEditOnlyPatientData(String PatientType, String Title, String PName, String PatientID, String Age, String Gender, String Phone, String Mobile, String Relation, String RelationName, String House_No, String City, String ReferedBy, String ReportReceivingType, String LedgerTransactionNo, String DOB_ShowFormat, Int32 rdDOB, String Source, String OtherDr, String CancelResult, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Area, String State, String proid, String referlab) in d:\Live Code\ArthDiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 2088
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 6:32:45 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 'S SO FULL DISCOUNT C/O MR. SATYENDRA SIR',UpdateID='LSHHI7',UpdateName='Govind S' 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.ExecuteNonQuery()
   at LabOPD.LabPrescriptionOPDEditOnlyPatientData(String PatientType, String Title, String PName, String PatientID, String Age, String Gender, String Phone, String Mobile, String Relation, String RelationName, String House_No, String City, String ReferedBy, String ReportReceivingType, String LedgerTransactionNo, String DOB_ShowFormat, Int32 rdDOB, String Source, String OtherDr, String CancelResult, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Area, String State, String proid, String referlab) in d:\Live Code\ArthDiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 2088
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 6:49:50 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at Lis.UpdtSmleCollctn(String ItemID, String btntxt, String colldate, String colltime, String IsCollectionDate, String receiverboytext, String barCode) in d:\Live Code\ArthDiagnostic\Lis.asmx:line 535
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 8:21:50 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at Lis.UpdtSmleCollctn(String ItemID, String btntxt, String colldate, String colltime, String IsCollectionDate, String receiverboytext, String barCode) in d:\Live Code\ArthDiagnostic\Lis.asmx:line 535
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 9:33:50 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at Lis.UpdtSmleCollctn(String ItemID, String btntxt, String colldate, String colltime, String IsCollectionDate, String receiverboytext, String barCode) in d:\Live Code\ArthDiagnostic\Lis.asmx:line 535
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 11:09:49 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at Lis.UpdtSmleCollctn(String ItemID, String btntxt, String colldate, String colltime, String IsCollectionDate, String receiverboytext, String barCode) in d:\Live Code\ArthDiagnostic\Lis.asmx:line 535
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 11:37:50 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at LabResultEntry.SaveResult(String LabNo, String Result, String Approved) in d:\Live Code\ArthDiagnostic\App_Code\BuisnessLogic\LabResultEntry.cs:line 563
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 11:45:03 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at LabOPD.LabPrescriptionOPD(String barcodeNo, String myAppNumber, String myAppDate, String PatientID, String Title, String PName, String Gender, String House_No, String City, String Phone, String Mobile, String Age, String DOB_ShowFormat, String DOB_DBFormat, String Relation, String RelationName, Int32 isActual, String Doctor_ID, String Panel_ID, String ReferedBy, String Source, Double TotalDiscAmt, Double TotalDiscPer, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String UniqueHash, String UserID, String ItemData, String PaymentData, Int32 rdDOB, String Sample, String PatientType, String ReportReceivingType, String SampleBySelf, String OtherDr, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile) in d:\Live Code\ArthDiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 1872
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 12:21:49 PM
 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at Lis.UpdtSmleCollctn(String ItemID, String btntxt, String colldate, String colltime, String IsCollectionDate, String receiverboytext, String barCode) in d:\Live Code\ArthDiagnostic\Lis.asmx:line 535
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 1:05:50 PM
 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: Deadlock found when trying to get lock; try restarting transaction
   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 Patient_Lab_InvestigationOPD.Insert() in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\Patient_Lab_InvestigationOPD.cs:line 537
   at LabOPD.LabPrescriptionOPD(String barcodeNo, String myAppNumber, String myAppDate, String PatientID, String Title, String PName, String Gender, String House_No, String City, String Phone, String Mobile, String Age, String DOB_ShowFormat, String DOB_DBFormat, String Relation, String RelationName, Int32 isActual, String Doctor_ID, String Panel_ID, String ReferedBy, String Source, Double TotalDiscAmt, Double TotalDiscPer, Double GrossAmount, Double NetAmount, String DiscReason, String Remarks, String ApprovedBy, String UniqueHash, String UserID, String ItemData, String PaymentData, Int32 rdDOB, String Sample, String PatientType, String ReportReceivingType, String SampleBySelf, String OtherDr, String CardNo, String Comments, String EmailID, String PDispatchData, String HomeVisitBoy, String Locality, String State, String centreID, String proid, String DiscountOn, String frRate, String referlab, String attcahedfile) in d:\Live Code\ArthDiagnostic\App_Code\BuisnessLogic\LabOPD.cs:line 1677
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 2:37:50 PM
 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at LabResultEntry.SaveResult(String LabNo, String Result, String Approved) in d:\Live Code\ArthDiagnostic\App_Code\BuisnessLogic\LabResultEntry.cs:line 563
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 3:33:50 PM
 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at Lis.UpdtSmleCollctn(String ItemID, String btntxt, String colldate, String colltime, String IsCollectionDate, String receiverboytext, String barCode) in d:\Live Code\ArthDiagnostic\Lis.asmx:line 535
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33


  **********************************************************  
 Time Of Error            : 10/13/2015 4:49:50 PM
 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: Deadlock found when trying to get lock; try restarting transaction
   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.ExecuteNonQuery()
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText, MySqlParameter[] commandParameters) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 324
   at MySqlHelper.ExecuteNonQuery(MySqlTransaction transaction, CommandType commandType, String commandText) in d:\Live Code\ArthDiagnostic\App_Code\DataLinkLayer\ODBCHelper.cs:line 300
   at Lis.UpdtSmleCollctn(String ItemID, String btntxt, String colldate, String colltime, String IsCollectionDate, String receiverboytext, String barCode) in d:\Live Code\ArthDiagnostic\Lis.asmx:line 535
 Error On Machine         : LABSERVER
 Error Machine IP Address : 192.168.2.33