I am facing the issue while deploying the test class in production. The test class is working fine in sandbox but failing in production

System.DmlException: Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, field integrity exception: PricebookEntryId (pricebook entry is in a different pricebook than the one assigned to the opportunity): [PricebookEntryId]

Here is my code

public class CopytoOppLineItemTest{

     @isTest static void testTrigger(){

         Id pricebookId = Test.getStandardPricebookId();
         //Pricebook2  pb = [select name,id from Pricebook2 where  IsStandard =true  LIMIT 1];

        system.debug('pricebookId !!'+pricebookId );

         Product2 prod = new Product2(
             Name = 'Product X',
             ProductCode = 'Pro-X',
             isActive = true
        insert prod;

        //Create your pricebook entry
        PricebookEntry pbEntry = new PricebookEntry(
             Pricebook2Id =  pricebookId ,
             Product2Id = prod.Id,
             UnitPrice = 100.00,
             IsActive = true
        insert pbEntry;

        Opportunity op = new Opportunity();
        op.name = 'test';
        op.closedate = Date.today();
        op.StageName = 'Init';
        op.pricebook2Id  = pricebookId   ;
        insert op;
        system.debug('op.pricebook2Id!!!!'+op.pricebook2Id+'pbEntry.Pricebook2Id !!!'+pbEntry.Pricebook2Id);

         OpportunityLineItem  ol = new OpportunityLineItem();
         ol.opportunityid = op.id;
         ol.quantity = 4;       
         ol.TotalPrice = ol.quantity * pbEntry.UnitPrice ;
         ol.PricebookEntryId = pbEntry.id ;

         insert ol;



I have also checked the values in debug in production, the value of opportunity pricebookid and pricebookentry pricebookid are the same

(system.debug('op.pricebook2Id!!!!'+op.pricebook2Id+'pbEntry.Pricebook2Id !!!'+pbEntry.Pricebook2Id);)

Please help me on this issue.

1 Answer 1


You most likely have a Process Builder or a trigger, or wfr setting the price book on insert of the opportunity.

You did debug and that is good but you only debugged what you created not the results after it was committed to the database.

Before your debug, query for the opportunity and check if the pricebook2id is the same and what your set it to be:

Opportunity tmp = [Select PriceBook2Id from Opportunity Where Id = :op.id];
system.assertEquals(pricebookId,tmp.PriceBook2Id,'The Opportunity price book was modified after it was inserted');
  • what's the fix?
    – sfdcFanBoy
    Aug 17, 2017 at 7:04
  • Thank you! I was pulling my hair out, because of this issue.
    – ArturoO
    Feb 10, 2021 at 7:51

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .