Sample Header Ad - 728x90

What are the possible causes for an SSIS package execution having an "ended unexpectedly" status

3 votes
0 answers
1218 views
I have a SQL Agent job that runs an SSIS 2012 package every 30 seconds to export a small amount of data to a CSV file. There is often nothing to export, but when there is, the business wants it done ASAP. This has been running fine for months without error, but over the weekend it had 3 failures: Start Time: 7/25/2015, 11:43:13 PM, End Time: 7/25/2015 11:44:36 PM, Status: Ended Unexpectedly Start Time: 7/25/2015, 11:52:05 PM, End Time: 7/25/2015 11:53:13 PM, Status: Ended Unexpectedly Start Time: 7/26/2015, 5:01:31 PM, End Time: 7/25/2015 5:01:31 PM, Status: Failed In each case, there were no records in internal.operation_messages for the operation_id. The All Executions report also showed no Messages and no entries under Execution Overview. Normal durations for this package are in the 4 - 26 second range. So the **Ended Unexpectedly** executions had unusually long durations. The **Failure** execution had a duration of zero. There are no maintenance jobs of any kind running at the time of these failures. I found this in the Application Event Log that correlates to the time of the Failed execution: > The operation 414582 (GUID:82f992bf-ed2a-4d82-b25d-92a9d3052cd9) > terminated because the AppDomain 488 is unloaded. Try restarting the > execution. I don't know what this means. I found instances of this message that correlate to the "ended unexpectedly" executions: > The SSIS Execution Process could not write to the IS catalog: > MyInstance:SSISDB Error details: Timeout expired. The timeout period > elapsed prior to completion of the operation or the server is not > responding What are some possible causes for these?
Asked by Mark Freeman (2293 rep)
Jul 27, 2015, 03:33 PM
Last activity: Mar 31, 2024, 05:30 AM