IMPORTANT ANNOUNCEMENT: On May 6, 2024, Carbon Black User eXchange (UeX) and Case Management will move to a new platform!
The Community will be in read-only mode starting April 19th, 7:00 AM PDT. Check out the blog post!
You will still be able to use the case portal to create and interact with your support cases until the transition, view more information here!

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:
648
Contributors