I  Hav one batch class on Accoun running every hour. and  on account object one more trigger calling the @future method in class.


wen i run te batch iam getting this error. How to avoid thsi error.


 

Hi all,

While trying to update a series in recurssive event I'm getting an error "UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record ".

I have a code in trigger to update event attendees name on updation of an event. I have return this code in future onAfterUpdateAsync method. It is working fine for normal events but for recurssive events I'm getting this error.

Please help me in resolving this?

Hi ,

I am trying to create a batch process to extract record IDs from CampaignMember Object from Command line. But it is throwing the folliwng error. Could you please help me on this.

2014-01-27 06:21:39,237 INFO  [main] controller.Controller initLog (Controller.java:388) - The log has been initialized
2014-01-27 06:21:39,244 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configuration from config file: C:\users\
stanikanti\desktop\test2\process-conf.xml
2014-01-27 06:21:39,360 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from fi
le [C:\users\stanikanti\desktop\test2\process-conf.xml]
2014-01-27 06:21:39,398 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process: campaignMemberExtract configura
tion from config file: C:\users\stanikanti\desktop\test2\process-conf.xml
org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'campaignMemberExtract' is defined

Below is the code I am using. Please help me on this error? (Coommand I am using is > Process.bat "path for process-conf.xml" campaignMemberExctract)

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="csvCampaignMemberExtractProcess"
class="com.salesforce.dataloader.process.ProcessRunner"
singleton="false">


<property name="name" value="csvCampaignMemberExtractProcess"/>
<property name="configOverrideMap">

<map>
<entry key="sfdc.debugMessages" value="true"/>
<entry key="sfdc.debugMessagesFile"
value="C:\Users\xxxxxxx\Desktop\Test2\campaignMemberExtractSoapTrace.log"/>

<entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
<entry key="sfdc.username" value="xxxx@xxxxxxx.com"/>

<entry key="sfdc.password" value="xxxxxxxxxxxxxxxxxxxxxxxxx"/>
<entry key="process.encryptionKeyFile"
value="C:\Users\xxxxxx\Desktop\Test2\Mykey.txt"/>

<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>



<entry key="sfdc.entity" value="campaignMember"/>


<entry key="sfdc.extractionRequestSize" value="500"/>

    <entry key="sfdc.extractionSOQL" value="Select Id FROM CampaignMember"/>

<entry key="process.operation" value="extract"/>

<entry key="process.mappingFile"
value="C:\Users\xxxxxxxxxxxxxxxx\Desktop\Test2\campaignMemberExtractMap.sdl"/>



<entry key="dataAccess.type" value="csvWrite"/>
<entry key="dataAccess.name" value="C:\Users\xxxxxxxx\Desktop\Test2\Extract.csv"/>

<entry key="process.initialLastRunDate"
value="2005-12-01T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>

I  Hav one batch class on Accoun running every hour. and  on account object one more trigger calling the @future method in class.


wen i run te batch iam getting this error. How to avoid thsi error.


 

Hi everyone.

Can you please help me to fix this error: I have a trigger that would send an email alert to new Assigned To user. 

here is the code: 

trigger SendEmailAlertToAssignedTo on Site_Defects__c ( before update) {
 
    if(Trigger.new[0].Assigned_To__c != Trigger.old[0].Assigned_To__c ) {
        
            //Sending Mail
            Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage() ;
           
                //Setting user email in to address
            String userName = Trigger.new[0].Assigned_To__c;
              
            User AT = [Select Email From User where name = : userName ];  // I have the error message here
            String userEmail = AT.Email;
           
           
            //String email = Trigger.new[0].RegionalManager__c;
            String[] toAddresses = new String[] {userEmail} ;
           
            // Assign the addresses for the To and CC lists to the mail object
            mail.setToAddresses(toAddresses );
            mail.setToAddresses(MyEmail);
           
            //Email subject to be changed
            mail.setSubject('THIS IS A TEST. Site Defect Owner Changed');
            String body = AT.Email+'The owner of Site Defect ' + trigger.Old[0].Name +' has been changed <br> <br>'+
            'Regards <br> <br>'+
            'Phillips 66 Limited <br>'+
            'Phillips 66 Centre <br>'+
            '2 Kingmaker Court <br>'+
            'Warwick Technology Park<br> '+
            'Warwick, CV34 6DB. <br> <br> <br>'+
            'Phillips 66 Limited is a company registered in England with Company No. 529086 <br>'+
            'Registered Office: 7th Floor, 200-202 Aldersgate Street, London, EC1A 4HD.<br>';
            //Body of email
            mail.setHtmlBody(body);
           
            //Sending the email
            Messaging.sendEmail(new Messaging.SingleEmailMessage[] { mail });
            }
}



Thank you

Hi all,

While trying to update a series in recurssive event I'm getting an error "UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record ".

I have a code in trigger to update event attendees name on updation of an event. I have return this code in future onAfterUpdateAsync method. It is working fine for normal events but for recurssive events I'm getting this error.

Please help me in resolving this?

I'm trying to make a query which fetches the latest(one) data per setup. I've made it this far with the query
So the problem is I should fetch the latest recurring fee data from setup, but can't understand should I use Group by or order by to fetch from every setup the latest recurring fee data.

Select id, name, date_of_invoice__c, setup__c from recurring_fee__c where
setup__c in (select id from Setup__c where RecordType.name IN( 'infra','hardware' )
and cost_center__r.groupid__c = '0012000000AK643' ) ORDER BY setup__c desc

Hello Everyone,
I worte the code where i am able to connect the endpoint and get the values and update ,and it works awesome.
But i can only 150 DML statement ,so i thought of bulkify
But could not able to get how to add in the list
Code is here
public class JSONParserUtil {

    @future(callout=true)
   
   public static void parseJSONResponse(String Acctname,String Ids)
   // public static void parseJSONResponse()
     {      
        String AcctNameJson;
        system.debug('AccountName______________________________'+AcctName);
        String JSONContent = '{"folionum":'+AcctName+'}';
        System.debug('JSONContent____________________'+JSONContent);
        Http httpProtocol = new Http();
        // Create HTTP request to send.
        HttpRequest request = new HttpRequest();
        // Set the endpoint URL.
        String endpoint = 'http://abc.xyz.net/api/values';
        request.setEndPoint(endpoint);
        request.setHeader('content-type', 'application/json; charset=utf-8');
        request.setMethod('POST');
       // String strbody = '{"folionum":48430721840}';
        request.setBody(JSONContent);
        HttpResponse response = httpProtocol.send(request);
       // String jsonInput = response.getBody(); UCOMMENETED TO READ TEH JSON
        JSONParser parser = JSON.createParser(Response.getBody());
        system.debug('JSON PARESER___________________'+parser );
        system.debug('Respone'+Response.getBody());
        double sqft ;
        String avgrentpsft ;
        String months12pavg ;
        String monthsps12ftavg ;
        String peakspavg ;
        String peakspsftavg ;
       
        
         while (parser.nextToken() != null)
         {
           //if ((parser.getCurrentToken() == JSONToken.FIELD_NAME) &&(parser.getText() == 'sqft') &&(parser.getText() == 'avgrentpsft')&&(parser.getText() == '12monthspavg')
            //&&(parser.getText() == '12monthspsftavg') &&(parser.getText() == '12monthspsftmax') &&(parser.getText() == 'peakspavg') &&(parser.getText() == 'peakspsftavg'))
           
            //if ((parser.getCurrentToken() == JSONToken.FIELD_NAME) &&(parser.getText() == 'sqft') (parser.getText() == 'sqft'))
            if (parser.getCurrentToken() == JSONToken.FIELD_NAME)
             {
                
                 String text = parser.getText();
              parser.nextToken();
              if(text == 'sqft')
              {
               sqft = parser.getDoubleValue();
              }else if(text == 'avgrentpsft'){
               avgrentpsft=parser.getText();
              }
              else if(text == '12monthspavg'){
               months12pavg =parser.getText();
              }
              else if(text == '12monthspsftavg'){
               monthsps12ftavg =parser.getText();
              }
              else if(text == '12monthspsftmax'){
               monthsps12ftavg=parser.getText();
              }
              else if(text == 'peakspavg'){
               peakspavg=parser.getText();
              }
              else if(text == 'peakspsftavg'){
               peakspsftavg=parser.getText();
              }
                 /* sqft=parser.getDoubleValue();
                  avgrentpsft=parser.getText();
                   months12pavg=parser.getText();
                    monthsps12ftavg=parser.getText();
                     peakspavg=parser.getText();
                  peakspsftavg=parser.getText();
                   parser.nextToken();
                   */
     
             }
          }
                    system.debug('TotalAqft' + sqft);
                   
         if (response.getStatusCode() == 200) {

      //update account
    
      Property_Obj__c acc = new Property_Obj__c(Id=Ids);
      acc.Ave_Rent_sf_Per_Area__c =sqft;
      acc.Brkr_Remrks_2__c=avgrentpsft;
      acc.Garag_Desc__c=months12pavg;
      acc.Brkr_Remarks__c=monthsps12ftavg;
      acc.city__c=monthsps12ftavg;
      acc.DOM__c=peakspavg;
      acc.Address__c=peakspsftavg;
      update acc;
    } else {
      System.debug('Callout failed: ' + response);
    }  
         
                   
}
}

Please help out .

Regards,
Sailer

Hi ,

I am trying to create a batch process to extract record IDs from CampaignMember Object from Command line. But it throwing the folliwng errors. Could you please me on this.

2014-01-27 06:21:39,237 INFO  [main] controller.Controller initLog (Controller.java:388) - The log has been initialized
2014-01-27 06:21:39,244 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configuration from config file: C:\users\
stanikanti\desktop\test2\process-conf.xml
2014-01-27 06:21:39,360 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from fi
le [C:\users\stanikanti\desktop\test2\process-conf.xml]
2014-01-27 06:21:39,398 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process: campaignMemberExtract configura
tion from config file: C:\users\stanikanti\desktop\test2\process-conf.xml
org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'campaignMemberExtract' is defined
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:529)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1095)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:277)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:246)
2014-01-27 06:21:39,401 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: campaignMemberExtract configuration from config file: C:\users\stan
ikanti\desktop\test2\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:97)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:287)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:273)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:246)
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'campaignMemberExtract' is defined
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:529)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1095)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:277)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        ... 3 more

I get an error message when I query for null values in double fields (currenciy fields for example).

 

 

This has been asked and solved for dates (example here: http://forums.sforce.com/t5/Other-Salesforce-Applications/Date-in-Query-gives-Error-Generated-by-request-ExceptionCode/m-p/160107), but for doubles it seems to be different. I digged through the code trying to get NULL into the query string, but with no luck.

 

Any ideas?