********************************************************** Time Of Error : 10/27/2020 12:37:57 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 RateList.Insert() in e:\Itdose\Livecode\City\App_Code\DataLinkLayer\RateList.cs:line 413 at MapInvestigation_Observation.UpdateInvestigation(String InvName, String TestCode, String InvID, String ItemID, String DepartmentID, String InvObsId, String DepartmentName, String ReportType, String SampleType, String ShortName, String IsOutSrc, String TimeLimit, String SampleQty, String SampleRmks, String ColorCode, String Gender, String showPtRpt, String ShowAnlysRpt, String ShowOnlnRpt, String IsAutoStore, String isUrgent, String SampleTypeID, String MaxDiscount, String Reporting, String Booking, Int32 IsActive, String BillCategoryID, String IsOrganism, String IsCulture, String IsMic, String PrintSeparate, String PrintSampleName, String Rate, String autoconsume, String BillingCategory, String ConsentType, String Showinprotarget, String IsWeightLMP) in e:\Itdose\Livecode\City\App_Code\BuisnessLogic\MapInvestigation_Observation.cs:line 568 Error On Machine : DESKTOP-6I316T6 Error Machine IP Address : 192.168.31.22 ********************************************************** Time Of Error : 10/27/2020 4:30:27 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 MapInvestigation_Observation.UpdateInvestigation(String InvName, String TestCode, String InvID, String ItemID, String DepartmentID, String InvObsId, String DepartmentName, String ReportType, String SampleType, String ShortName, String IsOutSrc, String TimeLimit, String SampleQty, String SampleRmks, String ColorCode, String Gender, String showPtRpt, String ShowAnlysRpt, String ShowOnlnRpt, String IsAutoStore, String isUrgent, String SampleTypeID, String MaxDiscount, String Reporting, String Booking, Int32 IsActive, String BillCategoryID, String IsOrganism, String IsCulture, String IsMic, String PrintSeparate, String PrintSampleName, String Rate, String autoconsume, String BillingCategory, String ConsentType, String Showinprotarget, String IsWeightLMP) in e:\Itdose\Livecode\City\App_Code\BuisnessLogic\MapInvestigation_Observation.cs:line 491 Error On Machine : DESKTOP-6I316T6 Error Machine IP Address : 192.168.31.22 ********************************************************** Time Of Error : 10/27/2020 4:30:44 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 MapInvestigation_Observation.UpdateInvestigation(String InvName, String TestCode, String InvID, String ItemID, String DepartmentID, String InvObsId, String DepartmentName, String ReportType, String SampleType, String ShortName, String IsOutSrc, String TimeLimit, String SampleQty, String SampleRmks, String ColorCode, String Gender, String showPtRpt, String ShowAnlysRpt, String ShowOnlnRpt, String IsAutoStore, String isUrgent, String SampleTypeID, String MaxDiscount, String Reporting, String Booking, Int32 IsActive, String BillCategoryID, String IsOrganism, String IsCulture, String IsMic, String PrintSeparate, String PrintSampleName, String Rate, String autoconsume, String BillingCategory, String ConsentType, String Showinprotarget, String IsWeightLMP) in e:\Itdose\Livecode\City\App_Code\BuisnessLogic\MapInvestigation_Observation.cs:line 491 Error On Machine : DESKTOP-6I316T6 Error Machine IP Address : 192.168.31.22