09-27-2006, 03:11 AM
|
#2 (permalink)
|
| Knows Where the Search Button Is
Join Date: Jan 2006 Location: Amsterdam Model: 8707v Carrier: Vodafone
Posts: 33
Post Thanks: 0 Thanked 0 Times in 0 Posts
| Is this server upgraded from v4.0 to v4.1?
If so, check if the following will resolve your issue:
Run the following SQL query via the Query Analyzer (SQL) or OSQL (MSDE) onto your BES database. Make sure to create a backup first if anything fails:
/*
* correct any existing values
*/
UPDATE MDSConfig Set ACLAuthorizationDatastore = 'net.rim.shared.service.authorization.JDBCAuthoriz ationDatastore'
where ACLAuthorizationDatastore = 'net.rim.bmds.shared.service.authorization.JDBCAut horizationDatastore'
go
/*
* change the default for new values
*/
declare @DF sysname
set @DF = (select object_name(cdefault) from syscolumns
where object_name(id) = 'MDSConfig' and name = 'ACLAuthorizationDatastore')
if @DF is not null
begin
declare @value nvarchar(4000)
set @value = (select text from syscomments where object_name(id) = @DF)
if @value = '(''net.rim.bmds.shared.service.authorization.JDBC AuthorizationDatastore'')'
begin
exec('alter table MDSConfig drop constraint ' + @DF)
alter table MDSConfig add default('net.rim.shared.service.authorization.JDBC AuthorizationDatastore') for ACLAuthorizationDatastore
end
end
go
__________________
BlackBerry consultant @ dahvo |
| Offline
| |