I'm not sure where to share this tip for best visibility, so I've chosen email. Please feel free to document this centrally if you know a good place. The relevant ticket in Support Desk is #1165, but finding the correct SQL there could be a challenge because the ticket contains much back-and-forth communication.
When a customer upgrades their TariffShark database to version 5003, this error is a possible outcome.
An error occurred while upgrading the database from version <nnnn> to 5003. Transaction was rolled back. Versions exist that do not match 9999.99.99 format
We've seen multiple causes, so there doesn't exist a fix that will work for all. These errors must be passed to Level 2 support.
Level 2 Support Folks,
The following SQL will help identify the invalid [TariffRecordVersion].[Version] values so that we may plan how to best fix the data, and fixing the data will enable the Database Installer to upgrade the database.
SELECT [Version], COUNT(1) AS 'Frequency'
FROM [TariffRecordVersion]
WHERE [Version] NOT LIKE '[0-9][0-9][0-9][0-9].[0-9][0-9].[0-9][0-9]'
GROUP BY [Version]