topic Re: Exception while reading excel file using tflowtoiterate in Talend Studio

Exception while reading excel file using tflowtoiterate

Anonymous — Sat, 16 Nov 2024 07:40:29 GMT

I have queried using t sales force input and returned those records in excel file. then i tried to read that excel file row by row by map variable and i have queried again in sub module using this map variable with help of t Flow To Iterate...i got out put for some records..then i got one exception..please find attachments.

Exception in component tSalesforceInput_2 (ExtractMetadata)
java.io.IOException: [UnexpectedErrorFault [ApiFault exceptionCode='UNKNOWN_EXCEPTION'
exceptionMessage='An unexpected error occurred. Please include this ErrorId if you contact support: 732935761-26155 (-532095358)'
extendedErrorDetails='{[0]}'
]
]

at org.talend.components.salesforce.runtime.SalesforceInputReader.start(SalesforceInputReader.java:118)
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
at local_project.extractmetadata_0_1.ExtractMetadata.tSalesforceConnection_1Process(ExtractMetadata.java:6200)
at local_project.extractmetadata_0_1.ExtractMetadata.runJobInTOS(ExtractMetadata.java:7394)
at local_project.extractmetadata_0_1.ExtractMetadata.main(ExtractMetadata.java:7243)
Caused by: [UnexpectedErrorFault [ApiFault exceptionCode='UNKNOWN_EXCEPTION'
exceptionMessage='An unexpected error occurred. Please include this ErrorId if you contact support: 732935761-26155 (-532095358)'
extendedErrorDetails='{[0]}'
]
]

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at java.lang.Class.newInstance(Unknown Source)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:673)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:556)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:236)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:210)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:156)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
at com.sforce.soap.partner.PartnerConnection.query(PartnerConnection.java:1155)
at org.talend.components.salesforce.runtime.SalesforceInputReader.executeSalesforceQuery(SalesforceInputReader.java:163)
at org.talend.components.salesforce.runtime.SalesforceInputReader.start(SalesforceInputReader.java:105)
... 4 more

Re: Exception while reading excel file using tflowtoiterate

Anonymous — Wed, 12 Sep 2018 08:59:26 GMT

Hello,

The first subjob opens a connection to Salesforce(tSalesforceConnection). Please use connector onsubjobok between your tSalesforceConnection and tSalesforceInput component instead of iterate link.

Best regards

Sabrina

Re: Exception while reading excel file using tflowtoiterate

Anonymous — Wed, 12 Sep 2018 09:04:13 GMT

I have tried that also....still getting same error

Exception in component tSalesforceInput_2 (ExtractMetadata)
java.io.IOException: [UnexpectedErrorFault [ApiFault exceptionCode='UNKNOWN_EXCEPTION'
exceptionMessage='An unexpected error occurred. Please include this ErrorId if you contact support: 568988799-34113 (-532095358)'
extendedErrorDetails='{[0]}'
]
]

at org.talend.components.salesforce.runtime.SalesforceInputReader.start(SalesforceInputReader.java:118)
at org.talend.codegen.flowvariables.runtime.FlowVariablesReader.start(FlowVariablesReader.java:73)
at local_project.extractmetadata_0_1.ExtractMetadata.tSalesforceInput_1Process(ExtractMetadata.java:6268)
at local_project.extractmetadata_0_1.ExtractMetadata.runJobInTOS(ExtractMetadata.java:7433)
at local_project.extractmetadata_0_1.ExtractMetadata.main(ExtractMetadata.java:7282)
Caused by: [UnexpectedErrorFault [ApiFault exceptionCode='UNKNOWN_EXCEPTION'
exceptionMessage='An unexpected error occurred. Please include this ErrorId if you contact support: 568988799-34113 (-532095358)'
extendedErrorDetails='{[0]}'
]
]

Re: Exception while reading excel file using tflowtoiterate

Anonymous — Wed, 12 Sep 2018 09:12:23 GMT

Hello,

Are you able to get your data successfully from salesforce by tsalesforceconnection-->tsalesforceinput(entityDefinition)-->tfileoutputexcel?

Could you please also post your tSalesforceInput_2 (ExtractMetadata) component setting screenshot on forum?

Best regards

Sabrina