function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
zAkszAks 

no viable alternative at character ' ' at line 1:68

Hi All, 

i have wrote a batch class ,But looks i am going Wrong Smewer , it shows 
 no viable alternative at character ' ' 


my code looks like :

global class RMABatchProcess implements Database.Batchable<sObject>{ 
     
     public String query ;              
     public List<RMA_Staging__c> RMAStgobj = new List<RMA_Staging__c>();
     public List<RMA_Staging_Lines__c> RMAStgLine = new List<RMA_Staging_Lines__c>();
     
    
     global RMABatchProcess() {            
        this.query = 'SELECT Id,Name,RecordTypeId,SM_Catalyst_RMA_Reason__c,SVMXC__Address_Type__c,SVMXC__Company__r.Name,SVMXC__Destination_City__c,SVMXC__Destination_Country__c,SVMXC__Destination_Location__r.Name,SVMXC__Destination_State__c,SVMXC__Destination_Street__c,SVMXC__Destination_Zip__c,SVMXC__Expected_Delivery_Date__c,SVMXC__Order_Status__c,SVMXC__Order_Type__c,SVMXC__Parts_Request__r.Name,SVMXC__Priority__c,SVMXC__RMA_Type__c,SVMXC__Service_Engineer__r.Name,SVMXC__Service_Order__r.Name,SVMXC__Source_City__c,SVMXC__Source_Country__c,SVMXC__Source_Location__r.Name,SVMXC__Source_State__c,(SELECT Id,Name,RecordTypeId,SVMXC__Actual_Quantity2__c,SVMXC__Actual_Receipt_Date__c,SVMXC__Disposition__c,SVMXC__Expected_Condition__c,SVMXC__Expected_Quantity2__c,SVMXC__Line_Status__c,SVMXC__Parts_Request_Line__r.Name,SVMXC__Product__r.Name,SVMXC__RMA_Shipment_Order__r.Name,SVMXC__Serial_Number__c,SVMXC__Service_Engineer__r.Name,SVMXC__Service_Order__r.Name FROM SVMXC__RMA_Shipment_Line__r WHERE SVMXC__Line_Status__c = \'Open\'),SVMXC__Source_Street__c,SVMXC__Source_Zip__c FROM SVMXC__RMA_Shipment_Order__c WHERE SVMXC__Order_Status__c = \'Open\' and RecordtypeId= \'012410000004qj3\'';        
    }
    
    global Database.QueryLocator start (Database.BatchableContext bc){
       return Database.getQueryLocator(query);
    }
    
    global void execute (Database.BatchableContext bc,List<sObject> scope){
       for (sObject obj : scope){
            SVMXC__RMA_Shipment_Order__c stageRMA = (SVMXC__RMA_Shipment_Order__c)obj;
            RMA_Staging__c RMAStg = new RMA_Staging__c();

            RMAStg.Name = stageRMA.Name;
            RMAStg.Order_Type__c = stageRMA.SVMXC__Order_Type__c;
            RMAStg.Address_Type__c = stageRMA.SVMXC__Address_Type__c;
            RMAStg.Expected_Delivery_Date__c = stageRMA.SVMXC__Expected_Delivery_Date__c;
            RMAStg.RMA_Type__c = stageRMA.SVMXC__RMA_Type__c;
            RMAStg.Service_Engineer__c = stageRMA.SVMXC__Service_Engineer__r.Name;
            RMAStg.Work_Order__c= stageRMA.SVMXC__Service_Order__r.Name;
            RMAStg.Account__c = stageRMA.SVMXC__Company__r.Name;
            RMAStg.From_City__c = stageRMA .SVMXC__Source_City__c;
            RMAStg.From_Country__c = stageRMA .SVMXC__Source_Country__c;
            RMAStg.From_Location__c = stageRMA .SVMXC__Source_Location__r.Name;
            RMAStg.From_State__c = stageRMA .SVMXC__Source_State__c ;                          
            RMAStg.From_Street__c = stageRMA .SVMXC__Source_Street__c;
            RMAStg.From_Zip__c = stageRMA .SVMXC__Source_Zip__c;            
            RMAStg.Order_Type__c = stageRMA .SVMXC__Order_Type__c; 
            RMAStg.Receiving_Notes__c = stageRMA.SVMXC__Shipping_Receiving_Notes__c ;
            RMAStg.RMA_Reason__c=  stageRMA.SM_Catalyst_RMA_Reason__c ;              
            RMAStg.To_City__c =stageRMA .SVMXC__Destination_City__c;
            RMAStg.To_Country__c = stageRMA .SVMXC__Destination_Country__c;
            RMAStg.To_Location__c = stageRMA .SVMXC__Destination_Location__r.Name;                                                   
            RMAStg.To_State__c = stageRMA .SVMXC__Destination_State__c;     
            RMAStg.To_street__c = stageRMA .SVMXC__Destination_Street__c;   
            RMAStg.To_Zip__c = stageRMA .SVMXC__Destination_Zip__c;                            
            RMAStgobj.add(RMAStg); 
            
            for(SVMXC__RMA_Shipment_Line__c RMA1_Line : stageRMA.SVMXC__RMA_Shipment_Line__r){
           
             if(stageRMA.SVMXC__Order_Status__c == 'Open'){
             RMA_Staging_Lines__c RMA_Line_stg = new RMA_Staging_Lines__c();
             RMA_Line_stg.Parts_Order__c = stageRMA.Name;
             RMA_Line_stg.Actual_Qty__c=POdrRMA1_Line_Line.SVMXC__Actual_Quantity2__c;
             RMA_Line_stg.Disposition__c = RMA1_Line.SVMXC__Disposition__c;
             RMA_Line_stg.Expected_Qty__c=RMA1_Line.SVMXC__Expected_Quantity2__c;
             RMA_Line_stg.Expected_Condition__c =RMA1_Line.SVMXC__Expected_Condition__c;
             RMA_Line_stg.IB_Serial_Number__c =RMA1_Line.SVMXC__Serial_Number__c;
             RMA_Line_stg.Actual_Receipt_Date__c =RMA1_Line.SVMXC__Actual_Receipt_Date__c;
             //RMA_Line_stg.Parts_Request_Line__c=RMA1_Line.SVMXC__Parts_Request_Line__r.Name;
             RMA_Line_stg.Product__c=RMA1_Line.SVMXC__Product__r.Name;
             RMA_Line_stg.Name = RMA1_Line.Name;
             RMAStgLine.add(RMA_Line_stg);
            }
           }              
        }
        try {  
            upsert RMAStgobj Name;  
            upsert RMAStgLine Name;   
   
        } catch (DmlException e) { 
            System.debug('Insertion of RMA and RMALines failed : '+e.getMessage());
        }
    } 
   
    global void finish (Database.BatchableContext bc){
     }
 }

thanks:
 
zAkszAks
HI piyush soni

Thanks for Responding,

I tried repalcing all all single quotes, But yet its not Resolved.