• Rohit Apsangi
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 1
    Likes Given
  • 1
    Questions
  • 1
    Replies
There was an unexpected error in your org which is preventing this assessment check from completing: System.QueryException: List has more than 1 row for assignment to SObject
Hi,

After clicking on the "Query" button records will be displayed ! can you please mention the clear steps after this to export the data! It is asking for 'package.xml ' and package name! i finally need to export my data it into a excel file!

Thanks!
I have written an apex trigger and it is trowing me an error at line 13 col 17 stating "Error: Compile Error: unexpected token: '=' at line 13 column 17". Can someone help me resolve the error.

trigger Update_TrackingId_MSRLineItem_to_ReplacementPart on MSR_Line_Item__c (after update) 
{
 Map<Id, Replacement_Part__c> replacement  = new Map<Id, Replacement_Part__c>();
    List<Id> listIds = new List<Id>();
    
    for(MSR_Line_Item__c msr : Trigger.new)
    {
        if(msr.Tracking_ID__c != null && msr.MSR_PS_ID__c != null && msr.Replacement_Part__c != null)
        {
        listIds.add(msr.Replacement_Part__c);        
        }        
    }
    replacement = new Map<Id, Replacement_Part__c>([SELECT Id, Tracking_Id__c, MSR_PS_ID__c (SELECT Id, Tracking_Id__c, MSR_PS_ID__c FROM MSR_Line_Items__r) FROM Replacement_Part__c WHERE ID IN:listIds]);
    
    for(MSR_Line_Item__c newmsr : Trigger.new)
    {
        
        Replacement_Part__c rpart = new Replacement_Part__c();
        if(newmsr.Replacement_Part__c != null)
        {
            if(replacement.get(newmsr.Replacement_Part__c) != null)
            rpart = replacement.get(newmsr.Replacement_Part__c);
        }
        if(newmsr.Tracking_ID__c != null && newmsr.MSR_PS_ID__c != null)
        {
            rpart.Tracking_ID__c = newmsr.Tracking_ID__c;
            rpart.MSR_PS_ID__c = newmsr.MSR_PS_ID__c;
        }
        
    }
    update replacement.values();
}

Thanks in advance