Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
manodwhb
Champion II
Champion II

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.ComponentException0683p000009MA5A.pngrg.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'
]
}

Labels (4)
12 Replies
manodwhb
Champion II
Champion II
Author

Yes I got job ID.

TRF
Champion II
Champion II

Next step, retrieve the job and the request or error message on Salesforce side
manodwhb
Champion II
Champion II
Author

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