"pk_mm_users_userid" is not a constraint

This article applies to:

• Trustwave SPE
• Upgrading to 4.0

Symptoms:

• Database upgrade cannot be completed
• Error dialog: "pk_mm_users_userid" is not a constraint. Could not drop constraint. See previous errors.

Causes:

• This issue can be caused if the primary key on the table mm_users is missing or has been renamed.
• In some cases this key had previously been manually adjusted when resolving issues with very large numbers of users being inserted.

Resolution:

To resolve this issue:

1. Open the SPE Configuration database using SSMS, and view the properties of the table mm_users (expand tables > mm_users > keys).
2. Ensure that the primary key pk_mm_users_userid exists (if necessary, rename the primary key for the table).
3. Re-run the product upgrade. The database upgrade will complete normally.