FIX: Error when you run RBS Maintainer in SQL Server 2012 or SQL Server 2014

Symptoms

Assume that you are using Microsoft SQL Server 2012 or SQL Server 2014. When you run Remote BLOB Storage (RBS) Maintainer, the RBS Maintainer tool fails, and you receive the following error message:

When you use Profiler to trace the problem, you receive the following error message:

Cause

This problem occurs because a query that checks the time since the last execution can overflow when it converts a value to milliseconds. This causes the query to fail and the task to end without processing the data.

Resolution

The fix for this problem is available in latest feature pack download for RBS.msi. If you already have an existing installation of RBS, we recommend that you run the script that is provided in the "Workaround" section to temporarily fix the issue.

Download the Microsoft SQL Server 2014 Service Pack 2 (SP2) Feature Pack

Download the Microsoft SQL Server 2012 Service Pack 4 (SP4) Feature Pack

Workaround

If you have an existing installation of RBS on SQL Server 2012 or SQL Server 2014 that does not have the fix installed, you can use the following workaround steps:

1. In SSMS, open the script from step 3, and then connect to the SQL Server instance that hosts the RBS client database that you want to apply the fix to.

2. In the script, replace the “your_RBS_client_database” string with the actual name of the RBS client database.

3. Run the script to apply the fix.
   
   use [your_RBS_client_database]
   go
   
   
   if object_id(N'mssqlrbs_resources.rbs_sp_count') is not null
   drop procedure mssqlrbs_resources.rbs_sp_count
   go
   
   
   create procedure mssqlrbs_resources.rbs_sp_count (
   @operation smallint,
   @object smallint = 0,
   @value bigint = null,
   @start_time datetime = null,
   @end_time datetime = null,
   @description sysname = N'',
   @message nvarchar(max) = null
   )
   as
   begin
   
   declare @type tinyint,
   @secondsUsed bit,
   @seconds float
   
   declare @maxDays int = 10;
   
   
   if not exists (
   select * from mssqlrbs_resources.rbs_internal_counters
   where operation = @operation and object = @object and description = @description
   )
   raiserror (N'Internal error in RBS. Attempt to count invalid performance counter. Counter: <%d>.<%d>.<%s>.',
   16, 101, @operation, @object, @description)
   
   select
   @type = type,
   @secondsUsed = seconds_used
   from
   mssqlrbs_resources.rbs_internal_counters
   where
   operation = @operation and
   object = @object and
   description = @description
   
   if @object != 0
   begin
   if @value is null
   raiserror (N'Internal error in RBS. Value not specified for performance counter <%d>.<%d>.<%s>.',
   16, 103, @operation, @object, @description)
   end
   
   if @secondsUsed = 1
   begin
   if (@start_time is null)
   raiserror (N'Internal error in RBS. Start time not specified for performance counter <%d>.<%d>.<%s>.',
   16, 102, @operation, @object, @description)
   
   set @end_time = isnull(@end_time, getutcdate())
   
   if (@start_time > @end_time)
   raiserror (N'Internal error in RBS. Start time is after end time. Counter: <%d>.<%d>.<%s>.',
   16, 104, @operation, @object, @description)
   
   if (datediff(day, @start_time, @end_time) >= @maxDays)
   begin
   set @seconds = convert(float, datediff(second, @start_time, @end_time))
   end
   else
   begin
   set @seconds = convert(float, datediff(millisecond, @start_time, @end_time)) / 1000
   end
   end
   
   
   update mssqlrbs_resources.rbs_internal_counters
   set
   count = count + 1,
   value = value + @value,
   squared_value = squared_value + square(@value),
   min_value = case
   when min_value is null then @value
   when (@value < min_value) then @value
   else min_value
   end,
   max_value = case
   when max_value is null then @value
   when (@value > max_value) then @value
   else max_value
   end,
   last_value = @value,
   seconds = seconds + @seconds,
   squared_seconds = squared_seconds + square(@seconds),
   min_seconds = case
   when min_seconds is null then @seconds
   when (@seconds < min_seconds) then @seconds
   else min_seconds
   end,
   max_seconds = case
   when max_seconds is null then @seconds
   when (@seconds > max_seconds) then @seconds
   else max_seconds
   end,
   last_seconds = @seconds,
   last_update_time = getutcdate(),
   last_message = @message
   where
   operation = @operation and
   object = @object and
   description = @description
   
   end
   go

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.