BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-31-2007, 03:54 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default COM error - any suggestions?

Please Login to Remove!

We're running BES 4.1.3 for Lotus Notes. BESMgmt is on a separate SQL2005 server. A few times a day I see the following error message on the Notes console, but apparently nothing bad seems to come out of it. Does anyone know why it's showing up and what to do to stop it?
Thanks in advance!
[20000] (05/31 14:57:35.424):{0x1BCC} RIMGateUserCached2::SaveStats: COM Error 0x80004005 - Source: 'Microsoft OLE DB Provider for SQL Server' - Description 'Connection failure' - Command ' update UserStats set MsgsForwarded = ?, MsgsSent = ?, MsgsPending = ?, MsgsExpired = ?, MsgsFiltered = ?, MsgsFailed = ?, Status = ?, LastFwdTime = ?, LastSentTime = ?, LastContactTime = ?, LastXPAction = ? where UserConfigId = ?'
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005
Offline  
Old 05-31-2007, 08:14 PM   #2 (permalink)
BlackBerry Extraordinaire
 
noname's Avatar
 
Join Date: Sep 2005
Location: Congested Islet of "Foreign Talents" (> 45% of workforce) - Singapore.
Model: Z10
OS: 10.0.0
PIN: NUKE(PAP)
Carrier: Singtel
Posts: 1,504
Post Thanks: 6
Thanked 9 Times in 9 Posts
Default

...Source: 'Microsoft OLE DB Provider for SQL Server' - Description 'Connection failure'...

Simply translate to => Your BES was not able to have a connection to the remote SQL server during this time - [20000] (05/31 14:57:35.424).

Check if there was network issue or SQL server problem during the above time.
__________________
Native but 4th class citizen of a nation governed by idiots who import congestions & contention.
Offline  
Old 06-01-2007, 08:40 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: Jan 2007
Location: Tallahassee, FL USA
Model: 8830
Carrier: Verizon Wireless
Posts: 104
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes, of course you are right in that it is a SQL connection problem. I should have mentioned that I knew that, BUT...
a) the SQL server itself does not show any errors at all
AND very curiously
b) the message ALWAYS comes up for "update UserStats set ...". It would seem to me that if it was a random connection problem, the complain would show for other commands, but it is ONLY for "update UserStats".
It shows up between 5-10 times an hour.
Regards,
__________________
Jose
BES 4.1.6, Domino 6.5.4, remote SQL2005
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





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