Issue: When running the upgrade52to57.sql script during the upgrade of an EnergyCAP database from DB52 to DB57, you receive the following error:
"Server: Msg 50000, Level 16, State 1, Line 556
More than one record in table Community WHERE (communityID = 63) OR (unitTypeID = 1 AND commodityID = 16 AND nounID = 26)"
Solution: You may ignore this message. The message indicates that a conversion is already present in the database and no action is required.
Further explanation: We try to update unitTypeID in the Community record where communityID = 63 OR (unitTypeID = 11 AND commodityID = 16 AND nounID = 26) to a value of 1 to reflect a change in how the TONHR unit is classified. This message indicates that the conversion is already present in the database. If the user deletes the existing one, the problem should go away. Optionally, although I don't recommend it, the user could modify the upgrade script by searching for "trac ticket #174" and disabling the two two blocks of SQL logic that follow it (up until the next comment line).
Written by Ryan Ohlson on 7/2/2009