SSIS Unexpexcted termination when running multiple packages in parallel

An escalating problem at a customer site is a problem with SSIS when running multiple SSIS packages in parallel.
We get the following error on intermittent occasions, sometimes after just a couple of minutes, sometimes after 2-3 hours of running.

We have applied the latest SQL 2012 CU3 patch and also a hotfix from Microsoft http://support.microsoft.com/kb/2837964/en-us?sd=rss&spid=1044
But the problem persists. We get the following error in the Windows application log:

Faulting application name: ISServerExec.exe, version: 11.0.3349.0, time stamp: 0x513a9017
Faulting module name: ntdll.dll, version: 6.1.7601.17725, time stamp: 0x4ec4aa8e
Exception code: 0xc0000374
Fault offset: 0x00000000000c40f2
Faulting process id: 0x1fe0
Faulting application start time: 0x01ce4ffb609c5176
Faulting application path: C:\Program Files\Microsoft SQL Server\110\DTS\Binn\ISServerExec.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: 6b101cc8-bc06-11e2-8a88-e41f13b85634

Yesterday we finally found a blog post where someone had gotten rid of this problem by adding the SQL agent account to the local admin group on
the server. They where not able to figure out what permission exactly was missing. In our case and on the first server where I tried this,
the same account was used for both the SQL engine and the agent. It’s not good practice to give the sql account local admin permissions but in
this case it’s the only solution I have found that seems to be working.

And guess what, it seems to have worked !!!

At least last night…. But this error is very intermittent and I will let it run for at least a week
before I consider this a working solution.

We will eagerly be awaiting Cumulative Update 4 which is due to be released this week and that might include a fix for this.

I’ll continue to work on the permission clue and see if something more can be found and the I will update this post

Update 2013-05-24

Giving the SQL services accounts local admin permission didn’t help…
Applied a bunch of Windows .Net patches yesterday. See if that helps.

Advertisements

4 thoughts on “SSIS Unexpexcted termination when running multiple packages in parallel

  1. Loïs

    Hello,

    I have the same problem, at first it looks like this : http://support.microsoft.com/kb/2837964/en-us?sd=rss&spid=1044

    But my error message is quite diferent :

    Faulting application name: ISServerExec.exe, version: 11.0.3000.0, time stamp: 0x5081b8ff
    Faulting module name: ntdll.dll, version: 6.2.9200.16912, time stamp: 0x536464ba
    Exception code: 0xc0000374
    Fault offset: 0x00000000000e9d19
    Faulting process id: 0x1508
    Faulting application start time: 0x01cffe9acbc5edd0
    Faulting application path: C:\Program Files\Microsoft SQL Server\110\DTS\Binn\ISServerExec.exe
    Faulting module path: C:\windows\SYSTEM32\ntdll.dll
    Report Id: 16fc44e2-6aa0-11e4-9409-005056941c5d
    Faulting package full name:
    Faulting package-relative application ID:

    Did you manage to resolve this bug ?

    Reply
      1. Loïs

        Hi,

        We have SQL Server 2012 SP1 :
        Microsoft SQL Server Management Studio –> 11.0.3153.0
        Microsoft Analysis Services Client Tools–> 11.0.3130.0
        Microsoft Data Access Components (MDAC) –> 6.2.9200.16384
        Microsoft MSXML –> 3.0 6.0
        Microsoft Internet Explorer –> 9.10.9200.17054
        Microsoft .NET Framework –> 4.0.30319.18449
        Operating System –> 6.2.9200

        I’ll try to install the lastet CU, thanks.

        Loïs

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s