Salesforce Null Pointer Exception

Talend Version          6.3.1

Summary

 
Additional Versions  
Product Talend Data Integration
Component  
Problem Description The customer designed a job with tSalesforceConnection and tSalesforceInput and he got the following exception:
Exception in component tSalesforceInput_1
java.lang.NullPointerException
at org.talend.components.salesforce.runtime.SalesforceInputReader.executeSalesforceQuery(SalesforceInputReader.java:149)
at org.talend.components.salesforce.runtime.SalesforceInputReader.start(SalesforceInputReader.java:95)
at evcrm_basecode_v32.job_hc_patient_identifier_to_oracle_0_1.JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.tSalesforceInput_1Process(JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.java:4548)
at evcrm_basecode_v32.job_hc_patient_identifier_to_oracle_0_1.JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.tOracleConnection_1Process(JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.java:3184)
at evcrm_basecode_v32.job_hc_patient_identifier_to_oracle_0_1.JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.tSalesforceConnection_1Process(JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.java:2930)
at evcrm_basecode_v32.job_hc_patient_identifier_to_oracle_0_1.JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.runJobInTOS(JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.java:15433)
at evcrm_basecode_v32.job_hc_patient_identifier_to_oracle_0_1.JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.main(JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE.java:14446)
[FATAL]: evcrm_basecode_v32.job_hc_patient_identifier_to_oracle_0_1.JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE - tSalesforceInput_1 null
2017-03-03 11:48:22|pbjt0O|pbjt0O|pbjt0O|EVCRM_BASECODE_V32|JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE|Default|6|Java Exception|tSalesforceInput_1|java.lang.NullPointerException:null|1
2017-03-03 11:48:22|pbjt0O|pbjt0O|pbjt0O|EVCRM_BASECODE_V32|JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE|Default|6|Java Exception|tSalesforceInput_1|java.lang.NullPointerException:null|1
2017-03-03 11:48:23|pbjt0O|pbjt0O|pbjt0O|9296|EVCRM_BASECODE_V32|JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE|_Wc4t0N0tEeaPMrODHAIQ3w|0.1|Default||end|failure|9196
2017-03-03 11:48:23|pbjt0O|pbjt0O|pbjt0O|9296|EVCRM_BASECODE_V32|JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE|_Wc4t0N0tEeaPMrODHAIQ3w|0.1|Default||end|failure|9196
[statistics] disconnected
Job JOB_HC_PATIENT_IDENTIFIER_TO_ORACLE ended at 11:48 03/03/2017. [exit code=1] 
Problem root cause They choose the "Query" as query type in tSalesforceInput, but checked the "Bulk Connection" in the Advanced Settings of tSalesforceConnection.
Solution or Workaround If you checked "Bulk Connection" in tSalesforceConnection, then you should choose "Bulk" as query type in tSalesforceInput.
Version history
Revision #:
4 of 4
Last update:
‎06-05-2017 01:16 PM
Updated by:
 
Labels (1)
Tags (1)