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"
- 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).
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.