[Aminocom]

Just recently we had to rebuild our BES.
We installed from the media we had and that installed 4.1.4

We are on Vodafone in the UK, so grabbed the updates from them.
So we downloaded and installed:

4.1.5
4.1.6
4.1.6 MR3
4.1.6 MR6
4.1.6 MR7

This was as far as the Vodafone site went, so I went to the service & support section of the Blackberry site.
From here I downloaded and installed:

4.1.6 MR8

I then downloaded 4.1.7 and attempted to install it.
The installation starts, I agree to a few license agreements and then get the following error message:

This version of the Backberry Enterprise Server installer will only upgrade from a previous installation with Version 4.0.0 or higher.
No such installation has been detected on your system. Set will now exit

And indeed setup then exits.
Has anyone else seen this error?
Any ideas on what I need to do to fix it?

[icontech]

MR's are cumlative so you could have installed the full installation of 4.1.6 then right to SP7. I would restart the box and try again. If that doesn't work then try to reinstall it like I suggested above.

[penguin3107]

Uninstall MR8.
MR8 for SP6 was released AFTER SP7.

You should install SP7 right after you install 4.1.4. There's no need to install the individual service packs and maintenance releases in between.

[Aminocom]

How can I uninstall MR8 for SP6?
Add/Remove Programs seems to just allow me to remove the whole of BES - something I don't want to do.

[Aminocom]

OK - New Error :(

Uninstalled BES

Installed 4.1.4 from our media
Run SP7

Get an error message "Attempt to upgrade database unsuccessful......"

The installation log shows the following:

[20000] (12/10 10:56:31.596):{0x8F8} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'IS_SECURE'." Native error = 207
[20000] (12/10 10:56:31.596):{0x8F8} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'IS_SECURE'." Native error = 207
[20000] (12/10 10:56:31.596):{0x8F8} [CBESDBInstaller::ExecuteDDL] SQL Error for:

DECLARE @tmi int;
SET @tmi=(select id from sysobjects where name='INBOUND_RELIABLE_QUEUE');
IF ((select count(*) from syscolumns where id=@tmi and name='IS_SECURE') >0)
begin
UPDATE INBOUND_RELIABLE_QUEUE SET SECURITY_TYPE='NULL' WHERE IS_SECURE=0;
UPDATE INBOUND_RELIABLE_QUEUE SET SECURITY_TYPE='IV_PREFIXED_AES_CBC_PKCS5PADDING' WHERE IS_SECURE=1;
SELECT MSG_ID, MSG_TYPE, MSG_BODY, IS_DELETED, EXPIRE_DATE, WICLET_ID, DEVICE_ID, KEEP_LAST_CRITERIA, SECURITY_TYPE INTO INBOUND_RELIABLE_QUEUE_NEW FROM INBOUND_RELIABLE_QUEUE;
DROP TABLE dbo.INBOUND_RELIABLE_QUEUE;
EXEC sp_rename 'INBOUND_RELIABLE_QUEUE_NEW', 'INBOUND_RELIABLE_QUEUE', 'OBJECT';
ALTER TABLE dbo.INBOUND_RELIABLE_QUEUE
ADD CONSTRAINT PK_IN_REL_QUEUE PRIMARY KEY (MSG_ID);
ALTER TABLE dbo.INBOUND_RELIABLE_QUEUE
ADD CONSTRAINT relationship19 FOREIGN KEY (WICLET_ID, DEVICE_ID)
REFERENCES DEVICE_WICLET (WICLET_ID, DEVICE_ID);
end

Any ideas?

[nobody7290]

I think, your database cannot be upgraded, because it is already a newer version.

uninstall the BES, reboot,
then run the 4.1.7 installer.

[icontech]

remote or local database? What versions?

[besadmin23]

and... 4.1.7 worked???

[buluks]

do you have clausal time to fix BES server ? if not, i recommend to backup database and uninstall msde ( my though from your case is local database using MSDE ) then reinstall BES application 4.1.6 ( it will make BES recognize that there is no database then will install MSDE automatic ), restore your database.

your database is newer than database format on 4.1.4. because 4.1.6 and 4.1.4 service pack msde is different.

[rsk]

I wouldn't touch SQL/msde, just install in the correct sequence and you should be fine.

[penguin3107]

Looks like you may be hosed... for now.
View Document