Exception in tSalesforceInput component

[manodwhb]

Hi,

I am getting below error,while testting in UAT enviroment,but same inteface has working well in Production.

Please fine below error.

Error

Exception in component tSalesforceInput_8 (SF_TO_CLARITY)
org.talend.components.api.exception.ComponentException: org.talend.daikon.exception.error.DefaultErrorCode@324c64cd:{failedBatch=[BatchInfo id='75125000001W8MXAA0'
jobId='75025000001lIegAAE'
state='InProgress'
stateMessage='null'
createdDate='java.util.GregorianCalendar[time=1515565906000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2018,MONTH=0,WEEK_OF_YEAR=2,WEEK_OF_MONTH=2,DAY_OF_MONTH=10,DAY_OF_YEAR=10,DAY_OF_WEEK=4,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=6,HOUR_OF_DAY=6,MINUTE=31,SECOND=46,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'
systemModstamp='java.util.GregorianCalendar[time=1515565907000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2018,MONTH=0,WEEK_OF_YEAR=2,WEEK_OF_MONTH=2,DAY_OF_MONTH=10,DAY_OF_YEAR=10,DAY_OF_WEEK=4,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=6,HOUR_OF_DAY=6,MINUTE=31,SECOND=47,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'
numberRecordsProcessed='0'
numberRecordsFailed='0'
totalProcessingTime='0'
apiActiveProcessingTime='0'
apexProcessingTime='0'
]
}
at org.talend.components.salesforce.runtime.SalesforceBulkRuntime.doBulkQuery(SalesforceBulkRuntime.java:501)
at org.talend.components.salesforce.runtime.SalesforceBulkQueryInputReader.executeSalesforceBulkQuery(SalesforceBulkQueryInputReader.java:114)
at org.talend.components.salesforce.runtime.SalesforceBulkQueryInputReader.start(SalesforceBulkQueryInputReader.java:56)
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tSalesforceInput_8Process(SF_TO_CLARITY.java:29433)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tFixedFlowInput_5Process(SF_TO_CLARITY.java:26946)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tSalesforceInput_3Process(SF_TO_CLARITY.java:25749)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tFixedFlowInput_4Process(SF_TO_CLARITY.java:16803)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tFileInputDelimited_1Process(SF_TO_CLARITY.java:15167)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tSalesforceGetServerTimestamp_1Process(SF_TO_CLARITY.java:13832)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tSalesforceConnection_3Process(SF_TO_CLARITY.java:12233)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tLoop_1Process(SF_TO_CLARITY.java:11893)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tJava_4Process(SF_TO_CLARITY.java:11259)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tFTPConnection_1Process(SF_TO_CLARITY.java:11091)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tJava_12Process(SF_TO_CLARITY.java:10853)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tJava_1Process(SF_TO_CLARITY.java:10685)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tFixedFlowInput_1Process(SF_TO_CLARITY.java:10433)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tJava_2Process(SF_TO_CLARITY.java:9913)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.tSetProxy_1Process(SF_TO_CLARITY.java:9702)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.runJobInTOS(SF_TO_CLARITY.java:64989)
at atos.sf_to_clarity_5_0.SF_TO_CLARITY.main(SF_TO_CLARITY.java:64618)
true
ERREUR : erreur technique : org.talend.components.api.exception.ComponentExceptionrg.talend.daikon.exception.error.DefaultErrorCode@324c64cd:{failedBatch=[BatchInfo id='75125000001W8MXAA0'
jobId='75025000001lIegAAE'
state='InProgress'
stateMessage='null'
createdDate='java.util.GregorianCalendar[time=1515565906000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2018,MONTH=0,WEEK_OF_YEAR=2,WEEK_OF_MONTH=2,DAY_OF_MONTH=10,DAY_OF_YEAR=10,DAY_OF_WEEK=4,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=6,HOUR_OF_DAY=6,MINUTE=31,SECOND=46,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'
systemModstamp='java.util.GregorianCalendar[time=1515565907000,areFieldsSet=true,areAllFieldsSet=true,lenient=true,zone=sun.util.calendar.ZoneInfo[id="GMT",offset=0,dstSavings=0,useDaylight=false,transitions=0,lastRule=null],firstDayOfWeek=1,minimalDaysInFirstWeek=1,ERA=1,YEAR=2018,MONTH=0,WEEK_OF_YEAR=2,WEEK_OF_MONTH=2,DAY_OF_MONTH=10,DAY_OF_YEAR=10,DAY_OF_WEEK=4,DAY_OF_WEEK_IN_MONTH=2,AM_PM=0,HOUR=6,HOUR_OF_DAY=6,MINUTE=31,SECOND=47,MILLISECOND=0,ZONE_OFFSET=0,DST_OFFSET=0]'
numberRecordsProcessed='0'
numberRecordsFailed='0'
totalProcessingTime='0'
apiActiveProcessingTime='0'
apexProcessingTime='0'
]
}

[Anonymous]

Hello,

Are you using tSalesforceInput component with "Bulk Query" to pull data from Salesforce? On which talend build version you got this issue? Would you mind posting your current job design and  tSalesforceInput component setting screenshots on forum? Please mask your sensitive data.

Best regards

Sabrina

[manodwhb · Accepted solution]

Yes, i am using tSalesforceInput with "Bulk Query" to pull data from Salesforce.Talend V6.4.0

[Anonymous]

Hello,

Would you mind posting your current job design and  tSalesforceInput component setting screenshots on forum?

Best regards

Sabrina

[manodwhb]

Please is the attachement

sc1.jpg

[Anonymous]

Hello,

It looks like this error is caused by a network problem and so far no communication with SalesForce has taken place.

Are you using a proxy or if some firewall rules prevents TCP traffic to SalesForce from your side? Can you ping your salesforce server successfully?

Have you tried to increase the TimeOut on the Salesforce connection to see if it helps?

Best regards

Sabrina

[manodwhb]

Yes,i am able to ping to SalesForce serever.

[TRF]

Hi,

Based on the attachment, it seems there is a right parenthesis for the condition but not the left one (or maybe the condition is truncated on the capture).

Else, are you shure the custom fields Opportunity_Status__c and Opprtunity_Close_Date__c are part of the OpportunityLineItem object?

[manodwhb]

Yes,while capturing the screenshot that condition has truncated.

And Yes ,custom fields Opportunity_Status__c and Opprtunity_Close_Date__c are part of the OpportunityLineItem object.

[TRF]

As you got the job Id on the error message, you should be able to retrieve the job on Salesforce side (Setup > Jobs > Bulk Data Load Jobs).

Here you could get the query as it arrives to Salesforce and/or the error on Salesforce side.