05-26-2009, 01:13 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,238
|
|
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:
- Open Microsoft® SQL Server® Enterprise Manager.
- Expand Databases.
- Expand BESMgmt (or whichever database is being used by the BlackBerry Enterprise Server).
- Expand Tables.
- Expand dbo.MDSUrlPatterns.
- Expand Columns.
- Highlight PatternID, then right-click and select Modify.
- Verify that PatternID is currently highlighted.
- In the Column Properties area, expand Identity Specification.
- In the Identity Specification area, change the value of the Is Identity option to No.
- Click File > Save MDSUrlPatterns to save the file.
- Click Yes to confirm the save.
__________________
http://blog.port3101.org/hdawg/
The views expressed by me on Port3101 and its affiliated sites are my own and do not necessarily reflect the views of my employer.
|
Linear Mode
