I'm having trouble upgrading the SQL 2000 database for my BES 3.6 server to version 4.0. It is on a remote sql server so I'm trying to run createdb with it set to upgrade. Every time I do I get an error saying "cannot drop view vMDSMAP, because it does not exist in the system catalog." 02, our blackberry service provider, cannot tell me why this is and what to do about it. Does anyone have any idea what is causing this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Upgrade of BES from 3.6 to 4.0
- Thread starter Kevince
- Start date
rubbaninja
MIS
Check the MDAC version on the SQL server and the BES server. I had kind of the same issues, here is my Blackberry Support reply;
The MDAC v2.8 requirement is listed as a prerequisite on page 9 of the Installation Guide for BlackBerry Enterprise Server v4.0.
"Download Microsoft Data Access Components (MDAC) 2.8 from
and install it on the
BlackBerry Enterprise Server computer and on the server where the configuration database is located."
It may be possible to use MSDE 2000 to house the BlackBerry
Configuration Database, however it would not be recommended if you have a large amount of users due to the resource and performance limitations of MSDE.
Alternatively, since you have not yet upgraded to BlackBerry Enterprise Server v4.0, you may want to drop the existing BESMgmt database andcreate a new one using the CreateDB.exe scripts for BlackBerry Enterprise Server v4.0. The v3.6 BlackBerry Enterprise Server will continue to run without the database, however the BlackBerry Management Console will be unavailable until the database is recreated, and after
the database has been upgraded, the BlackBerry Manager will need to be used for administration. By dropping and creating a new database, once you upgrade to BlackBerry Enterprise Server v4.0, you will also have to recreate your IT Policies and any custom Mobile Data Service settings.
The MDAC v2.8 requirement is listed as a prerequisite on page 9 of the Installation Guide for BlackBerry Enterprise Server v4.0.
"Download Microsoft Data Access Components (MDAC) 2.8 from
and install it on the
BlackBerry Enterprise Server computer and on the server where the configuration database is located."
It may be possible to use MSDE 2000 to house the BlackBerry
Configuration Database, however it would not be recommended if you have a large amount of users due to the resource and performance limitations of MSDE.
Alternatively, since you have not yet upgraded to BlackBerry Enterprise Server v4.0, you may want to drop the existing BESMgmt database andcreate a new one using the CreateDB.exe scripts for BlackBerry Enterprise Server v4.0. The v3.6 BlackBerry Enterprise Server will continue to run without the database, however the BlackBerry Management Console will be unavailable until the database is recreated, and after
the database has been upgraded, the BlackBerry Manager will need to be used for administration. By dropping and creating a new database, once you upgrade to BlackBerry Enterprise Server v4.0, you will also have to recreate your IT Policies and any custom Mobile Data Service settings.
- Status
Similar threads