none
A user request from the session with SPID 61 generated a fatal exception. SQL Server is terminating this session.

    Question

  • Hi,

    When i call a different package from .net i get the following error in event viewer:
    A user request from the session with SPID 61 generated a fatal exception. SQL Server is terminating this session.

    What does that mean?

    Thanks
    Tuesday, November 24, 2009 5:58 PM

All replies

  • Are you trying to run packages from a SQL CLR routine?
    John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com
    Tuesday, November 24, 2009 6:38 PM
    Moderator
  • Hi,

    This is the code that runs the package:
    package = app.LoadPackage(@"c:\ImportDDPLPkg.dtsx", null);
     Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();

    In eventviewer i see :
    Event Type: Information
    Event Source: SQLISPackage
    Event Category: None
    Event ID: 12289
    Date:  11/25/2009
    Time:  2:18:25 PM
    User:  NT AUTHORITY\NETWORK SERVICE
    Computer: DEV
    Description:
    Package "ImportDDPLPkg" finished successfully

    __________________________________________________
    Event Type: Error
    Event Source: MSSQLSERVER
    Event Category: (2)
    Event ID: 17310
    Date:  11/25/2009
    Time:  2:18:25 PM
    User:  N/A
    Computer: DEV
    Description:
    A user request from the session with SPID 62 generated a fatal exception.
    SQL Server is terminating this session.

     

    Wednesday, November 25, 2009 12:34 PM
  • Once again, is this being done from a SQL CLR function, or from a standalone .NET application? Have you enabled logging on the package to see if there are any errors reported? Since the event log indicates that the package finish successfully, have you validated whether it completes its work?
    John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com
    Wednesday, November 25, 2009 4:30 PM
    Moderator
  • From a standalone .net application. I enabled logging for the package but don't get much information:
    #Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message
    PackageStart,DEV,NT AUTHORITY\NETWORK SERVICE,ImportDDPLPkg,{FC5-C433-423A-8D0A-EAD881CB911E},{6B1D9507-1F8E-461D-9DEC-90242BA8EE0E},11/25/2009
    7:16:26 PM,11/25/2009 7:16:26 PM,0,0x,Beginning of package execution.

    PackageEnd,DEV,NT AUTHORITY\NETWORK SERVICE,ImportDDPLPkg,{FC5-C433-423A-8D0A-EAD881CB911E},{6B1D9507-1F8E-461D-9DEC-90242BA8EE0E},11/25/2009
    7:16:28 PM,11/25/2009 7:16:28 PM,0,0x,End of package execution.

    But in eventviewer I still get the messages in my first post
    What on earth is the problem? :-(

    Thanks

    Wednesday, November 25, 2009 5:20 PM
  • It appears that the package is completing successfully. Did the package do what it was supposed to? Are you sure the error is connected to running the package?


    John Welch | www.mariner-usa.com | www.agilebi.com | ssisUnit.codeplex.com
    Wednesday, November 25, 2009 5:36 PM
    Moderator
  • Hi,

    The package didn't do what's supposed to do. It created the temp table only but didn't import the file.
    When i opened the excel it says that macro was disabled coz of security. When i copied the contents of the excel to another excel the package imported the data.
    What could be the problem? I need to work with the original file as that is the file users will try to upload.

    BTW: The error i think is related to running the package coz it only appears after the package is run.

    Thanks
    Wednesday, November 25, 2009 10:09 PM