When I start the SystemWeaver server (either by directly executing the server or using the swTestServer GUI), I am getting a "ERROR sws     - DB Integrity error". 


Example


Resolution

The error is an indication that the data in the database contains orphaned parts and/attributes that do not have an owner. This must be cleaned up before the server can be started. 

  1. Take a backup of the database
  2. Open the swDatabaseManager utility included in the server installation.
  3. Select the Database Type and, for Select database, enter the valid path to and name of the database. For MSSQL servers, enter the server followed by the pipe character (|) and the database name.
  4. Click Display info to simply confirm a connection. It will display the database version #, etc.
  5. Click Clean lost parts. Depending on the size of the database, it will take up to approximately 2 minutes to complete. The log window will display a list of the purged, orphaned parts and attributes. The server can now be started against the database.