Hi

I have a With sharing class and a Time Triggered workflow on Opportunity. The workflow will close the Opportunity when criteria is met. When the workflow fires the Class will be invoked by the Trigger and I am trying to close all the Open Tasks related to the Opportunity. But the functionality is not workig properly, I am getting the INSUFFICIENT ACCESS TO CROSS REFERENCE OBJECT error. I think when the workflow is fired I am assuming the WITH SHARING class is consdering the USER Permissions that has submitted the Opportunity to the workflow. Any ideas or help Pls. 

Hi

I am trying to run the Data loader through command line and I am getting the following error. Can anyone help me where I am doing wrong.

ERROR MESSAGE:

C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration
>process.bat ./Config xnacMasterProcess
0 [main] INFO com.salesforce.dataloader.process.ProcessConfig  - Loading process
 configuration from config file: C:\Program Files\salesforce.com\Apex Data Loade
r 21.0\R4 Data Loader Integration\.\Config\process-conf.xml
78 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader  -
Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex Dat
a Loader 21.0\R4 Data Loader Integration\.\Config\process-conf.xml]
78 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader  -
 Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBuil
derFactoryImpl@1f42b49]
125 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver  -
 Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and syste
m ID [http://www.springframework.org/dtd/spring-beans.dtd]
125 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver  -
 Trying to locate [spring-beans.dtd] in Spring jar
141 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver  -
 Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classp
ath
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Loading bean definitions
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Default lazy init 'false'
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Default autowire 'no'
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Default dependency check 'none'
188 [main] INFO org.springframework.core.CollectionFactory  - JDK 1.4+ collectio
ns available
203 [main] INFO org.springframework.core.CollectionFactory  - Commons Collection
s 3.x available
203 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.ut
il.LinkedHashMap]
203 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Found 1 <bean> elements in file [C:\Program Files\salesforce.com\Apex D
ata Loader 21.0\R4 Data Loader Integration\.\Config\process-conf.xml]
219 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Creatin
g instance of bean 'xnacMasterProcess' with merged definition [Root bean: class
[com.salesforce.dataloader.process.ProcessRunner]; abstract=false; singleton=fal
se; lazyInit=false; autowire=0; dependencyCheck=0; initMethodName=null; destroyM
ethodName=null; factoryMethodName=null; factoryBeanName=null; defined in file [C
:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration\
.\Config\process-conf.xml]]
219 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invokin
g BeanPostProcessors before instantiation of bean 'xnacMasterProcess'
250 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Getting
 BeanInfo for class [com.salesforce.dataloader.process.ProcessRunner]
266 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Caching
 PropertyDescriptors for class [com.salesforce.dataloader.process.ProcessRunner]

266 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found p
roperty 'class' of type [java.lang.Class]
266 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found p
roperty 'configOverrideMap' of type [java.util.Map]
281 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found p
roperty 'controller' of type [com.salesforce.dataloader.controller.Controller]
281 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found p
roperty 'name' of type [java.lang.String]
281 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Class [
com.salesforce.dataloader.process.ProcessRunner] is cache-safe
281 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.ut
il.LinkedHashMap]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - About to invoke wr
ite method [public synchronized void com.salesforce.dataloader.process.ProcessRu
nner.setName(java.lang.String)] on object of class [com.salesforce.dataloader.pr
ocess.ProcessRunner]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - Invoked write meth
od [public synchronized void com.salesforce.dataloader.process.ProcessRunner.set
Name(java.lang.String)] with value of type [java.lang.String]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - About to invoke wr
ite method [public synchronized void com.salesforce.dataloader.process.ProcessRu
nner.setConfigOverrideMap(java.util.Map)] on object of class [com.salesforce.dat
aloader.process.ProcessRunner]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - Invoked write meth
od [public synchronized void com.salesforce.dataloader.process.ProcessRunner.set
ConfigOverrideMap(java.util.Map)] with value of type [java.util.Map]
313 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invokin
g BeanPostProcessors before initialization of bean 'xnacMasterProcess'
313 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invokin
g afterPropertiesSet() on bean with name 'xnacMasterProcess'
313 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invokin
g BeanPostProcessors after initialization of bean 'xnacMasterProcess'
359 [xnacMasterProcess] ERROR com.salesforce.dataloader.config.Config  - Error i
nitializing encryption for key file C:\Program Files\salesforce.com\Apex Data Lo
ader 21.0\R4 Data Loader Integration\EncryptionKey.key: Cannot Access Key File:
C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration
\EncryptionKey.key
375 [xnacMasterProcess] FATAL com.salesforce.dataloader.process.ProcessRunner  -
 Unable to run process xnacMasterProcess
java.lang.RuntimeException: com.salesforce.dataloader.exception.ControllerInitia
lizationException: Error loading config file: C:\Program Files\salesforce.com\Ap
ex Data Loader 21.0\R4 Data Loader Integration\.\Config\config.properties.  Plea
se make sure that it exists and is readable
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:86)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:74)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:226)
Caused by: com.salesforce.dataloader.exception.ControllerInitializationException
: Error loading config file: C:\Program Files\salesforce.com\Apex Data Loader 21
.0\R4 Data Loader Integration\.\Config\config.properties.  Please make sure that
 it exists and is readable
        at com.salesforce.dataloader.controller.Controller.initConfig(Controller
.java:333)
        at com.salesforce.dataloader.controller.Controller.<init>(Controller.jav
a:95)
        at com.salesforce.dataloader.controller.Controller.getInstance(Controlle
r.java:199)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:84)
        ... 2 more
Caused by: com.salesforce.dataloader.exception.ConfigInitializationException: Er
ror initializing encryption for key file C:\Program Files\salesforce.com\Apex Da
ta Loader 21.0\R4 Data Loader Integration\EncryptionKey.key: Cannot Access Key F
ile: C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integr
ation\EncryptionKey.key
        at com.salesforce.dataloader.config.Config.initEncryption(Config.java:70
2)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:616)
        at com.salesforce.dataloader.config.Config.load(Config.java:599)
        at com.salesforce.dataloader.config.Config.load(Config.java:575)
        at com.salesforce.dataloader.controller.Controller.initConfig(Controller
.java:327)
        ... 5 more
C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration
>

I have followed the following procedure

Generated an encrypted key and saved it in a file in .key format

encrypted my SFDC password along with security token using the encrypted key

created process.XML and Database.xml files

created config.properties file

when I tried to run the process.XML file through command prompt I am getting the above error message.

Follwing are the files I have created and placed then in a folder inside data loader folder

Process.XML file

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="xnacMasterProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <property name="name" value="xnacMasterProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.proxyHost" value="proxy host url"/>
                <entry key="sfdc.proxyPort" value="port number"/>
    <entry key="sfdc.endpoint" value="https://test.salesforce.com"/>
    <entry key="sfdc.username" value="test.user@mycompany.com"/>
                <entry key="sfdc.password" value="3b4c681773206eae857c4379730f9ddeb5c156a9a6b6fc2d338335aaf9c11b4bc2b15193613a5537"/>
                <entry key="process.encryptionKeyFile" value="C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration\Config\EncryptionKey.key"/>
                <entry key="sfdc.connectionTimeoutSecs" value="60"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
  <entry key="sfdc.entity" value="Account"/>
                <entry key="process.operation" value="extract"/>
                <entry key="sfdc.enableRetries" value="TRUE"/>
                <entry key="sfdc.maxRetries" value="3"/>
                <entry key="sfdc.minRetrySleepSecs" value="3"/>
                <entry key="dataAccess.name" value="queryXNAC"/>
                <entry key="dataAccess.type" value="databaseRead"/>
            </map>
        </property>
    </bean>
</beans>

Database.XML

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="dbDataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@(DESCRIPTION_LIST=(FAILOVER=TRUE) (LOAD_BALANCE=FALSE) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 13.121.13.195 ) (PORT = 1245)) (CONNECT_DATA = (SID = TEST))
 (CONNECT_DATA=(SERVICE_NAME=HRGLOBAL) (SERVER=DEDICATED) (FAILOVER_MODE=(TYPE=SELECT) (METHOD=PRECONNECT) (RETRIES=20)(DELAY=30)))) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 13.121.13.195 ) (PORT = 1245)) (CONNECT_DATA = (SID = TEST))
 (SERVER=DEDICATED)))"/>
    <property name="username" value="username"/>
    <property name="password" value="pwd"/>
</bean>
<bean id="queryXNAC"
      class="com.salesforce.dataloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="queryXNACSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>
<bean id="queryXNACSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            select parent3_xnac, parent3 from finaltable
        </value>
    </property>
    <property name="columnNames">
        <list>
        <value>parent3_xnac</value>
 <value>parent3</value>
        </list>
    </property>
</bean>
</beans>

Config.Properties

#Loader Config
sfdc.endpoint=https\://www.salesforce.com
sfdc.username=test.user@mycompany.com
sfdc.password=3b4c681773206eae857c4379730f9ddeb5c156a9a6b6fc2d338335aaf9c11b4bc2b15193613a5537
process.encryptionKeyFile=C:\\Program Files\\salesforce.com\\Apex Data Loader 21.0\\R4 Data Loader Integration\\Config\\EncryptionKey.key

Thanks in Advance

Hi Everyone,

I have wriiten below trigger to add weekdates to custom object. However I am getting the below error while executing the code. Can anyone help me out to resolve this issue.

trigger AddWeekends on Calendar__c (after insert) {
            List<Calendar__c> lstcal = new List<Calendar__c>();
            List<Calendar__c> lstcal1 = new List<Calendar__c>();
            Date orig = Date.today();
            system.debug('++++'+orig);
            Date satDate = Date.Parse('01/01/2011');
            Date sunDate = Date.Parse('01/02/2011');
            integer i;
           // Adding all Saturdays

            For(i=0; i<52; i++){
            Calendar__c cal = new Calendar__c();
            cal.Date__c = SatDate;
            cal.Holidays__c = 1;
            Cal.Description__c = 'Weekend';
            system.debug('#####'+SatDate);
            upsert Cal;
            satDate += 7;
        }

          // Adding all Sundays
            For(i=0; i<52; i++){
            Calendar__c cal1 = new Calendar__c();
            cal1.Date__c = SunDate;
            cal1.Holidays__c =2;
            Cal1.Description__c = 'Weekend';
            system.debug('$$$$$'+SunDate);
            upsert Cal1;
            sunDate += 7;
        }                   
}

Error Message:  Apex trigger AddWeekends caused an unexpected exception, contact your administrator: AddWeekends: execution of AfterInsert caused by: System.DmlException: Upsert failed. First exception on row 0; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, AddWeekends: maximum trigger depth exceeded Calendar trigger event AfterInsert for [a0O50000002GU5Q] Calendar trigger event AfterInsert for [a0O50000002GU5R] Calendar trigger event AfterInsert for [a0O50000002GU5S] Calendar trigger event AfterInsert for [a0O50000002GU5T] Calendar trigger event AfterInsert for [a0O50000002GU5U] Calendar trigger event AfterInsert for [a0O50000002GU5V] Calendar trigger event AfterInsert for [a0O50000002GU5W] Calendar trigger event AfterInsert for [a0O50000002GU5X] Calendar trigger event AfterInsert for [a0O50000002GU5Y] Calendar trigger event AfterInsert for [a0O50000002GU5Z] Calendar trigger event AfterInsert for [a0O50000002GU5a] Calendar trigger event AfterInsert for [a0O50000002GU5b] Calendar trigger event AfterInsert for [a0O50000002GU5c] Calendar trigger event AfterInsert for [a0O50000002GU5d] Calendar trigger event AfterInsert for [a0O50000002GU5e] Calendar trigger event AfterInsert for [a0O50000002GU5f]: []: Trigger.AddWeekends: line 15, column 13

Any help is appreciated...

Hi All,

I am using Checkbox in Page Block table. I am getting data from external system by invoking a webservice and displaying it in Page Block Table. I need to replce the Checkbox with Radio Button, But when I use the  Radio Button<selectRadio> tag it is getting selected by default for all the records can anyone help me out from this issue....

<apex:page StandardController="Opportunity" extensions="Sync_Page" >
   
       <script type="text/javascript">
        var selectedCheckBox;
        function deSelectOthers(CheckBox){
            if(CheckBox.checked){
                if((CheckBox != selectedCheckBox) && (selectedCheckBox != null))
                    selectedCheckBox.checked = false;
                }
             selectedCheckBox = CheckBox;
        }
         </script> 

    <b><apex:sectionHeader description="Deal Review Details" title="Opportunity"/></b>
        <apex:form id="formId">
          <apex:pageBlock id="pgbId">
            <apex:pageBlockButtons >
                 <apex:commandButton value="Save" action="{!Submit}"/>                  
                 <apex:commandButton value="Cancel" action="{!redirect1}" />
                 <apex:commandButton value="Get Details" action="{!redirect}"/>            
            </apex:pageblockButtons>
                <apex:pageMessages />
                <apex:pageBlockSection title="Deal Review Details"  columns="1" id="pgbsId">
                    <apex:pageBlockTable value="{!dealsList}" var="db"  id="drDetails">
                        <apex:column headerValue="Select" ><apex:inputCheckbox value="{!db.Checkbox}" onclick="deSelectOthers(this)" /></apex:column>                              
                        <apex:column headerValue="Last Modified Date" value="{!db.Closedate}"/>
                        <apex:column headerValue="Customer Name" value="{!db.CustomerName}"/>
                        <apex:column headerValue="Deal Name" value="{!db.Name}"/>
                        <apex:column headerValue="Deal Review Phase" value="{!db.Phase}"/>
                        <apex:column headerValue="Deal Review Stage" value="{!db.Status}"/>
                       
                    </apex:pageblockTable>
                 </apex:pageBlockSection>
              </apex:pageBlock>
           </apex:form>
</apex:page>

Thanks in advance.........

Hi All,

I am integrating SFDC with external system by invoking a webservice and fetching some details. The datatype of the data sent by external system for one field  is "Double" and I am also storing the data as "Double" in SFDC. I am able to dispaly all the values correctly but only one value is not displayed correctly in VF page(See the below example).

Values From External System     Values Displayed in SFDC         

34941753                                           35141753        

29274000                                           2.9274E+7 

Can you please tell me what might be the issue.

Thanks in advance....

Hi,

I had a scenario where when the user submits the record a workflow will be triggered and email to sent to verifier. I need to send the submitted record URL in the template to the verifier. Can anyone tell me how to do this.

Thanks  in advance...

Hi

I am retrieving data by consuming a webservice and displaying it in the visual force page using the page block table. I need to sort the records based on the date. Can anyone guide me to achieve this requirement.

Thanks in advance

Hello Everyone,

I have a picklist field with "submitted" and "approved" values. I need to calculate the number of days between the two dates i:e (the date that record was submitted and date that record was approved). Can anyone tell mehow to achieve this requirement.

Thanks in advance  

Hi everyone,

I am implemeting one way SSL and i am getting below error .

IO Exception: sun.security.validator.ValidatorException: PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException:
unable to find valid certification path to requested target

Can anyone help me about adding the client certificate to salesforce.

Thanks in advance

Hi I had a scenario where I need to pop-up a confirmation box after validating some fields(eg.Stage = xxxxx and XID =xxxxxx) for a standard save button click on standard page layout. Is it possible to achieve this requirement?

Hi

I have a With sharing class and a Time Triggered workflow on Opportunity. The workflow will close the Opportunity when criteria is met. When the workflow fires the Class will be invoked by the Trigger and I am trying to close all the Open Tasks related to the Opportunity. But the functionality is not workig properly, I am getting the INSUFFICIENT ACCESS TO CROSS REFERENCE OBJECT error. I think when the workflow is fired I am assuming the WITH SHARING class is consdering the USER Permissions that has submitted the Opportunity to the workflow. Any ideas or help Pls. 

Dear all

I am a newbie trying to customize the behaviour of salesforce when a user clicks 'Log a call' . I have a few requirements for this page:

1. This page will only be called from a contact detail page.
2. It should show a history of all the activities with this contact previously. Ideally it should show the last few calls/events with this contact.
3. It should present an interface to the user to add a new activity. The fields populated will be Last Contacted By, Nature of Contact (Call, Meeting), Related To (product, campaign or both), comments, date of contact and isfollowup required and follow up date.
4. It should be able to relate an event to multiple objects ie a Product and a contact and a campaign and a contact.

Any ideas how can I customize the current page to do the required. If creating a visualforce page is the way to go how should I proceed? Specifically how should I relate an activity to multiple objects (4).

Many Thanks

Hassnain.

Hi

I am trying to run the Data loader through command line and I am getting the following error. Can anyone help me where I am doing wrong.

ERROR MESSAGE:

C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration
>process.bat ./Config xnacMasterProcess
0 [main] INFO com.salesforce.dataloader.process.ProcessConfig  - Loading process
 configuration from config file: C:\Program Files\salesforce.com\Apex Data Loade
r 21.0\R4 Data Loader Integration\.\Config\process-conf.xml
78 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader  -
Loading XML bean definitions from file [C:\Program Files\salesforce.com\Apex Dat
a Loader 21.0\R4 Data Loader Integration\.\Config\process-conf.xml]
78 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader  -
 Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBuil
derFactoryImpl@1f42b49]
125 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver  -
 Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and syste
m ID [http://www.springframework.org/dtd/spring-beans.dtd]
125 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver  -
 Trying to locate [spring-beans.dtd] in Spring jar
141 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver  -
 Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classp
ath
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Loading bean definitions
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Default lazy init 'false'
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Default autowire 'no'
172 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Default dependency check 'none'
188 [main] INFO org.springframework.core.CollectionFactory  - JDK 1.4+ collectio
ns available
203 [main] INFO org.springframework.core.CollectionFactory  - Commons Collection
s 3.x available
203 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.ut
il.LinkedHashMap]
203 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser  - Found 1 <bean> elements in file [C:\Program Files\salesforce.com\Apex D
ata Loader 21.0\R4 Data Loader Integration\.\Config\process-conf.xml]
219 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Creatin
g instance of bean 'xnacMasterProcess' with merged definition [Root bean: class
[com.salesforce.dataloader.process.ProcessRunner]; abstract=false; singleton=fal
se; lazyInit=false; autowire=0; dependencyCheck=0; initMethodName=null; destroyM
ethodName=null; factoryMethodName=null; factoryBeanName=null; defined in file [C
:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration\
.\Config\process-conf.xml]]
219 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invokin
g BeanPostProcessors before instantiation of bean 'xnacMasterProcess'
250 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Getting
 BeanInfo for class [com.salesforce.dataloader.process.ProcessRunner]
266 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Caching
 PropertyDescriptors for class [com.salesforce.dataloader.process.ProcessRunner]

266 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found p
roperty 'class' of type [java.lang.Class]
266 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found p
roperty 'configOverrideMap' of type [java.util.Map]
281 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found p
roperty 'controller' of type [com.salesforce.dataloader.controller.Controller]
281 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Found p
roperty 'name' of type [java.lang.String]
281 [main] DEBUG org.springframework.beans.CachedIntrospectionResults  - Class [
com.salesforce.dataloader.process.ProcessRunner] is cache-safe
281 [main] DEBUG org.springframework.core.CollectionFactory  - Creating [java.ut
il.LinkedHashMap]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - About to invoke wr
ite method [public synchronized void com.salesforce.dataloader.process.ProcessRu
nner.setName(java.lang.String)] on object of class [com.salesforce.dataloader.pr
ocess.ProcessRunner]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - Invoked write meth
od [public synchronized void com.salesforce.dataloader.process.ProcessRunner.set
Name(java.lang.String)] with value of type [java.lang.String]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - About to invoke wr
ite method [public synchronized void com.salesforce.dataloader.process.ProcessRu
nner.setConfigOverrideMap(java.util.Map)] on object of class [com.salesforce.dat
aloader.process.ProcessRunner]
297 [main] DEBUG org.springframework.beans.BeanWrapperImpl  - Invoked write meth
od [public synchronized void com.salesforce.dataloader.process.ProcessRunner.set
ConfigOverrideMap(java.util.Map)] with value of type [java.util.Map]
313 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invokin
g BeanPostProcessors before initialization of bean 'xnacMasterProcess'
313 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invokin
g afterPropertiesSet() on bean with name 'xnacMasterProcess'
313 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory  - Invokin
g BeanPostProcessors after initialization of bean 'xnacMasterProcess'
359 [xnacMasterProcess] ERROR com.salesforce.dataloader.config.Config  - Error i
nitializing encryption for key file C:\Program Files\salesforce.com\Apex Data Lo
ader 21.0\R4 Data Loader Integration\EncryptionKey.key: Cannot Access Key File:
C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration
\EncryptionKey.key
375 [xnacMasterProcess] FATAL com.salesforce.dataloader.process.ProcessRunner  -
 Unable to run process xnacMasterProcess
java.lang.RuntimeException: com.salesforce.dataloader.exception.ControllerInitia
lizationException: Error loading config file: C:\Program Files\salesforce.com\Ap
ex Data Loader 21.0\R4 Data Loader Integration\.\Config\config.properties.  Plea
se make sure that it exists and is readable
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:86)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:74)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:226)
Caused by: com.salesforce.dataloader.exception.ControllerInitializationException
: Error loading config file: C:\Program Files\salesforce.com\Apex Data Loader 21
.0\R4 Data Loader Integration\.\Config\config.properties.  Please make sure that
 it exists and is readable
        at com.salesforce.dataloader.controller.Controller.initConfig(Controller
.java:333)
        at com.salesforce.dataloader.controller.Controller.<init>(Controller.jav
a:95)
        at com.salesforce.dataloader.controller.Controller.getInstance(Controlle
r.java:199)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:84)
        ... 2 more
Caused by: com.salesforce.dataloader.exception.ConfigInitializationException: Er
ror initializing encryption for key file C:\Program Files\salesforce.com\Apex Da
ta Loader 21.0\R4 Data Loader Integration\EncryptionKey.key: Cannot Access Key F
ile: C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integr
ation\EncryptionKey.key
        at com.salesforce.dataloader.config.Config.initEncryption(Config.java:70
2)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:616)
        at com.salesforce.dataloader.config.Config.load(Config.java:599)
        at com.salesforce.dataloader.config.Config.load(Config.java:575)
        at com.salesforce.dataloader.controller.Controller.initConfig(Controller
.java:327)
        ... 5 more
C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration
>

I have followed the following procedure

Generated an encrypted key and saved it in a file in .key format

encrypted my SFDC password along with security token using the encrypted key

created process.XML and Database.xml files

created config.properties file

when I tried to run the process.XML file through command prompt I am getting the above error message.

Follwing are the files I have created and placed then in a folder inside data loader folder

Process.XML file

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="xnacMasterProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <property name="name" value="xnacMasterProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.proxyHost" value="proxy host url"/>
                <entry key="sfdc.proxyPort" value="port number"/>
    <entry key="sfdc.endpoint" value="https://test.salesforce.com"/>
    <entry key="sfdc.username" value="test.user@mycompany.com"/>
                <entry key="sfdc.password" value="3b4c681773206eae857c4379730f9ddeb5c156a9a6b6fc2d338335aaf9c11b4bc2b15193613a5537"/>
                <entry key="process.encryptionKeyFile" value="C:\Program Files\salesforce.com\Apex Data Loader 21.0\R4 Data Loader Integration\Config\EncryptionKey.key"/>
                <entry key="sfdc.connectionTimeoutSecs" value="60"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
  <entry key="sfdc.entity" value="Account"/>
                <entry key="process.operation" value="extract"/>
                <entry key="sfdc.enableRetries" value="TRUE"/>
                <entry key="sfdc.maxRetries" value="3"/>
                <entry key="sfdc.minRetrySleepSecs" value="3"/>
                <entry key="dataAccess.name" value="queryXNAC"/>
                <entry key="dataAccess.type" value="databaseRead"/>
            </map>
        </property>
    </bean>
</beans>

Database.XML

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="dbDataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@(DESCRIPTION_LIST=(FAILOVER=TRUE) (LOAD_BALANCE=FALSE) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 13.121.13.195 ) (PORT = 1245)) (CONNECT_DATA = (SID = TEST))
 (CONNECT_DATA=(SERVICE_NAME=HRGLOBAL) (SERVER=DEDICATED) (FAILOVER_MODE=(TYPE=SELECT) (METHOD=PRECONNECT) (RETRIES=20)(DELAY=30)))) (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 13.121.13.195 ) (PORT = 1245)) (CONNECT_DATA = (SID = TEST))
 (SERVER=DEDICATED)))"/>
    <property name="username" value="username"/>
    <property name="password" value="pwd"/>
</bean>
<bean id="queryXNAC"
      class="com.salesforce.dataloader.dao.database.DatabaseConfig"
      singleton="true">
    <property name="sqlConfig" ref="queryXNACSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>
<bean id="queryXNACSql"
      class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true">
    <property name="sqlString">
        <value>
            select parent3_xnac, parent3 from finaltable
        </value>
    </property>
    <property name="columnNames">
        <list>
        <value>parent3_xnac</value>
 <value>parent3</value>
        </list>
    </property>
</bean>
</beans>

Config.Properties

#Loader Config
sfdc.endpoint=https\://www.salesforce.com
sfdc.username=test.user@mycompany.com
sfdc.password=3b4c681773206eae857c4379730f9ddeb5c156a9a6b6fc2d338335aaf9c11b4bc2b15193613a5537
process.encryptionKeyFile=C:\\Program Files\\salesforce.com\\Apex Data Loader 21.0\\R4 Data Loader Integration\\Config\\EncryptionKey.key

Thanks in Advance

Hi All,

I am using Checkbox in Page Block table. I am getting data from external system by invoking a webservice and displaying it in Page Block Table. I need to replce the Checkbox with Radio Button, But when I use the  Radio Button<selectRadio> tag it is getting selected by default for all the records can anyone help me out from this issue....

<apex:page StandardController="Opportunity" extensions="Sync_Page" >
   
       <script type="text/javascript">
        var selectedCheckBox;
        function deSelectOthers(CheckBox){
            if(CheckBox.checked){
                if((CheckBox != selectedCheckBox) && (selectedCheckBox != null))
                    selectedCheckBox.checked = false;
                }
             selectedCheckBox = CheckBox;
        }
         </script> 

    <b><apex:sectionHeader description="Deal Review Details" title="Opportunity"/></b>
        <apex:form id="formId">
          <apex:pageBlock id="pgbId">
            <apex:pageBlockButtons >
                 <apex:commandButton value="Save" action="{!Submit}"/>                  
                 <apex:commandButton value="Cancel" action="{!redirect1}" />
                 <apex:commandButton value="Get Details" action="{!redirect}"/>            
            </apex:pageblockButtons>
                <apex:pageMessages />
                <apex:pageBlockSection title="Deal Review Details"  columns="1" id="pgbsId">
                    <apex:pageBlockTable value="{!dealsList}" var="db"  id="drDetails">
                        <apex:column headerValue="Select" ><apex:inputCheckbox value="{!db.Checkbox}" onclick="deSelectOthers(this)" /></apex:column>                              
                        <apex:column headerValue="Last Modified Date" value="{!db.Closedate}"/>
                        <apex:column headerValue="Customer Name" value="{!db.CustomerName}"/>
                        <apex:column headerValue="Deal Name" value="{!db.Name}"/>
                        <apex:column headerValue="Deal Review Phase" value="{!db.Phase}"/>
                        <apex:column headerValue="Deal Review Stage" value="{!db.Status}"/>
                       
                    </apex:pageblockTable>
                 </apex:pageBlockSection>
              </apex:pageBlock>
           </apex:form>
</apex:page>

Thanks in advance.........