Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

Database task SQL exception: FlushTranLog - Invalid column name 'delayed_durability_desc'

Database task SQL exception: FlushTranLog - Invalid column name 'delayed_durability_desc'

Version
7.2.1+

Topic
The following exception is seen in the database:

Database task SQL exception: FlushTranLog - Invalid column name 'delayed_durability_desc'

Cause

The database task that is being called on is not supported with versions of SQL Server before 2014. This error is generally seen with the Express editions of SQL

Steps

  1. Open SQL Server Management Studio
  2. Expand Databases > das > Programmability > Stored Procedures
  3. Right Click on dbo.FlushTransLog and select "MODIFY"
  4. Look for the line | IF SERVERPROPERTY('productversion')>'12'
  5. Modify this property to | IF SERVERPROPERTY('productversion')='12'
  6. To save the stored procedure, Execute

Important Note(s)

Do not modify any other stored procedures or any part of the queries found in this stored procedure without prior consent from support or engineering. Any modifications outside this solution can have unexpected affects to the database.

Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎09-18-2017
Views:
549
Contributors