Problem / Solution: Arithmetic overflow error converting nvarchar to data type numeric when opening the Universal Search workspace after configuring additional objects to be searched

Version 1

    Environment:

    Premise installations running 2016.2.1 or older

     

    Requires Access To:

    AdminUI

     

    Error message:

    Arithmetic overflow error converting nvarchar to data type numeric

     

    Problem:

    After configuring additional objects to be searched by the Universal Search workspace (commonly "Search" for OOTB roles) an error may appear stating "Arithmetic overflow error converting nvarchar to data type numeric"

     

    Cause:

    This is caused by selecting a Numeric field for the "Title field" in the configuration for the additional Object:

     

    Solution / Workaround:

    This issue is corrected in 2017.1.1 so upgrade is recommended, however, if upgrade cannot be done, simply using a non-Numeric field for the Title Field will resolve the error: