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

Version 1



    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




    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.




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