UpdateOpportunityAmount: execution of BeforeUpdate

caused by: System.DmlException: Update failed. First exception on row 0 with id 00k60000005cTOLAA2; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, UpdateOpportunityProduct: execution of BeforeUpdate

caused by: System.DmlException: Update failed. First exception on row 0 with id 0066000000APwGhAAL; first error: UNKNOWN_EXCEPTION, Object (id = 0066000000APwGh) is currently being updated in trigger UpdateOpportunityAmount: [Id]

Trigger.UpdateOpportunityProduct: line 45, column 17

Trigger.UpdateOpportunityAmount: line 27, column 17

SELECT distinct sc.fice, sc.state, sc.product
FROM dbo.allsls AS sc (NOLOCK)
      WHERE sc.trxdate BETWEEN '07/01/2004' AND '06/30/2006'  -- Colleges bought 3 to 4 FY ago (2005-2006) (i.e. not last FY year, but last 3)
AND NOT EXISTS (SELECT t1.product FROM dbo.allsls as t1 (NOLOCK)
                WHERE t1.product = sc.product AND t1.fice = sc.fice
                AND t1.trxdate BETWEEN '07/01/2006' AND '06/30/2008' -- Didn't buy current FY (2008) or prev FY (2007) 
                )

result = sforce.connection.query("Select fice__c from Account where Id like ’" + name + "’");

AND(On_Behalf_of__c , IF(  ISPICKVAL( On_Behalf_of_User__c, "none") , FALSE, TRUE)).

trigger UniqueRoleProductTrigger on Contact_Role__c (before insert, before update)
{
   if (Trigger.isBefore) 
   {
   if (Trigger.isUpdate)
   {
 for (Integer i = 0; i < Trigger.new.size(); i++) 
 {
     Contact_Role__c newRole = Trigger.new[i];

            Contact curContact =
               [select id, AccountId from Contact where id = :newRole.Contact_Person__c];

           Contact_Role__c[] RoleProduct = 
                  [select id, Product__c, Role__c from Contact_Role__c
                   where id = :newRole.Id];

               for (Contact_Role__c r: RoleProduct) 
               {
                  if ((r.Product__c == newRole.Product__c) && (r.Role__c == newRole.Role__c))
                  {
                    r.addError('Role, Product pair already exists. Can not have duplicate Role-Product pair for the same contact.');
                  } //end of if statement

   
  }  //end of for loop 
         }
   }//end if update
   }
}

SELECT distinct sc.fice, sc.state, sc.product
FROM dbo.allsls AS sc (NOLOCK)
      WHERE sc.trxdate BETWEEN '07/01/2004' AND '06/30/2006'  -- Colleges bought 3 to 4 FY ago (2005-2006) (i.e. not last FY year, but last 3)
AND NOT EXISTS (SELECT t1.product FROM dbo.allsls as t1 (NOLOCK)
                WHERE t1.product = sc.product AND t1.fice = sc.fice
                AND t1.trxdate BETWEEN '07/01/2006' AND '06/30/2008' -- Didn't buy current FY (2008) or prev FY (2007) 
                )