BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 02-03-2008, 11:45 PM   #1 (permalink)
Talking BlackBerry Encyclopedia
 
Malkier's Avatar
 
Join Date: Feb 2007
Model: 8310
Carrier: ALL
Posts: 262
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Failed SP4 Insallation

Please Login to Remove!

Details:

BES 4.1.3
Exchange 2007
SQL2005 Database

Attempting to install Service Pack 4 and receiving the following error. No luck with RIM so far. Anyone have an idea at all of what it means,cause/fix?
Any information at all would be greatly appreciated!

[20000] (01/24 14:57:06.665):{0xF58} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S02 Native error: 208 Message: Invalid object name 'DBAMonitor..DDLSecurityLog'.
[30000] (01/24 14:58:10.302):{0xF58} [PIPTOOL]: Exiting PIPTool from DBInfoDlg.
Offline  
Old 02-04-2008, 07:19 AM   #2 (permalink)
BlackBerry Genius
 
hdawg's Avatar
 
Join Date: Aug 2006
Model: hdawg
PIN: port3101.org
Carrier: hdawg
Posts: 6,632
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Which service pack of SQL 2005 are you using?

Have you restored from a previous SQL backup and tried again, generating the same error?
Offline  
Old 02-04-2008, 10:15 AM   #3 (permalink)
CrackBerry Addict
 
mahoward's Avatar
 
Join Date: May 2005
Model: 8900
Carrier: T-Mobile
Posts: 560
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

This may be a longshot, but is your database set to case insensitive collation? If it is case sensitive it may not find the table it is looking for b/c the capitalization is off. What you want to see is "CI" somewhere in the collation settings (i.e. sort order rules) on the DB, like this:
Attached Images
File Type: jpg DB.JPG (48.4 KB, 4 views)
__________________
BESX 4.1.7 on Exchange 2003: 65 Devices
BESX 5.0.3 on Exchange 2003: 2007 Devices
Offline  
Old 02-04-2008, 10:49 PM   #4 (permalink)
Talking BlackBerry Encyclopedia
 
Malkier's Avatar
 
Join Date: Feb 2007
Model: 8310
Carrier: ALL
Posts: 262
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

The SQL version is SQL 2005 SP2 (Refresh - pre GDR)

The collation is case insensitive (SQL_Latin1_General_CP1_CI_AS).

No luck as of yet, Thanks for the suggestions so far, greatly appreciatated.
At a loss atm, guess I will give RIM a third shot at this one....

One other message that keeps showing up in the logs, is that a problem (sorry dont know SQL well)

[30000] (01/18 13:48:23.947):{0xD48} SQL Informational Message from CBESDBInstaller::Connect: Changed database context to 'BESMgmt'.

Last edited by Malkier : 02-04-2008 at 11:04 PM.
Offline  
Old 02-04-2008, 11:39 PM   #5 (permalink)
Talking BlackBerry Encyclopedia
 
Malkier's Avatar
 
Join Date: Feb 2007
Model: 8310
Carrier: ALL
Posts: 262
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dont know if it helps, but this is where the install was upto when it fails.

-- deny the following groups write access to security objects (not currently used)
deny insert, delete, update on SecGroup to rim_db_bes_server, rim_db_admin_enterprise, rim_db_admin_handheld, rim_db_admin_sr_helpdesk, rim_db_admin_jr_helpdesk
deny insert, delete, update on SecUser to rim_db_bes_server, rim_db_admin_enterprise, rim_db_admin_handheld, rim_db_admin_sr_helpdesk, rim_db_admin_jr_helpdesk
deny insert, delete, update on SecMapping to rim_db_bes_server, rim_db_admin_enterprise, rim_db_admin_handheld, rim_db_admin_sr_helpdesk, rim_db_admin_jr_helpdesk
Offline  




Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.