You need to sign in to do that
Don't have an account?
zAks
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:
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:
Thanks for Responding,
I tried repalcing all all single quotes, But yet its not Resolved.