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


The below error may occur in the initial CONNECT Edition release ( 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)



To resolve this issue, for WaterGEMS, WaterCAD or HAMMER, please upgrade to CONNECT Edition build (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

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