Getting The Remote Server Returned an (500) Internal Error

Getting The Remote Server Returned an (500) Internal Error

Postby 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.MailChimp.cr.d()
at Devart.Data.e7.a()
at Devart.Data.fl.a()
at Devart.Data.gb.e()
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)"
malchim
 
Posts: 19
Joined: Tue 22 Nov 2016 16:21

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

Postby 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.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44


Return to SSIS Data Flow Components