[Lemegeton]

hi could someone please give me some advice.

none of the blackberries in my company will synch OTA through EA anymore. nothing was changed on the BES and for the past 3 weeks no activation will go through. stage 1 of enterprise activation goes through fine but it keeps crashing during stage 2. sometimes the device will sycnh the calendar and then die or other times it will get to "email address has now been enabled" and then stop. no errors come up the process just stops and i have left devices for hours and nothing else happens. i am running version 4.1.0.38 of the BES. i have gone through the kb articles here

BlackBerry Search Results

but have had no joy yet. i have looked through the various logs on the bes but im not sure exactly what to be looking for in there.

[BBAdmin]

OK, lets take this one step at a time:

1. Check your SPAM filter for flagging of the ETP messages

2. Check your AV for flagging of .DAT files (these must be allowed)

3. You're running 4.1.0, so you could (should) service pack this installation up to SP4 (you can go straight to this version as service packs are cumulative).

4. What's your ping time between BES and Exchange server(s)? You don't want to be south of 100 MS.

Aside from this please let us know what mail server version you're running.

[Lemegeton]

Originally Posted by BBAdmin

OK, lets take this one step at a time:

1. Check your SPAM filter for flagging of the ETP messages

2. Check your AV for flagging of .DAT files (these must be allowed)

3. You're running 4.1.0, so you could (should) service pack this installation up to SP4 (you can go straight to this version as service packs are cumulative).

4. What's your ping time between BES and Exchange server(s)? You don't want to be south of 100 MS.

Aside from this please let us know what mail server version you're running.

1. no sign of the ETP messages
2. pretty sure .dat files are allowed but i will double check
3. will do this now
4. ping time is around 5ms

running Exchange 5.5

forgot to mention that synching works fine going through desktop manager
thanks for the advice.

[Lemegeton]

is there anywhere to download service pack 4 from other than blackberry.com. going to take 3-4 hours downloading from there

[BBAdmin]

PM me an email address and I'll send you a link to somewhere nice and quick!

[BBAdmin]

Actually screw it, I'll just PM you the link!!!

[Lemegeton]

thank you very much

[Lemegeton]

ok while waiting for the service pack i have noticed 2 different versions of cdo.dll are registered and as far as i know this could be causing a problem

my exchange server is running version 6.5.7651.61
the bes is running 6.5.6944.0

so should i move the exchange version to the bes and re-register

[BBAdmin]

Go with the most recent version - both should be the same. Copy the Exchange one to the BES and then register it using regsvr32

[Lemegeton]

ok i tried re-registering cdo.dll and then tried another activation and now i am getting the ETP messages sitting in my inbox and not going anywhere. help please

[Lemegeton]

Originally Posted by BBAdmin

Go with the most recent version - both should be the same. Copy the Exchange one to the BES and then register it using regsvr32

ok thats ok now i restarted the controller and dispatcher. still have the same issue though

activation goes through stage 1 . calendar synchs but then the process dies.

[BBAdmin]

ok i tried re-registering cdo.dll and then tried another activation and now i am getting the ETP messages sitting in my inbox and not going anywhere. help please

If the ETP mesage is being orphaned in the mailbox and not deleting it wither means that the DAT file is being striped or altered by your AV or, more likely, the BESAdmin doesn't have enough mailbox rights for the users. Check my pre-requisites thread here to double check your permissions:

http://www.blackberryforums.com/bes-...es-thread.html

[Lemegeton]

ok thats all sorted now with the ept messages but i have attempted the upgrade to 4.1.4 and get an error "db upgrade failed. error executing sql statement"
would this be the cause of the issues, a corrupt db entry or something. here is the install log


[30000] (09/18 15:31:07.724):{0x1218} SQL executed successfully
[30000] (09/18 15:31:07.724):{0x1218} SQL being executed:

/*
* Create the SyncNotesDocumentState table if it doesn't already exist
*/

if not exists (select name from sysobjects where name ='SyncNotesUserState' AND type = 'U')
begin

CREATE TABLE dbo.SyncNotesUserState
(
Id int IDENTITY (1,1) NOT FOR REPLICATION NOT NULL ,
UserConfigId int NOT NULL ,
LastCmdId int NOT NULL ,
AddressLastScan nchar (16) NULL ,
JournalLastScan nchar (16) NULL ,
TaskLastScan nchar (16) NULL ,
EmailFilterLastScan nchar (16) NULL ,
EmailSettingLastScan nchar (16) NULL ,
OutOfOfficeLastScan nchar (16) NULL ,
Lurnum timestamp NOT NULL
)

ALTER TABLE dbo.SyncNotesUserState ADD
CONSTRAINT IX_SyncNotesUserState UNIQUE CLUSTERED (UserConfigId),
CONSTRAINT PK_SyncNotesUserState PRIMARY KEY NONCLUSTERED (
[30000] (09/18 15:31:07.739):{0x1218} SQL executed successfully
[30000] (09/18 15:31:07.739):{0x1218} SQL being executed:


/*
* Create the DeletedUserConfig table if it doesn't already exist
*/
if not exists (select name from sysobjects where name ='DeletedUserConfig' AND type = 'U')
begin
CREATE TABLE dbo.DeletedUserConfig
(
Id int NOT NULL,
ServerConfigId int NOT NULL,
MailboxDN nvarchar(450) NULL,
DisplayName nvarchar(255) NULL,
DeviceType int NULL,
PIN varchar(50) NULL,
DeleteDateTime datetime DEFAULT GetUtcDate()
)

ALTER TABLE DeletedUserConfig ADD
CONSTRAINT PK_DeletedUserConfig PRIMARY KEY CLUSTERED (Id)
end
[30000] (09/18 15:31:07.739):{0x1218} SQL executed successfully
[30000] (09/18 15:31:07.739):{0x1218} SQL being executed:

/*
* Create the DeletedSyncDeviceMgmt table if it doesn't already exist
*/

exec sp_tableoption 'SyncBackupRestore', 'text in row', '1000'
[20000] (09/18 15:31:07.755):{0x1218} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: HY000 Native error: 823 Message: I/O error (bad page ID) detected during read at offset 0x00000003e82000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BESMgmt.mdf'.

[witchdoctor]

Hmm, looks like everyone here got stumped by that one!

I'm having the same issue, though not after an upgrade of the BES server, just in day-to-day stuff. I'm going through the DBCC CHECKDB command syntax for MS SQL Server right now, and it looks like I'll have to do a repair_allow_data_loss command...

...OK, back. So I logged into my SQL Server 2005 box and went into Enterprise Manager. I put the database into single user mode, then deselected the DB and quit Enterprise Manager. I then verified it was in single user mode with sp_who2, repaired the database with DBCC CHECKDB ('BESMgmt', REPAIR_ALLOW_DATA_LOSS), finding 42 errors, verified it was okay with DBCC CHECKDB ('BESMgmt'), and now I'm looking at ways to verify it "much more better."

...Looks like I could have used the DATA_PURITY option, but I'd prefer a 'lightest touch' approach to this. Now to take it online...

...it's up and running nicely now. No more crazy errors on the SQL box, either! Haven't tried an Enterprise Activation on a handheld yet, but we will see in the next week or so.

Hope this info is helpful to someone.

[centrekin]

After working on a users device, I am unable to get it to preform an Enterprise Activation. I have even set the EA password to "a" as opposed to my usual "1234" and I get the following error. (please see attachment.) This error pops up almost immediately after attempting to activate his device. However, he is not the only user this is happening to. As u can see, I cannot see the whole error here. I'm thinking this could be a database problem, but I'm not the DB guy here.

BES INFO
4.1.2
SQL Database
EXCHANGE 03 SP2

I'M NOTICING THIS ERROR QUITE A BIT IN THE EVENT LOGS AS WELL:
[DEVICE_SESSION:32C5F9B6:00f02b78] Service authentication verify failed. Error: 1 Service: S3865****

[centrekin]

Ok, so I take the exact same user and test an EA on a device I know that works... and it does a flawless EA right in front of me. Also, his previous device (before my test device) says that it completes and EA, but when he tries to send an email he gets the "Message Service Blocked". I'm pretty sure that that error has nothing to do with the BES, thus leading me to believe that somebody does not know what they are doing on my providers end.

[hdawg]

Contact your carrier and have them remove any BlackBerry plan from the account and re-add it to make sure there is a proper BES plan on the HH.

[centrekin]

Originally Posted by hdawg

Contact your carrier and have them remove any BlackBerry plan from the account and re-add it to make sure there is a proper BES plan on the HH.

Ok, I have found out what the problem is/was!!! Sprint made a horrible accusation that it was something on my BES server denying the handheld, when in fact neither of these devices were programmed correctly on Sprint's "BackEnd".. (If I had a dollar for every time they mentioned "BackEnd" I would be rich!) However this issue finally occurred on one my fellow Techs devices; thus giving me a little more faith in blackberry terminology.

I had him actually do a Diagnostic on the device (8830 FYI), and everything passed but PIN TO PIN. So I had him call Sprint and inform them that he could not send nor receive PIN messages, and not to get off the phone with them until he could.

After they fixed the "BackEnd" issue on his device, wouldn't you know it... EA's all over the place.. This has definitely been a learning experience and I hope that this helps somebody down the road.