Connection error while fetching data from Eloqua in mule

Question

Sometimes i'm getting below error while connecting to Eloqua system using HTTP component. Sometime it is fetching data from Eloqua properly but in rare cases getting the below error.

20:31:11.474     08/18/2017     Worker-0     [elq-sfdc-batch-interface-v1].ma-sfdc-ma-batch-interfaceFlow.stage1.29     ERROR
Remote host closed connection. Possible SSL/TLS handshake issue. Check protocols, cipher suites and certificate set up. Use -Djavax.net.debug=handshake for further debugging.
20:31:11.477     08/18/2017     Worker-0     [elq-sfdc-batch-interface-v1].ma-sfdc-ma-batch-interfaceFlow.stage1.29     ERROR
******************************************************************************** Message : Error sending HTTP request. Element : /ma-sfdc-ma-batch-interfaceFlow/processors/18/get-ma-exported-data/subprocessors/0 @ elq-sfdc-batch-interface-v1:ma-sfdc-marketing-activities-create-export.xml:74 (Get All Exported Data) -------------------------------------------------------------------------------- Exception stack is: Error sending HTTP request. (org.mule.api.MessagingException) (set debug level logging or '-Dmule.verbose.exceptions=true' for everything) ********************************************************************************

This is how HTTP component is configured

<http:request-config name="Eloqua_BULK_API" protocol="HTTPS" host="${eloqua.host}" port="${eloqua.port}" basePath="/API/BULK/2.0" connectionIdleTimeout="1200000" responseTimeout="1200000" doc:name="HTTP Request Configuration">
    <http:basic-authentication username="${eloqua.username}" password="${eloqua.password}" preemptive="true"/>
</http:request-config>

<http:request config-ref="Eloqua_BULK_API" path="#[flowVars.'uri-export-data-contact']" method="GET" doc:name="Get All Exported Data">
    <http:request-builder>
        <http:query-param paramName="limit" value="${eloqua.record.limit.activities}"/>
        <http:query-param paramName="offset" value="#[sessionVars.offset]"/>
    </http:request-builder>
</http:request>

Similar kind of exception i got while connect to salesforce, in salesforce there is connect anytime option is there which i enabled. Is there same option in HTTP component ?

score 0 · Answer 1 · answered Aug 21 '17 at 09:34

I found the solution, it works with until successful, below is the code

<until-successful maxRetries="20" millisBetweenRetries="40000" synchronous="true" doc:name="Until Successful">
    <processor-chain doc:name="Processor Chain">
        <http:request config-ref="Eloqua_BULK_API" path="#[flowVars.'uri-export-data-contact']" method="GET" doc:name="Get All Exported Data">
            <http:request-builder>
                <http:query-param paramName="limit" value="${eloqua.record.limit.activities}"/>
                <http:query-param paramName="offset" value="#[sessionVars.offset]"/>
            </http:request-builder>
        </http:request>
    </processor-chain>
</until-successful>

Connection error while fetching data from Eloqua in mule

1 Answers1