Editing a Setup definition fails with primary key violation (PRIMARY KEY)

%3cdiv style%3d%22float%3a left%3b line-height%3a 14px%3bfont-family%3a Verdana%3b font-size%3a 10pt%3b%22%3e%3cp%3eEditing a Setup definition may fail with an exception like%3a%3c/p%3e
%3cp%3e%3cspan style%3d%22font-family%3a consolas%3b color%3a %23000000%3b font-size%3a 16px%3b%22%3eSetup update failed%3c/span%3e%3c/p%3e
%3cp%3e%3cspan style%3d%22font-family%3a consolas%3b color%3a %23000000%3b font-size%3a 16px%3b%22%3eJob update failed%3c/span%3e%3c/p%3e
%3cp%3e%3cspan style%3d%22font-family%3a consolas%3b color%3a %23000000%3b font-size%3a 16px%3b%22%3eViolation of PRIMARY KEY constraint %27PK_SetupD%27. Cannot insert duplicate key in object %27dbo.SetupD%27.%3c/span%3e%3c/p%3e
%3cp%3e%3cspan style%3d%22font-family%3a consolas%3b color%3a %23000000%3b font-size%3a 16px%3b%22%3eThe statement has been terminated.%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
%3c/span%3e%3c/p%3e
%3cp%3eIf this happens every time you edit a particilar Setup%2c the Setup definition that is saved in the database is corrupt.  To repair this corruption%2c follow these steps%3a%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
1. Right click on the problem Setup and pick %22Copy To%22.%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
2. Enter a new name to copy the problem Setup to a new name.%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
3. Delete the problem Setup.%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
4. Rename the new copy of the Setup back to the original name.%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
Copying the Setup to a new name may not be a good solution if you have other objects that reference the Setup.   In that case%2c you need to use SQL to correct the issue.  To correct this issue with SQL%2c execute this command on the SQL Server machine%3a%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
SQLCMD -E -d JAMS -Q %22delete from dbo.SetupD where job_id %3d 0%22%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
%3cspan style%3d%22background-color%3a %23ffff00%3b font-size%3a 18px%3b%22%3eCAUTION%3a This command deletes data from the JAMS Database.  Make sure that you have a recent backup of the JAMS database before executing this command.  Make sure that you type the command exactly as shown or you run the risk of deleting important data.%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e
%3c/span%3e%3c/p%3e
%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3e%3cspan style%3d%22font-size%3a 4pt%3b%22%3e%3cp%3e%3c/p%3e%3c/span%3eMVP Systems - Support%3cbr /%3ehttp%3a//www.jamssupport.com/KnowledgebaseArticle50025.aspx%3c/div%3e