{"action":"opened","issue":{"url":"https://api.github.com/repos/lionheart/openradar-mirror/issues/8593","repository_url":"https://api.github.com/repos/lionheart/openradar-mirror","labels_url":"https://api.github.com/repos/lionheart/openradar-mirror/issues/8593/labels{/name}","comments_url":"https://api.github.com/repos/lionheart/openradar-mirror/issues/8593/comments","events_url":"https://api.github.com/repos/lionheart/openradar-mirror/issues/8593/events","html_url":"https://github.com/lionheart/openradar-mirror/issues/8593","id":147392058,"number":8593,"title":"22674100: VPP Device Assignment returns SQL exception","user":{"login":"openradar-mirror","id":13605213,"avatar_url":"https://avatars.githubusercontent.com/u/13605213?v=3","gravatar_id":"","url":"https://api.github.com/users/openradar-mirror","html_url":"https://github.com/openradar-mirror","followers_url":"https://api.github.com/users/openradar-mirror/followers","following_url":"https://api.github.com/users/openradar-mirror/following{/other_user}","gists_url":"https://api.github.com/users/openradar-mirror/gists{/gist_id}","starred_url":"https://api.github.com/users/openradar-mirror/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/openradar-mirror/subscriptions","organizations_url":"https://api.github.com/users/openradar-mirror/orgs","repos_url":"https://api.github.com/users/openradar-mirror/repos","events_url":"https://api.github.com/users/openradar-mirror/events{/privacy}","received_events_url":"https://api.github.com/users/openradar-mirror/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/lionheart/openradar-mirror/milestones/21","html_url":"https://github.com/lionheart/openradar-mirror/milestones/App%20Store","labels_url":"https://api.github.com/repos/lionheart/openradar-mirror/milestones/21/labels","id":1237435,"number":21,"title":"App Store","description":null,"creator":{"login":"openradar-mirror","id":13605213,"avatar_url":"https://avatars.githubusercontent.com/u/13605213?v=3","gravatar_id":"","url":"https://api.github.com/users/openradar-mirror","html_url":"https://github.com/openradar-mirror","followers_url":"https://api.github.com/users/openradar-mirror/followers","following_url":"https://api.github.com/users/openradar-mirror/following{/other_user}","gists_url":"https://api.github.com/users/openradar-mirror/gists{/gist_id}","starred_url":"https://api.github.com/users/openradar-mirror/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/openradar-mirror/subscriptions","organizations_url":"https://api.github.com/users/openradar-mirror/orgs","repos_url":"https://api.github.com/users/openradar-mirror/repos","events_url":"https://api.github.com/users/openradar-mirror/events{/privacy}","received_events_url":"https://api.github.com/users/openradar-mirror/received_events","type":"User","site_admin":false},"open_issues":49,"closed_issues":0,"state":"open","created_at":"2015-08-03T02:08:52Z","updated_at":"2016-04-11T11:02:49Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2016-04-11T11:02:49Z","updated_at":"2016-04-11T11:02:49Z","closed_at":null,"body":"#### Description\n\nSummary:\r\nWhen trying to assign a device license to a serial number that already has the license, a SQL exception is returned while the error code 9616 is expected.\r\n\r\nSteps to Reproduce:\r\n1. Assign a license to a device (serialnumber)\r\n2. Try to assign a license to the exact same device (serialnumber)\r\n\r\nExpected Results:\r\nError code 9616 (license already assigned)\r\n\r\nActual Results:\r\nError code 9603 with the falling errorMessage:\r\n\r\ncom.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed: <ITOracleExpression: \"UPDATE MZ_VPP_LICENSE SET SERIAL_NUMBER = ?, STATUS_ID = ?, LAST_MODIFIED = ? WHERE (VPP_LICENSE_ID = ? AND SUPPRESS_UNCLAIM_APN = ? AND LAST_MODIFIED = ? AND MACHINE_ID is NULL AND GUID is NULL AND SERIAL_NUMBER is NULL AND STATUS_ID = ? AND VPP_REG_USER_ID is NULL)\" withBindings: 1:\"xxxxxxxxxx\"(serialNumber), 2:3(statusId), 3:2015-09-12 05:55:39.978 -0700(lastModified), 4:801235141(id), 5:0(suppressUnclaimApn), 6:2015-09-10 03:03:32.0 -0700(lastModified), 7:1(statusId)>:\r\n    Next exception:SQL State:23000 -- error code: 1 -- msg: ORA-00001: unique constraint (JINGLE.MZ_VPP_LICENSE_IDX8) violated\r\n\r\nVersion:\r\niOS\r\n\r\nNotes:\r\n\r\n\r\nConfiguration:\r\n\r\n\r\nAttachments:\n\n-\nProduct Version: \nCreated: 2015-09-12T14:55:52.104880\nOriginated: 2015-09-12T15:03:00\nOpen Radar Link: http://www.openradar.me/22674100"}}