Exception in tSalesforceInput component

Twelve Stars

Exception in tSalesforceInput component

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.ComponentExceptionSmiley Surprisedrg.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'
]
}

Manohar B

Accepted Solutions
Twelve Stars

Re: Exception in tSalesforceInput component

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

Re: Exception in tSalesforceInput component

Please is the attachement

Manohar B
Twelve Stars

Re: Exception in tSalesforceInput component

Yes,i am able to ping to SalesForce serever.

Manohar B
Twelve Stars

Re: Exception in tSalesforceInput component

In Salsaforce side that id is still showing under the in progress bacth,where the all records are featched.


TRF wrote:
Next step, retrieve the job and the request or error message on Salesforce side

 

Manohar B

All Replies
Moderator

Re: Exception in tSalesforceInput component

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Twelve Stars

Re: Exception in tSalesforceInput component

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

Re: Exception in tSalesforceInput component

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Twelve Stars

Re: Exception in tSalesforceInput component

Please is the attachement

Manohar B
Moderator

Re: Exception in tSalesforceInput component

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Twelve Stars

Re: Exception in tSalesforceInput component

Yes,i am able to ping to SalesForce serever.

Manohar B
Forteen Stars TRF
Forteen Stars

Re: Exception in tSalesforceInput component

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?


TRF
Twelve Stars

Re: Exception in tSalesforceInput component

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.

Manohar B
Forteen Stars TRF
Forteen Stars

Re: Exception in tSalesforceInput component

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.


TRF
Twelve Stars

Re: Exception in tSalesforceInput component

Yes I got job ID.

Manohar B
Forteen Stars TRF
Forteen Stars

Re: Exception in tSalesforceInput component

Next step, retrieve the job and the request or error message on Salesforce side

TRF
Twelve Stars

Re: Exception in tSalesforceInput component

In Salsaforce side that id is still showing under the in progress bacth,where the all records are featched.


TRF wrote:
Next step, retrieve the job and the request or error message on Salesforce side

 

Manohar B