Open Radar

 
Summary:
When 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.

Steps to Reproduce:
1. Assign a license to a device (serialnumber)
2. Try to assign a license to the exact same device (serialnumber)

Expected Results:
Error code 9616 (license already assigned)

Actual Results:
Error code 9603 with the falling errorMessage:

com.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)>:
    Next exception:SQL State:23000 -- error code: 1 -- msg: ORA-00001: unique constraint (JINGLE.MZ_VPP_LICENSE_IDX8) violated

Version:
iOS

Notes:


Configuration:


Attachments: