BlackBerry Forums Support Community
              

Closed Thread
 
LinkBack Thread Tools
Old 08-10-2005, 12:00 PM   #1 (permalink)
New Member
 
Join Date: Aug 2005
Model: 7100t
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES 4 SQL msgnum

Please Login to Remove!

We found an interesting situation during our testing of the BES 4 installation. I've spoken to BlackBerry about it and they hadn't heard of this issue. I'd like to find out if has affected others.

During the install of BES4 against a remote SQL database, a sql script is run named errors.sql that contains the code below. The script looks for sql messages numbers in the 60000 range such as 60003 and deletes them if they exist, then adds in BES errors.

Our problem is that we have existing systems that use the same error numbers. For example, one of our database monitoring scripts uses one of these numbers to log an application entry after unsuccessful backups. HP OVO picks up the error (by the message text, not the number) in the app log and fires an alarm in the HP console. So, if we were to install BES4 on our production db server, a failed backup would now generate a "Unable to add MDS Mapping. Duplicate Pin: [%d]" error to the event log instead of "%s backup failed" and HPOVO would not fire any alarms for our dba to fix the backup issue. In addition, our dba would wonder what MDS Mappings and duplicate PIN errors mean.

Could this really be the first time that the BES errors have overwritten errors or have others seen this issue?

In my opinion, RIM should update the SQL script to find an unused number rather than overwrite an existing code. However, their support staff could only suggest that I send a request to [email address], change to using an MSDE db (which would break our BES hot-spare), or install a dedicated db server for the BES db.

I'm planning to send to bbsuggestions, but I'd like to get an idea of how big or small this issue might be.

Any thoughts would be appreciated.

thanks


------------------ code snip from errors.sql -------------
USE master
GO

PRINT 'Adding error messages to the database'
SET NOCOUNT ON
/* BESAgent errors */
IF EXISTS (SELECT error FROM sysmessages
WHERE error = 60002)
EXEC sp_dropmessage @msgnum = 60002, @lang = 'us_english'
GO
EXEC sp_addmessage @msgnum = 60002, @severity = 16,
@msgtext = N'Unable to add new BlackBerry Agent "%s" AgentID=%d Machine Name=%s',
@lang = 'us_english'
---------------------
Offline  
Old 08-10-2005, 05:52 PM   #2 (permalink)
Talking BlackBerry Encyclopedia
 
Join Date: May 2005
Model: 7100
Carrier: T-Mobile
Posts: 299
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

I hope you're joking about the bbsuggestions address. Changing the range RIM uses might not be the best case but it should use other codes if it detects the defaults are already in use. I'd get RIM to file a bug report or something like that.
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

Hp Agilent Keysight 3499A Switch Control System 5-Slot Mainframe Chassis
$79.0
Hp Agilent Keysight 3499A Switch Control System 5-Slot Mainframe Chassis   pictureHP 70001A Mainframe W/ HP 70420A Test Set W/ Opt E5501B #440 SN: US37039114 AUC
$300.0
HP 70001A Mainframe W/ HP 70420A Test Set W/ Opt E5501B #440 SN: US37039114 AUC pictureTektronix TM503 AM503 Power Module Mainframe Current Probe Amplifier No Probes
$399.0
Tektronix TM503 AM503 Power Module Mainframe Current Probe Amplifier No Probes pictureTektronix TM503 3 Slot Mainframe AA 501 Distortion Analyzer DM 502 Multimeter
$455.0
Tektronix TM503 3 Slot Mainframe AA 501 Distortion Analyzer DM 502 Multimeter picture8164A Lighwave Measurement System Mainframe HP Agilent Keysight
$2800.0
8164A Lighwave Measurement System Mainframe HP Agilent Keysight picture






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