connection error Magento SSIS

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
ccamilla@magens.cl
Posts: 2
Joined: Thu 27 Jun 2019 15:35

connection error Magento SSIS

Post by ccamilla@magens.cl » Thu 27 Jun 2019 15:49

I am consulting the products through SSIS but when starting the task it fails and delivers the error:

[Devart Magento Source [2]] Error: Devart.Data.Magento.MagentoException (0x80004005): Anulada la solicitud: No se puede crear un canal seguro SSL/TLS.
---> Devart.Data.Magento.MagentoException (0x80004005): Anulada la solicitud: No se puede crear un canal seguro SSL/TLS. ---> System.Net.WebException: Anulada la solicitud: No se puede crear un canal seguro SSL/TLS.
en System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
en System.Net.HttpWebRequest.GetRequestStream()
en Devart.Data.Rest.c.hg(String A_0, String A_1, Stream A_2, String A_3, Dictionary`2 A_4, h A_5, Nullable`1 A_6, Nullable`1 A_7, Nullable`1 A_8, String A_9)
en Devart.Data.bb.a[a](Boolean A_0, Int32 A_1, Func`1 A_2)
en Devart.Data.bb.i()
en Devart.Data.bb.i()
en Devart.Data.bx.b()
en Devart.Data.ca.bo4(b A_0, Object A_1, f A_2)
en Devart.Common.Devart.Data.SqlShim1319268.w.a(v A_0, b A_1, f A_2)
en Devart.Common.Devart.Data.SqlShim1319268.v.a(f A_0)
en Devart.Common.Devart.Data.SqlShim1319268.v.b(f A_0)
en Devart.Common.Devart.Data.SqlShim1319268.w.c(f A_0)
en Devart.Common.Devart.Data.SqlShim1319268.y.bqy(f A_0)
en Devart.Common.Devart.Data.SqlShim1319268.f.Open()
en Devart.Data.Magento.c.Open()
en Devart.SSIS.SqlShim.CommonConnectionManager.AcquireConnection(Object txn)
en Microsoft.SqlServer.Dts.Runtime.ManagedWrapper.AcquireConnection(Object txn)
en Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
en Devart.SSIS.SqlShim.BaseComponent.AcquireConnections(Object transaction)
en Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)

thanks for your help!

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: connection error Magento SSIS

Post by Pinturiccio » Mon 01 Jul 2019 16:16

Looks like your Magneto server requires TLS 1.1 or higher. There are 2 ways to force using TLS 1.1 or higher.
I. Add a specific code inside SSIS Data Flow Components for Magento. We will investigate the possibility to force using TLS 1.1 or higher in SSIS Data Flow Components for Magento and post here when we get the results.

II. Add two keys to the registry. After these changes you can use the current version of SSIS Data Flow Components for Magento.
1. Click "Win key + R" and enter regedit. Click Ok: http://prntscr.com/k4onxy
2. Copy and paste "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319" (without quotes) to the path panel and press Enter. http://prntscr.com/k4oow0
3. Right Click the right panel and select New->DWORD (32-bit) Value. http://prntscr.com/k4oqzy
4. Name it SchUseStrongCrypto. http://prntscr.com/k4orkr
5. Double-click this new parameter, set its value to 1, and click Ok. http://prntscr.com/k4osvw
6. Repeat steps 2-5 with the following path on the step 2:"HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319" (without quotes).
7. Restart SQL Server Data Tools.

Is the issue fixed after this?

ccamilla@magens.cl
Posts: 2
Joined: Thu 27 Jun 2019 15:35

Re: connection error Magento SSIS

Post by ccamilla@magens.cl » Mon 01 Jul 2019 18:51

I work perfect only with step two .... thank you very much!

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: connection error Magento SSIS

Post by Pinturiccio » Thu 04 Jul 2019 13:48

Please note, that the second way affects all .NET applications. We added the needed code to SSIS Data Flow Components for Magento. The next public build will works even without adding described entries to the registry.

New build of Devart SSIS Data Flow Components 1.10.979 is available for download now!
It can be downloaded from https://www.devart.com/ssis/download.html or from Devart Account (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=38984

Post Reply