Quote:
|
KB article re SP2 upgrade failure
Just talked to RIM about this and they sent me the following (sorry about the "click here for 103302.sql file" as they didn't provide links):
Problem You try to upgrade the BlackBerry Enterprise Server to software version 4.1 Service Pack 2 and the upgrade fails. The reason for the failure may vary (for example, the Transaction Log is full). When the original failure condition is corrected and you try to upgrade again, the BlackBerry Configuration Database upgrade fails. The DB_Install.log file displays the following: [10000] (09/13 23:14:07.682):{0x1878} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 3725 Message: The constraint 'PK_MDSConfig' is being referenced by table ' ', foreign key constraint 'FK_RelationSCMDS_MDSConfig'. [10000] (09/13 23:14:07.682):{0x1878} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 3727 Message: Could not drop constraint. See previous errors. Workaround To successfully upgrade the BlackBerry Enterprise Server, complete the following steps: If you are running Microsoft SQL Server 2000 with SQL Query Analyzer Click here to obtain the 103302.sql file. On the SQL Server, open SQL Query Analyzer. Select the BlackBerry Configuration Database name (for example, BESMgmt) from the drop-down list. Open the 103302.sql file and run it. If you are not running Microsoft SQL Server 2000 or do not have SQL Query Analyzer Click here to obtain the 103302.sql file and save it on the BlackBerry Enterprise Server (for example, save the file to C:\Program Files\Research In Motion). On the computer running SQL Server 2000 or Microsoft Data Engine (MSDE), open a command prompt. Type the following command: osql -d <database_name> -i <path>\103302.sql -E where <database_name> is the name of the BlackBerry Configuration Database (for example, BESMgmt) and <path> is the path to the SQL file (for example, C:\Program Files\Research In Motion\103302.sql). Note: The -E flag uses the permissions for the account currently logged in to Microsoft Windows® to access the SQL Server or MSDE database. If you do not have sufficient Windows permissions, or need to use a SQL Server account to log in, replace -E with the following: -U <account_name> -P <password> where <account_name> is the SQL login name, and <password> is the password of that account. Press ENTER. When the script has finished running, close the command prompt. |
Does this concern anyone else? Users are being added/deleted all the time in my environment. If I understand this correctly, every time I delete someone all users handhelds revert to only deleted messages locally even if they previously had it setup to delete on desktop as well???
BlackBerry Policy Service SDR 100058 If you add a user to the BlackBerry Enterprise Server and then delete that user, the Delete On option (in Messages Options > Email Reconciliation) on the BlackBerry device is set to Handheld for all existing users because the BlackBerry Policy Service sends out a service book update to all existing users when the user is deleted. |
Quote:
Someone with a high-level tier support care to inquire? |
Quote:
I think that has been there since 4.1 base. |
Quote:
I was going to roll out 4.1.2 into my production environment until I got to that point. TSupport in Asia (shall I say, what I perceive to be an Asian-based support team - maybe they are over there, maybe not) didn't even know that 4.1.2 was released a few days after it's release. It took 4.5 months to release SP1, yet it only took 1.5 months to release SP2. Also, that known issue alone is a fairly big bug. Assuming they knew about it since 4.1.0 (and just didn't mention it in the release notes for that release or the first service pack), I would find it quite astonishing they'd go through 2 updates w/o fixing it. It's not worded as most others with the 'under certain circumstances' so we're left to assume it happens anytime. On my test server, it's rare that I'll remove anyone aside from myself; however in production, that is another story, as I'm sure it is with most people. |
I just updated our BES to 4.1 SP2 and tested this by adding a test account, and then deleting that account. Been about an hour or so, and my blackberry's option haven't changed. It still shows Delete on Mailbox & Handheld.
|
I have been running 4.1.2 for just about a month now and have not experienced this issue to date. Maybe RIM will be releasing a hotfix for this?
At least the new user search feature is cool...lol |
Quote:
Are there more informations about this issue? Best Regards Alex |
Has anyone noticed that the release notes no longer refer to the JDBC being required for MDS. It shows up in the SP1 release notes, but in the sames sections for SP2, it is no longer there. Was this another oversight or is it somehow built in and no longer needed to be downloaded and installed seperately?
|
Anyone got 103302.sql ??? :smile:
|
Here is the content of 103302.sql
/*+--------------------------------------------------------------------------- * Support Script: 4.1.2 Upgrade failure * Created: 09/18/2006 * Tracked via : SDR103302 * Description: This script will fix the error in upgrading your database for the following failure: * [10000] (09/13 23:14:07.682):{0x1878} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 3725 Message: The constraint 'PK_MDSConfig' is being referenced by table ' ', foreign key constraint 'FK_RelationSCMDS_MDSConfig'. * [10000] (09/13 23:14:07.682):{0x1878} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 3727 Message: Could not drop constraint. See previous errors. * * Instructions for running script: * 1. Backup database * 2. Paste the following code into Query Analyzer * 3. Select your BESMgmt Database and then run the code *+--------------------------------------------------------------------------*/ /* it is possible there may be a 4.1.2 Version row in ServerDBVersion Table */ delete from ServerDBVersion where CurrentVersion = '4.1.2' go /* it is possible there may be orphaned MDSConfig rows so let's get rid of them */ delete from MDSConfig where serverconfigid is null go /* Drop objects in case this is a rerun to avoid problem dropping PK_MDSConfig */ IF EXISTS (SELECT name FROM sysobjects WHERE name = 'RelationSCMDS' AND type = 'U') begin drop TABLE dbo.RelationSCMDS end go if exists (select name from sysobjects where name = 'PK_MDSminuteStat' and xtype = 'PK') begin alter table MDSminuteStat drop constraint PK_MDSminuteStat end go if exists (select name from sysobjects where name = 'FK_MDSminuteStat_MDSConfigId' and xtype = 'F') begin alter table MDSminuteStat drop CONSTRAINT FK_MDSminuteStat_MDSConfigId end go if not exists (select name from sysobjects where name = 'PK_MDSminuteStat' and xtype = 'PK') begin ALTER TABLE MDSminuteStat WITH NOCHECK ADD CONSTRAINT PK_MDSminuteStat PRIMARY KEY CLUSTERED (Id) end go |
All times are GMT -5. The time now is 08:33 AM. |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.