1. Rodney Wilder's Avatar
    Due to below mentioned sql issues, your bes will be left broken as the installer removes the old apps before upgrading sql and installing new apps.

    Part of the upgrade runs the following sql statement
    IF NOT EXISTS (SELECT * FROM sys.indexes WHERE name = N'UX_defSfwrR_dvcOs_dvcRadio')
    BEGIN
    CREATE UNIQUE NONCLUSTERED INDEX UX_defSfwrR_dvcOs_dvcRadio
    ON def_software_release(id_device_os, id_device_radio)
    WHERE id_device_os IS NOT NULL
    AND id_device_radio IS NOT NULL;
    END

    this fails as apparently the previous scripts didn't clean up the previous keys
    The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.def_software_release' and the index name 'UX_defSfwrR_dvcOs_dvcRadio'. The duplicate key value is (131, 63).
    The statement has been terminated.

    If anyone wants to mess with sql at their own risk, the previous command which was supposed to clean this up is:

    /* Drop existing text column - existing data of no consequence as database version with field has not been included in a release and has had limited testing applied since time of introduction */
    IF EXISTS (SELECT * FROM sys.indexes WHERE name = N'UX_defSfwrR_deviceOSRadio')
    BEGIN
    DROP INDEX dbo.def_software_release.UX_defSfwrR_deviceOSRadio ;
    END

    I have opened an incident with BlackBerry already
    Solved with KB000037353
    Last edited by zocster; 09-08-15 at 10:50 AM. Reason: updated title after BB provided fix
    edwintg likes this.
    08-29-15 01:13 AM
  2. zocster's Avatar
    Thanks, keep us posted with the result!

    Sent from my Classic using Tapatalk
    08-29-15 01:23 AM
  3. deiop's Avatar
    We ran into the same issue....

    Posted via CB10
    08-30-15 12:11 AM
  4. Rodney Wilder's Avatar
    We ran into the same issue....

    Posted via CB10
    Sorry to hear. Below is the important parts of the response from tech working on it for us

    "I was able to identify the issue within the database.... I was able to find within dbo.def_software_release - It looks as if you have the definition of a device software version that had a previous radio version in it, normally the radio versions are updated with the software versions and not a downgrade. I believe this information is also pulled from the device.xml file but will need to confirm. "

    Apparently will do a test and compare tomorrow then check with senior agent to deploy sql repair script.

    In meantime I have restored my db to before the attempted upgrade, spun up a new windows server vm and reinstalled bes12.2 and pointed to the restored db. All is fine

    Beware reinstalling bes12.2 on same server as there is a separate bug in that which creates new server id instead of reusing the existing one, and ends in some bes services not starting. Currently, create new server and use different computer name. May be able to reuse existing server and just rename it and reboot before reinstall but I haven't tested, though should work in theory.


    Posted via CB with my Passport to productivity
    08-31-15 12:46 AM
  5. Rodney Wilder's Avatar
    An updated sql script has been provided. I'll be testing on mine likely friday eve. Mr2 with the fix included should be out soon, and an official kb will be posted.

    Posted via CB with my Passport to productivity
    09-03-15 12:49 AM
  6. Benjamin Black's Avatar
    This was a production release? I can't believe they pushed it out with that in there. It reminds me of them pushing out the passport screen flicker update.

    Posted via BlackBerry Passport Silver Edition
    09-03-15 02:19 AM
  7. Rodney Wilder's Avatar
    This was a production release? I can't believe they pushed it out with that in there. It reminds me of them pushing out the passport screen flicker update.

    Posted via BlackBerry Passport Silver Edition
    Not all bes12.2 upgrades are affected. Looks like a scenario they didn't test with certain info in some tables they were adjusting.
    But yes, big whoopsie along with 12.2 installing java 8.40 with upgrades enabled by default.
    Somebody gonna get a hurt real bad...

    Posted via CB with my Passport to productivity
    09-03-15 03:03 AM
  8. Rodney Wilder's Avatar
    Now that I've had a chance to try the repaired sql as part of the installer... it works!!!

    Moderator, can you adjust title to state -fix avail from BB


    Posted via CB with my Passport to productivity
    Last edited by Rodney Wilder; 09-05-15 at 02:51 AM.
    09-05-15 02:24 AM
  9. zocster's Avatar
    Do you have a link to the kb thanks!


    Sent from my Classic using Tapatalk
    09-05-15 03:14 AM
  10. Rodney Wilder's Avatar
    Do you have a link to the kb thanks!


    Sent from my Classic using Tapatalk
    They have yet to put up the KB unfortunately. As soon as it's up, I'll post back

    Posted via CB with my Passport to productivity
    zocster likes this.
    09-05-15 11:18 AM
  11. Rodney Wilder's Avatar
    http://support.blackberry.com/kb/art...mber=000037353

    Posted via CB with my Passport to productivity
    zocster and highos like this.
    09-08-15 10:41 AM

Similar Threads

  1. John Chen to talk cars, phones and more at Code/Mobile in October
    By CrackBerry News in forum CrackBerry.com News Discussion
    Replies: 2
    Last Post: 09-08-15, 11:57 PM
  2. Why aren't events showing on my Calendar any longer?
    By KitJackson67 in forum BlackBerry Q10
    Replies: 4
    Last Post: 09-08-15, 10:34 PM
  3. Why didn't my notes transfer to the Remember App?
    By CrackBerry Question in forum Ask a Question
    Replies: 0
    Last Post: 09-08-15, 10:46 AM
  4. When will the Passport silver addition be available in retail stores?
    By CrackBerry Question in forum BlackBerry Passport
    Replies: 1
    Last Post: 09-08-15, 10:45 AM
  5. Why don't events show up on my Calendar any longer on my Q10?
    By KitJackson67 in forum BlackBerry 10 OS
    Replies: 0
    Last Post: 09-08-15, 10:38 AM
LINK TO POST COPIED TO CLIPBOARD