Underlying Connection was closed

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
Posts: 5
Joined: Thu 11 Mar 2021 21:16

Underlying Connection was closed

Post by rjdkey » Mon 21 Jun 2021 20:47

We started getting the error below when trying to run our SSIS packages. It's happening across all packages using the Devart BigQuery Destination. It was all working fine until this morning. We tried on a couple machines and get the same error. We are running the latest version of the SSIS components and have tried uninstalling and reinstalling everything. Any ideas on what we can try to resolve this?

SSIS package "C:\Development\SSISOpenPackage\SSISOpenPackage\TD_GCP_COPY.dtsx" starting.
Information: 0x4004300A at sd_dg_parameters, SSIS.Pipeline: Validation phase is beginning.
Error: 0xC0047062 at sd_dg_parameters, Devart BigQuery Destination [20]: Devart.Data.BigQuery.BigQueryException (0x80004005): The underlying connection was closed: An unexpected error occurred on a receive. ---> Devart.Data.BigQuery.BigQueryException (0x80004005): The underlying connection was closed: An unexpected error occurred on a receive.
at Devart.Data.t.a[a](Boolean A_0, Int32 A_1, Func`1 A_2)
at Devart.Data.t.bm3()
at Devart.Data.t.bm3()
at Devart.Data.z.a(v A_0)
at Devart.Data.w.bm5(k A_0, Object A_1, d A_2)
at Devart.Common.Devart.Data.SqlShim1293377.i.a(l A_0, k A_1, d A_2)
at Devart.Common.Devart.Data.SqlShim1293377.l.a(d A_0)
at Devart.Common.Devart.Data.SqlShim1293377.l.b(d A_0)
at Devart.Common.Devart.Data.SqlShim1293377.i.c(d A_0)
at Devart.Common.Devart.Data.SqlShim1293377.h.bni(d A_0)
at Devart.Common.Devart.Data.SqlShim1293377.d.Open()
at Devart.Data.BigQuery.y.Open()
at Devart.SSIS.SqlShim.CommonConnectionManager.AcquireConnection(Object txn)
at Microsoft.SqlServer.Dts.Runtime.ManagedWrapper.AcquireConnection(Object txn)
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction)
at Devart.SSIS.SqlShim.BaseComponent.AcquireConnections(Object transaction)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction)
Error: 0xC0047017 at sd_dg_parameters, SSIS.Pipeline: Devart BigQuery Destination failed validation and returned error code 0x80004005.
Error: 0xC004700C at sd_dg_parameters, SSIS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at sd_dg_parameters: There were errors during task validation.
SSIS package "C:\Development\SSISOpenPackage\SSISOpenPackage\TD_GCP_COPY.dtsx" finished: Failure.

Devart Team
Posts: 70
Joined: Fri 11 Dec 2020 10:27

Re: Underlying Connection was closed

Post by DmitryGm » Wed 23 Jun 2021 09:09

As I remember you already had a similar problem (viewtopic.php?t=46701) and the issue successfully resolved by changing some network settings (adding a proxy server and port).

The most likely reason is some network issues not related to the Devart provider. Check your network configuration or firewall settings.

Post Reply