Skip to main content

Error: 'Cannot continue the execution because the session is in the kill state'

What to do if you see a 'Cannot continue the execution because the session is in the kill state' error when importing data.

Written by Arthur Ashdown

This error occurs during a data import when the SQL Server database instance is running on an unsupported version. Your IT team will need to upgrade the SQL Server instance to resolve it.

You may see this error in one of the following forms:

Orchestrate data flow import has failed. The detailed information is as follows:  
Cannot continue the execution because the session is in the kill state.
A severe error occurred on the current command. The results, if any, should be discarded.
Import command: EXEC [wf].[pr_Merge_orc_Customers]

or:

Orchestrate data flow import has failed. 
The detailed information is as follows: Cannot continue the execution because the session is in the kill state.
A severe error occurred on the current command. The results, if any, should be discarded.
Import command: EXEC [wf].[pr_Merge_orc_Orders]

Resolution

To resolve this error, your IT team will need to upgrade the SQL Server database instance and ensure Windows cumulative updates are applied.

  1. Upgrade the SQL Server database instance to version 15.0.4043.16 (SQL Server 2019) or above.

  2. Install any outstanding Windows cumulative updates (CUs).

📌Note: These changes will need to be carried out by your IT team or database administrator. If you need further assistance, please contact our support team.

Did this answer your question?