SQLiteConstraintViolationException when working with a model that was saved in a previous version

  Product(s): WaterGEMS, WaterCAD, HAMMER, SewerGEMS, SewerCAD, StormCAD, CivilStorm
  Version(s): 10.00.00.XX, 10.01.XX.XX
  Area: Other

Problem

The below error may occur in the initial CONNECT Edition release (10.00.00.49) of WaterGEMS, WaterCAD or HAMMER, when working on a model that was originally created in an older version.

In SewerGEMS, CivilStorm, StormCAD and SewerCAD, a very similar error may occur when performing a task (in a model originally created in an older version) that requires the conduit descriptions to be updated (and you may see a dialog stating "Updating Conduit descriptions") or when manipulating certain conduits.

Haestad.SQLite.SQLiteConstraintViolationException: 19: columns DomainElementID, AlternativeID are not unique

   at Haestad.SQLite.SQLiteLibrary.ThrowException(Int32 errorCode, String errorMessage)
   at Haestad.SQLite.SQLiteCommand.ExecuteNonQuery()
   at Haestad.Domain.DataObjects.Sqlite.SqliteAlternativeRecordDataBrokerBase.MakeRecordLocalBasic(String tableName, StringFilterDelegate fieldsToCopyFilterDelegate, Int32 fromDomainElementID, Int32 fromAlternativeID, Int32 toDomainElementID, Int32 toAlternativeID)

...

Solution

To resolve this issue, for WaterGEMS, WaterCAD or HAMMER, please upgrade to CONNECT Edition build 10.00.00.50 (or greater, when available). If you are not able to upgrade from build 49 to build 50, please contact Technical Support for the latest Cumulative Patch set for version 10.00.00.49.

For SewerGEMS, CivilStorm, StormCAD and SewerCAD, contact technical support in case their is a corruption in the model database which our developers may need to fix.

Defect #616558

See Also

Anonymous
Recommended
Related