Solved

Blackberry BES - virtualised and now problems upgrading from 4.1 to 4.7

Posted on 2010-09-16
15
1,090 Views
Last Modified: 2012-06-21
Recently, as part of a virtualisation project, the server running our single BES was virtualised.  As a physical box its spec was:

Windows Server 2003 SP2
BES 4.1.2.25
Exchange 2003

and it had run without too many problems for the 12 users for a number of years.

It was virtualised using VMWare vSphere 4.0 and users started to complain they could no linger access the internet a few days later.  Mail services were unaffected.  Error messages on the Blackberry devices showed there was no connection to the MDS service and checking on the BES there was absolutely nothing under the MDS Connection.

After calling to our service provider, T-Mobile UK, we were told that the RIM recommended configuration for a virtual WK2003 machine running BES 4.1 under vSphere 4.0 was with the BES upgraded to SP7.  I downloaded besx_upgrader_4.1.7 and ran the install program.

During the Pre-install check it reported that Java Runtime Environment v6 Update 15 wasn't detected but that it would be installed as part of the upgrade to 4.1.7.  The server is currently running JRE v6 Update 21.  

I took all the default options during the upgrade and the settings were:

Data Directory:      C:\Program Files\ Microsoft SQL Server\MSSQL\Data
Backup Directory:      C:\Program Files\ Microsoft SQL Server\MSSQL\Backup

A dialogue box asked me if I was sure I wanted to upgrade the database and I agreed.  The blue progress line advanced about a fifth of the way across its box and then this error message appeared:

'An attempt to upgrade the database was unsuccessful.  An error occurred while executing an SQL statement."

I ok'd and canceled the upgrade.

My questions are - what's gone wrong and how is it fixed?  Can the BES server remain virtualised or will we have to revert to a physical box?

Thank you.
0
Comment
Question by:swaman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
15 Comments
 
LVL 3

Expert Comment

by:kumarsundaram
ID: 33691725
Hi Swaman...  To my knowledge BES officially became compatible to run as a VM beginning version 5.0.  Anything before that does not support a Virtual platform.  We were in the same scenario before and running it in a physical box up until they released version 5.0.  Now the latest version of BES is running fine on a VM in an ESXi enviroment.
0
 
LVL 63

Expert Comment

by:SysExpert
ID: 33695209
I would contact support from RIM, since that error is extremely common and may not be related to the VM at all.

I hope this helps !
0
 
LVL 42

Expert Comment

by:kevinhsieh
ID: 33696651
I agree with SysExpert, I highly doubt that it's related to virtualization. I ran BES 4.x for years under MS Virtual Server and Hyper-V.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:swaman
ID: 33699280
Thanks for the replies.  The problem has finally been referred back to RIM by T-Mobile so I'll update here as to what happens.
0
 
LVL 3

Expert Comment

by:John_Dorian
ID: 33705675
Odds are the account you were logged in as did not have permissions to SQL. Check the setup.log file it will quote the exact SQL error it threw. That will be the root cause of this.

Is the SQL running on MSDE, or a remote SQL server somewhere?
0
 

Author Comment

by:swaman
ID: 33714838
RIM have looked at the SQL logs and and suggested I apply SP4 to BES and then try SP7.  They sent me SP4 but when I ran it an error message came up saying

'Cannot upgrade to older version'

I'm now waiting to see what their response is.
0
 
LVL 20

Expert Comment

by:Iain MacMillan
ID: 33723387
i can confirm that BES 5.0 works well under vSphere 4.0, but we upgraded to BES 5.0 while we still had a physical box last year, but wasn't aware the v4.x wouldn't work under VM.

as a wee suggestion, could you not isolate the physical server, and try to make another cold clone, to test on VMware (isolated network) and try and do a BES 5.0 upgrade (T-mobile would need to provide the d/l and codes, and you will need to transfer your CALs).  i went from 4.0.7 to 5.0 very easily, but i had a local SQL DB - but you can practice this and see if it works, if so, then you can turn off you current VM and test the isolated one.
0
 
LVL 20

Expert Comment

by:Iain MacMillan
ID: 33723401
oops, scratch the testing......you have BES and Exchange on the same server, unfortunately RIM guidelines stipulate that you really shouldn't have them on the same server, always better to have BES on its own server.

you could try to do a new virtual server build, server 2003 (or 2008 if your ready) with BES 5.0 and do a user/handset migration, plenty of documentation on this, that way you can assign plenty of VM resources, without affecting your exchange server.  also will make it easier to upgrade from Exchange 2003 to 2010 (that's my current task/project) if they are separate.
0
 

Author Comment

by:swaman
ID: 33752119
Hi lainNix

Nope  - we have Exchange and BES on separate servers but here's the latest update:

Upgrading the SP from 2 to 7 didn't work (despite advice saying that this was ok to do).  RIM's solution was to apply SP4 and then SP6 and then SP7.  However in applying SP4 the error described above appeared.

Logs from the failed upgrade showed 'Installer is reporting:  "Invalid column name 'DisplayVersion'

RIM's response:

The "Display Version" Table was introduced to the BESMgmt DB in SP6 and above, so the reason the customer is getting this error is because after upgrading straight to SP7 from SP2, the Installer cannot find this table in the DB as it doesn’t exist in the current  4.1.2 Schema that the customer has.

To fix this they sent instructions on how to manually change the .cfg file and run the SP updates sequentially.  Unfortunately this too failed and I've now had to send the BES SQL databases off to RIM for further analysis of the problem.  They've said we might need a webex session to fix it.

This could run and run.

The option of upgrading to BES 5.0 has been investigated but we're being asked for £3k to do so.  Sounds and expensive fix to me.

0
 
LVL 20

Expert Comment

by:Iain MacMillan
ID: 33770660
yes the BES 5 upgrades are costly.....your getting a bargain, the first price Vodafone tried to charge me was £4k, and they were told where they could stick that.  eventually got it for £2k, as its in their best interests to keep you happy, especially if your going to add more handsets/CALs.

looks like there has been an issue with the SQL database, which is tricky to fix at the best of times, and I am no expert.  I assume the BES is non-operational just now, is that so?

if it is, you may want to do a restore from backup to before you tried the failed upgrade, and see if you can recover that way and then do the incremental SP updates. if it still workign then you may wish to leave alone, else run the risk of killing it completely.

alternative would be to rebuild/install the BES server, and go direct to 4.1.7.
0
 

Author Comment

by:swaman
ID: 33797060
I said this would run and run........

After a bit of prodding, RIM provided a SQL script to clean up the database and allow a phased upgrade to BES SP7.  They even arranged a conference call to discuss how to run the script and make the upgrades.  Unfortunately when I ran the script it didn't behave exactly as their instructions said it would so I had to ask for more clarification.

During the conference call I was also advised that the best way to resolve this was to make a clean install of BES 5 and then migrate the user data from the current BES 4.  A further chat with T-Mobile revealed new, much lower pricing for BES 5.  As soon as they confirm this price in writing, I'll get BES 5 loaded up!

Update to follow.
0
 
LVL 20

Expert Comment

by:Iain MacMillan
ID: 33797468
some good news at last, amazing what a bit of prodding can do....hopefully we can welcome you to the BES 5 club soon enough!!
0
 

Accepted Solution

by:
swaman earned 0 total points
ID: 34100729
Just to finish this off.......

Still had plenty of hoops to jump through getting this sorted but we are now having a RIM consultant come and install BES 5 for us and then migrate all the BES 4 databases across.  It should happen next week and could be the end of it - finally!.

0
 
LVL 20

Expert Comment

by:Iain MacMillan
ID: 34100772
pity you had so many issues, but at least its sorted now and you can now get some sleep!!

:)
0
 

Author Closing Comment

by:swaman
ID: 34134480
This was a very complicated issue made even worse by poor information from T-Mobile and RIM.  The original question was never resolved and only by starting from scratch with a fresh installation of BES 5 on a new virtual server was our full Blackberry service restored.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

BlackBerry can provide (arguably) the best global email delivery solution. That is, until something goes wrong at which point it can be a nightmare to troubleshoot. The log files on a BES can only be decoded by an expert and some of the errors that …
Have you ever wondered if there is a way to get a message delivery receipt without interrogating the BlackBerry log files or using the Resource Kit tools? It is possible using this tip: When troubleshooting whether a BlackBerry is receiving email…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question