Getting an error while I upload the Opportunity records using data loader.

ERROR: dlrs_OpportunityTrigger: execution of AfterInsertcaused by: System.QueryException: List has more than 1 row for assignment to SObject()

Here is the trigger code:

trigger dlrs_OpportunityTrigger on Opportunity (before delete, before insert, before update, after delete, after insert, after undelete, after update) {

    if (trigger.isafter&& trigger.isInsert) {
        Set<id> oId = new set<id>();
        for(Opportunity opp : trigger.new) {

        Opportunity opp = [select Id ,NRR_value__c ,CurrencyIsoCode,RecordTypeId,recordtype.name from Opportunity where ID =: oId];

        PriceBookEntry p = [SELECT Id, Product2Id, Product2.Id, Product2.Name, CurrencyIsoCode
                        FROM PriceBookEntry
                        WHERE  Product2Id='01t0J00000IDOpDQAX' and CurrencyIsoCode =: opp.CurrencyIsoCode
                        and Pricebook2Id = '01s0J000002SCKDQA4' LIMIT 1];
        string recordtypename = Schema.SObjectType.Opportunity.getRecordTypeInfosById().get(opp.recordtypeid).getname();
        system.debug(' recordtypename*************'+recordtypename);
        List<OpportunityLineItem> oliList = new List<OpportunityLineItem>();
        for(Opportunity op : trigger.new){
            if(opp.RecordType.Name == 'Services Record Type'){
                OpportunityLineItem oli = new OpportunityLineItem();
                oli.OpportunityId = opp.Id;
                oli.Quantity = 1;
                oli.PricebookEntryId = p.Id;
                //oli.name = opp.name;
                oli.UnitPrice = opp.NRR_value__c;
        insert oliList;

1 Answer 1


Your query is returning more than one record, but the variable 'opp' is a single instance and not a List of Opportunities. If you change the code as following, it will work.

 List<Opportunity> opp = new List<Opportunity>([select Id ,NRR_value__c ,CurrencyIsoCode,RecordTypeId,recordtype.name from Opportunity where ID =: oId]);

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.