Exception while reading excel file using tflowtoiterate
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
The first subjob opens a connection to Salesforce(tSalesforceConnection). Please use connector onsubjobok between your tSalesforceConnection and tSalesforceInput component instead of iterate link.
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]}' ] ]
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)
