Solution - Responder - Error 'First_Value' is not a recognized built-in function name.

Version 1

    Behavior

     

    The following error is thrown when attempting to upgrade to Responder 10.2.1c and running the provided SQL server upgrade scripts:

     

    Msg 195, Level 15, State 10, Procedure RX_Prediction_NextCall, Line 11

    'First_Value' is not a recognized built-in function name.

    Msg 319, Level 15, State 1, Procedure RX_Prediction_NextCall, Line 17

     

    Cause

     

    The First_Value is a function introduced in SQL Server 2012 and available in later versions. The error can occur if you are trying to run the scripts on SQL Server 2008 server or below.

     

    Solution

     

    Responder 10.2.1c requires a minimum of SQL Server 2012 for SQL Server customers to take advantage of the newer call processing changes.