Issue on SSIS Devart Salesforce - Execution

[Gaetan]

Hello,

I have a recurrent issue when i execute an Data Flow Task using the Devart Plugin Salesforce (for 64-bit)

Error: 2014-11-28 14:46:44.78
Code: 0x00000000
Source: Data Flow Task CampaignMember (SALESFORCE)
Description:

The request channel timed out while waiting for a reply after 00:00:59.8173828.

Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding.
The time allotted to this operation may have been a portion of a longer timeout.
End Error

Error: 2014-11-28 14:46:44.80
Code: 0xC0047062
Source: Data Flow Task CampaignMember (SALESFORCE) [1]

Description: System.TimeoutException: The request channel timed out while waiting for a reply after 00:00:59.8173828.
Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding.
The time allotted to this operation may have been a portion of a longer timeout.

---> System.TimeoutException: The HTTP request to 'https://eu1.salesforce.com/services/Soa ... 000000ope2' has exceeded the allotted timeout of 00:01:00.
The time allotted to this operation may have been a portion of a longer timeout.
---> System.Net.WebException: The operation has timed out
at System.Net.HttpWebRequest.GetResponse()
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
--- End of inner exception stack trace ---
at System.ServiceModel.Channels.HttpChannelUtilities.ProcessGetResponseWebException(WebException webException, HttpWebRequest request, HttpAbortReason abortReason)
at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
--- End of inner exception stack trace ---

Server stack trace:
at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Dispatcher.RequestChannelBinder.Request(Message message, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]:
at Devart.SSIS.Salesforce.SalesforceSource.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)
End Error

Error: 2014-11-28 14:46:44.81
Code: 0xC0047038
Source: Data Flow Task SSIS.Pipeline
Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.
The PrimeOutput method on component "CampaignMember (SALESFORCE)" (1) returned error code 0x80131505.
The component returned a failure code when the pipeline engine called PrimeOutput().
The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
There may be error messages posted before this with more information about the failure.
End Error

DTExec: The package execution returned DTSER_FAILURE (1). Started: 2:45:38 PM Finished: 2:46:44 PM Elapsed: 66.047 seconds.
The package execution failed. The step failed.

I have increase the timeout and set the parameter "ValidateExternalMetadata" to false but it's not working

Could you help me?

[Gaetan]

when i call again this task, it's working. I don't understand the reason for what it always failed the first time i call this task

[Shalex]

System.TimeoutException: The HTTP request to 'https://eu1.salesforce.com/services/Soa ... 000000ope2' has exceeded the allotted timeout of 00:01:00.
The time allotted to this operation may have been a portion of a longer timeout.

00:01:00 (60 seconds) is a default value of the Connection Timeout connection string option. Please set a greater value in this parameter via Advanced tab of Devart Salesforce Connection Manager Editor.

[Gaetan]

The problem is when i set a greater value in this parameter and i import the package SSIS in integration services, its seems that the change of this value is not taken into consideration.
if i make a export of this package to SSIS, the value of this parameter is reset to the default value (60 seconds)

[Shalex]

Please give us an additional information:

1) are you using Devart Salesforce Connection Manager (Connection Managers > New Connection > DevartSalesforce) or standard Connection Manager (Connection Managers > New ADO.NET Connection) with the Devart Salesforce Source component?

2) save your *.dtsx package, then open it with XML Editor and make sure that connection string includes "Connection Timeout=your_value;"

3) specify your_value used

4) these are different ways of executing SSIS package: http://www.mssqltips.com/sqlservertip/1 ... s-package/. Tell us the exact steps we should follow to reproduce the behaviour when:
a) non-default Connection Timeout value is ignored
b) Connection Timeout is reset to its default value

[Gaetan]

i'm using the standard Connection Manager (Connection Managers > New ADO.NET Connection)

Actually, when i open my package with XML Editor, i have this :
<DTS:Property DTS:Name="CreationName">DevartSalesforce</DTS:Property>
<DTS:ObjectData>
<SalesforceConnectionManager>
<ConnectionString>User Id=[email protected];Host=XXX;System Objects=True</ConnectionString>
</SalesforceConnectionManager>
</DTS:ObjectData>
</DTS:ConnectionManager>

So i change the value via Advanced tab of Devart Salesforce Connection Manager Editor
and i re-open my package with XML Editor, now i have this :

<DTS:Property DTS:Name="CreationName">DevartSalesforce</DTS:Property>
<DTS:ObjectData>
<SalesforceConnectionManager>
<ConnectionString>User Id=[email protected];Host=XXX;Connection Timeout=300;System Objects=True</ConnectionString>
</SalesforceConnectionManager>
</DTS:ObjectData>

I execute SSIS package via command line:

dtexec /DTS "\MSDB\ODS\SALESFORCE\Lead_AssureConjoint" /SERVER XX-XXX /CONFIGFILE "D:\SSIS_Config\DM.dtsConfig" /CONFIGFILE "D:\SSIS_Config\SALESFORCE.dtsConfig" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
</DTS:ConnectionManager>

Could i add this parameter in "SALESFORCE.dtsConfig"?
>Yes

<Configuration ConfiguredType="Property" Path="\Package.Connections[SALESFORCE].Properties[ConnectionString]" ValueType="String">
<ConfiguredValue>User Id=[email protected];Host=XXXX;System Objects=True;Connection Timeout=300</ConfiguredValue>
</Configuration>

Now it work fine