Welcome to Port3101.org : Your BES Connection Mark forums read | View Forum Leaders
Port3101.org : Your BES Connection



Reply
LinkBack Thread Tools Display Modes
KB16302 - Unable to add BlackBerry MDS URL patterns to the BES
 
  #1 (permalink)  
Old 05-26-2009, 01:13 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB16302 - Unable to add BlackBerry MDS URL patterns to the BES

KB16302 - Unable to add BlackBerry MDS URL patterns to the BlackBerry Enterprise Server


Environment

  • BlackBerry® Enterprise Server for Microsoft® Exchange
  • Microsoft® SQL Server® 2000



Overview

When you add BlackBerry® Mobile Data System (BlackBerry MDS) URL patterns to the BlackBerry Manager, the following error message appears:
Application Error. Please contact support personnel.

The BlackBerry Manager also generates the following log entries:
[ODBCRecord:oCreateRecord] SQL error: [0x80040E14 Cannot insert explicit value for identity column in table 'MDSUrlPatterns' when IDENTITY_INSERT is set to OFF.] Source: [Microsoft OLE DB Provider for SQL Server] SQL State: [42000] NativeError: [544]

[ODBCRecord:oCreateRecord] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Cannot insert explicit value for identity column in table 'MDSUrlPatterns' when IDENTITY_INSERT is set to OFF."

[ODBCRecord:oCreateRecord] SQL = "SET NOCOUNT ON; INSERT INTO MDSUrlPatterns (serviceName, patternID, pattern, description) VALUES (?, ?, ?, ?) ; SELECT SCOPE_IDENTITY(); SET NOCOUNT OFF".




Cause

Identity Specification has been turned on for this table.



Resolution

To turn off Identity Specification, complete the following steps:
  1. Open Microsoft® SQL Server® Enterprise Manager.
  2. Expand Databases.
  3. Expand BESMgmt (or whichever database is being used by the BlackBerry Enterprise Server).
  4. Expand Tables.
  5. Expand dbo.MDSUrlPatterns.
  6. Expand Columns.
  7. Highlight PatternID, then right-click and select Modify.
  8. Verify that PatternID is currently highlighted.
  9. In the Column Properties area, expand Identity Specification.
  10. In the Identity Specification area, change the value of the Is Identity option to No.
  11. Click File > Save MDSUrlPatterns to save the file.
  12. Click Yes to confirm the save.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
Reply

Thread Tools
Display Modes

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

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
KB16418 - Unable to register BlackBerry MVS Client hdawg Featured BlackBerry KB Articles 0 07-30-2009 02:46 PM
KB10287 - Unable to add BlackBerry smartphone users in BlackBerry Manager hdawg Featured BlackBerry KB Articles 0 05-26-2009 09:56 AM
KB17644 - Unable to log in to the BlackBerry Administration Service or BlackBerry WDM hdawg Featured BlackBerry KB Articles 0 05-26-2009 01:02 AM
KB16130 - Unable to log in to BlackBerry WDM with BES for Domino hdawg Featured BlackBerry KB Articles 0 04-14-2009 07:24 PM
KB16467 - BlackBerry smartphone user is unable to access YouTube using BlackBerry hdawg Featured BlackBerry KB Articles 0 02-08-2009 12:48 PM


All times are GMT -4. The time now is 11:28 AM.
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2019, vBulletin Solutions, Inc.


 

SEO by vBSEO 3.3.2 PL2