Error when upgrading GoldMine Premium Edition - Can't recognize opportunities units float format. The Dashboards having opportunities units will work incorrectly

Version 1

    Details

    When upgrading GoldMine Premium Edition you receive the following error message during the database update process.
    "Can't recognize opportunities units float format.
    The Dashboards having opportunities units will work incorrectly
    "



    Resolution

    [CAUSE]

    - The issue is most likely caused by *Bad* data in the Opportunity manager
    - The opportunity unit field is stored in the dbo.Opmgr.F3 field in the GoldMine database.
    - One or more of the values in the dbo.Opmgr.F3 field has an invalid character (anything other than a numeric value).

    [RESOLUTION]


    Remove the corrupt data from the dbo.Opmgr.F3 field.

    The below SQL expression should aid in determining what records have invalid characters
    SELECT * FROM OPMGR WHERE F3 LIKE '%[^0-9]%' AND RECTYPE = 'O'

    NOTE:
    Global support services cannot aid in troubleshooting data related issues.  For data troubleshooting, Global Support recommends that you engage with your solutions partner to troubleshoot data consistency issues.