June 19, 2013 at 9:36 am
We have a job that gets data off a website and imports into SQL. It runs for a couple hours, then fails with the following message. Not very helpful.
".. This error occurs when the server is experiencing problems..."
Any thoughts, or am I missing something ? (not the first time)
Microsoft (R) SQL Server Execute Package Utility
Version 10.0.2520.0 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
NULL
Started: 07:00:42
Error: 2013-06-19 09:36:35.18
Code: 0xC001600E
Source: MRIFeed Connection manager "Job"
Description: Server returned status code - 500 : Internal Server Error. This error occurs when the server is experiencing problems.
End Error
Error: 2013-06-19 09:36:35.23
Code: 0x00000001
Source: Download job XML
Description: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: Server returned status code - 500 : Internal Server Error. This error occurs w
hen the server is experiencing problems.
---> System.Runtime.InteropServices.COMException (0xC001600E): Server returned status code - 500 : Internal Server Error. This error occurs when the server is experiencing problems.
NULL
at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSHttpClientConnection100.DownloadData()
at Microsoft.SqlServer.Dts.Runtime.HttpClientConnection.DownloadData()
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Dts.Runtime.HttpClientConnection.DownloadData()
at ST_986b2264c6724ec5b4336f7799acb425.vbproj.ScriptMain.Main()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args, CultureInfo culture)
at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 07:00:42
Finished: 09:36:35
Elapsed: 9352.84 seconds
NULL
June 20, 2013 at 3:49 am
If you are running IIS7 try switching on failed request logging, it should help track down where the problem is occuring.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply