{"action":"closed","issue":{"url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/3733","repository_url":"https://api.github.com/repos/OctopusDeploy/Issues","labels_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/3733/labels{/name}","comments_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/3733/comments","events_url":"https://api.github.com/repos/OctopusDeploy/Issues/issues/3733/events","html_url":"https://github.com/OctopusDeploy/Issues/issues/3733","id":249934295,"number":3733,"title":"Migrator fails for ExtensionConfiguration documents","user":{"login":"MJRichardson","id":113759,"avatar_url":"https://avatars1.githubusercontent.com/u/113759?v=4","gravatar_id":"","url":"https://api.github.com/users/MJRichardson","html_url":"https://github.com/MJRichardson","followers_url":"https://api.github.com/users/MJRichardson/followers","following_url":"https://api.github.com/users/MJRichardson/following{/other_user}","gists_url":"https://api.github.com/users/MJRichardson/gists{/gist_id}","starred_url":"https://api.github.com/users/MJRichardson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MJRichardson/subscriptions","organizations_url":"https://api.github.com/users/MJRichardson/orgs","repos_url":"https://api.github.com/users/MJRichardson/repos","events_url":"https://api.github.com/users/MJRichardson/events{/privacy}","received_events_url":"https://api.github.com/users/MJRichardson/received_events","type":"User","site_admin":false},"labels":[{"id":509292504,"url":"https://api.github.com/repos/OctopusDeploy/Issues/labels/area/scale","name":"area/scale","color":"006b75","default":false},{"id":62440875,"url":"https://api.github.com/repos/OctopusDeploy/Issues/labels/bug","name":"bug","color":"eb6420","default":true},{"id":242906961,"url":"https://api.github.com/repos/OctopusDeploy/Issues/labels/feature/migrator","name":"feature/migrator","color":"0052cc","default":false}],"state":"closed","locked":false,"assignee":{"login":"MJRichardson","id":113759,"avatar_url":"https://avatars1.githubusercontent.com/u/113759?v=4","gravatar_id":"","url":"https://api.github.com/users/MJRichardson","html_url":"https://github.com/MJRichardson","followers_url":"https://api.github.com/users/MJRichardson/followers","following_url":"https://api.github.com/users/MJRichardson/following{/other_user}","gists_url":"https://api.github.com/users/MJRichardson/gists{/gist_id}","starred_url":"https://api.github.com/users/MJRichardson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MJRichardson/subscriptions","organizations_url":"https://api.github.com/users/MJRichardson/orgs","repos_url":"https://api.github.com/users/MJRichardson/repos","events_url":"https://api.github.com/users/MJRichardson/events{/privacy}","received_events_url":"https://api.github.com/users/MJRichardson/received_events","type":"User","site_admin":false},"assignees":[{"login":"MJRichardson","id":113759,"avatar_url":"https://avatars1.githubusercontent.com/u/113759?v=4","gravatar_id":"","url":"https://api.github.com/users/MJRichardson","html_url":"https://github.com/MJRichardson","followers_url":"https://api.github.com/users/MJRichardson/followers","following_url":"https://api.github.com/users/MJRichardson/following{/other_user}","gists_url":"https://api.github.com/users/MJRichardson/gists{/gist_id}","starred_url":"https://api.github.com/users/MJRichardson/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MJRichardson/subscriptions","organizations_url":"https://api.github.com/users/MJRichardson/orgs","repos_url":"https://api.github.com/users/MJRichardson/repos","events_url":"https://api.github.com/users/MJRichardson/events{/privacy}","received_events_url":"https://api.github.com/users/MJRichardson/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2017-08-14T05:10:20Z","updated_at":"2017-08-14T05:13:26Z","closed_at":"2017-08-14T05:13:26Z","body":"When ExtensionConfiguration records are present in the exported data, the migrator fails with an error similar to:\r\n\r\n```\r\nError:   An unexpected error occurred when processing document with source ID 'authentication-xxx': Error while executing SQL command in transaction '<unknown>': The column name 'JSON' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code.\r\nError: The command being executed was:\r\nError: UPDATE dbo.[ExtensionConfiguration]  SET [Name] = @Name, [ExtensionAuthor] = @ExtensionAuthor, [Json] = @Json, [JSON] = @Json WHERE Id = @Id\r\nError: System.Exception: Error while executing SQL command in transaction '<unknown>': The column name 'JSON' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code.\r\nError: The command being executed was:\r\nError: UPDATE dbo.[ExtensionConfiguration]  SET [Name] = @Name, [ExtensionAuthor] = @ExtensionAuthor, [Json] = @Json, [JSON] = @Json WHERE Id = @Id ---> System.Data.SqlClient.SqlException: The column name 'JSON' is specified more than once in the SET clause or column list of an INSERT. A column cannot be assigned more than one value in the same clause. Modify the clause to make sure that a column is updated only once. If this statement updates or inserts columns into a view, column aliasing can conceal the duplication in your code.\r\n```\r\n\r\nReported by: http://help.octopusdeploy.com/discussions/questions/12625"}}
{"actor":{"display_login":"MJRichardson"}}