none
SQL Server 2019 Issue - Cannot continue the execution because the session is in the kill state. RRS feed

  • السؤال

  • I am using OLE Automation Stored Procedure sp_OAGetProperty to get a property value of an OLE object 

    Code

    declare @fsobj int
    declare @fsfile int
    declare @size bigint
    declare @error int
    declare @path varchar(255)
    declare @tempfilepath varchar(512)

    set @fsobj = null

    SET @PATH = (SELECT TOP(1) [PATH] FROM DMS_PATH WHERE [TYPE] IN (3, 99) ORDER BY [TYPE] DESC)
    set @tempfilepath = @path + '\' + 'HCN_e71efb49b22b44fc98ad10aa751a0744.tmp'
    print @tempfilepath

    -- create file system object
    exec @error = sp_OACreate 'Scripting.FileSystemObject', @fsobj OUT;
    exec @error = sp_OAMethod @fsobj, 'GetFile', @fsfile OUT, @tempfilepath;
    exec @error =sp_OAGetProperty @fsfile, 'Size', @size OUT;

    --------------------------------------------------------------------------------------------------------

    Getting below error when "exec @error =sp_OAGetProperty @fsfile, 'Size', @size OUT;" is executed

    Msg 596, Level 21, State 1, Line 0
    Cannot continue the execution because the session is in the kill state.
    Msg 0, Level 20, State 0, Line 0
    A severe error occurred on the current command.  The results, if any, should be discarded.

    Same above code working fine in SQL-2008 and SQL-2012

    Further analysis 

    observed that it is working fine in SQL-2019 also if we change data type of @size variable from bigint to int

    Not sure why error is occurring with bigint data type in SQL Server Express-2019



    23/صفر/1441 04:10 ص

الإجابات

  • Hi Raj Kishor Singh,

    >> Not sure why error is occurring with bigint data type in SQL Server Express-2019

    SQL Server 2019 RC is preview software. It is not publicly supported for operations. Customers who are in the SQL Early Adopter Program, may have support to run SQL Server 2019 RC by special agreement, in consultation with Microsoft. SQL Server 2019 (15.x) RC is available only as Evaluation Edition. No other editions are available. Please refer to SQL Server 2019 preview release notes

    If the issue only occurred in SQL server 2019, I  recommend you to submit your issue to the Microsoft feedback at this link https://feedback.azure.com/forums/908035-sql-server . This site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • تم وضع علامة كإجابة بواسطة Raj Kishor Singh 24/صفر/1441 09:35 ص
    24/صفر/1441 07:50 ص