Getting The Remote Server Returned an (500) Internal Error

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: 19
Joined: Tue 22 Nov 2016 16:21

Getting The Remote Server Returned an (500) Internal Error

Post by malchim » Tue 19 Sep 2017 17:10

This pulls around 50,000 rows and then throws this error. Not sure what the problem would be or where to start.

"Lists Members:Error: Devart.Data.MailChimp.MailChimpException (0x80004005): The remote server returned an error: (500) Internal Server Error.
at Devart.Data.fa.InvokeApiCall[T](Boolean authorizedCall, Func`1 call)
at Devart.Data.MailChimp.cb.a(String A_0, String A_1, Stream A_2)
at Devart.Data.MailChimp.cb.c(a A_0, bw A_1)
at Devart.Data.e7.a()
at Devart.Data.fl.a()
at Devart.SSIS.SourceComponent.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostPrimeOutput(IDTSManagedComponentWrapper100 wrapper, Int32 outputs, Int32[] outputIDs, IDTSBuffer100[] buffers, IntPtr ppBufferWirePacket)"

Devart Team
Posts: 2105
Joined: Wed 02 Nov 2011 09:44

Re: Getting The Remote Server Returned an (500) Internal Error

Post by Pinturiccio » Thu 21 Sep 2017 16:23

Try increasing the 'Default Command Timeout' value in your MailChimp connection. It can be done on the Advanced tab of the connection editor.

Post Reply