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



Reply
LinkBack Thread Tools Display Modes
KB04953 - DB Upgrade Failed. Error Executing SQL statement.
 
  #1 (permalink)  
Old 05-26-2009, 01:12 PM
hdawg's Avatar
Proprietor
 
Join Date: Nov 2008
Posts: 2,257
Blog Entries: 147
Default KB04953 - DB Upgrade Failed. Error Executing SQL statement.

Environment

  • BlackBerry® Enterprise Server software version 4.1 for Microsoft® Exchange
  • BlackBerry® Mobile Data System (BlackBerry MDS)
  • Microsoft® SQL Server®
  • Microsoft® SQL Server® Desktop Engine (MSDE)
  • SDR94195



Overview

After upgrading to BlackBerry Enterprise Server software version 4.1, the BlackBerry MDS Services database is not created during the BlackBerry MDS installation process. The following error message is displayed:
DB Upgrade Failed. Error Executing SQL statement.



Cause

Summary of Causes

The issue may be caused by one of the following:
  1. One or both of the MDSS and MDSS_Dis databases already exist.
  2. Mixed Mode authentication is not turned on.
  3. The account used to install the BlackBerry Enterprise Server software is not assigned the role of System Administrator.
  4. A duplicate job beginning with RIM exists, for example RIMPurgeHistoryBESMgmt.
  5. The DefaultData and DefaultLog registry value paths are blank or do not exist.
  6. The Microsoft SQL Server has been configured to be case sensitive.



Resolution

Cause 1

One or both of the MDSS and MDSS_Dis databases already exist.
Resolution

Warning: Modifying databases used by the BlackBerry Enterprise Server can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.
Depending on the environment, delete the existing databases from the MSDE or Microsoft SQL Server and continue the installation process. This should create the BlackBerry MDS Services database.

Cause 2

Mixed Mode authentication is not turned on the MSDE or Microsoft SQL Server.
Resolution

Warning: Modifying databases used by the BlackBerry Enterprise Server can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.
Complete the following steps:
  1. Turn on Mixed Mode authentication.
  2. Depending on the environment, delete the existing databases from the MSDE or Microsoft SQL Server and continue the installation process. This should create the BlackBerry MDS Services database.
For more information about Mixed Mode authentication, see article 325022 on the Microsoft Knowledge Base.

Cause 3

The account used to install the BlackBerry Enterprise Server software is not assigned the role of System Administrator on the MSDE or Microsoft SQL Server. Note: SQL permission roles list this as sysadmin.
Resolution

Complete the following steps:
  1. Assign the role of System Administrator to the account used for installation purposes.
  2. Depending on the environment, delete the existing databases from the MSDE or Microsoft SQL Server and continue the installation process. This should create the BlackBerry MDS Services database.

SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name

Cause 4

A duplicate job beginning with RIM exists, for example RIMPurgeHistoryBESMgmt. The following entries appear in the setup<date>.log file located in <drive>:\Program Files\Research In Motion\BlackBerry Enterprise Server\logs\installer:
SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42000 Native error: 14293 Message: There are two or more jobs named 'RIM<job_name>'. Specify @job_id instead of @job_name to uniquely identify the job
The duplicate job exists because there is a new machine name for the MDSE or Microsoft SQL Server.
To resolve this issue, complete one of the following resolutions:
Resolution 1

Warning: Modifying databases used by the BlackBerry Enterprise Server can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.
If SQL Enterprise Manager is installed, complete the following steps:
  1. Open SQL Enterprise Manager.
  2. Expand the BlackBerry Enterprise Server hosting the BlackBerry Configuration Database.
  3. Go to Management/SQL Server Agent and select Jobs.
  4. Delete all job instances that begin with RIM.
  5. Restart the installation process.
If SQL Enterprise Manager is not installed, complete the following steps:
  1. Connect to the BlackBerry Configuration Database.
  2. At a command prompt, type the following command:
    • For Windows Trusted Authentication
    osql -S <BlackBerry_Enterprise_Server_name> -E
    • For SQL Authentication
    osql -S <BlackBerry_Enterprise_Server_name> -U <user_name> -P <password>
  3. To remove the duplicate job, type the following commands in the specified order:
    1> use msdb
    2> go
    1> select job_id, name from sysjobs
    2> where name = 'RIM<job_name>'
    3> go The results of the query are returned.
    1> EXEC sp_delete_job @job_id = '<id string from the above query>'

    2> go
  4. Repeat the previous step for all jobs starting with RIM.
  5. Close the command prompt.
Resolution 2

Change the computer name of the MSDE or Microsoft SQL Server back to the original name. For more information, see the Microsoft Knowledge Base.
Resolution 3

Warning: Modifying databases used by the BlackBerry Enterprise Server can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.
Back up the original BlackBerry Configuration Database and restore it with a different name, and then perform the BlackBerry Enterprise Server upgrade again.
  1. Connect to the BlackBerry Configuration Database.
  2. At the command prompt, type the following commands in the specified order:
    1> backup database <database_name> to disk = 'c:\<filename>'
    2> go
    1> restore database <database_name>2 from disk = 'c:\<filename>' with recovery, replace
    2> go
  3. Upgrade the BlackBerry Enterprise Server software version again.

Cause 5

The DefaultData and DefaultLog registry values that correspond to the default data directory and the default log directory exist, but the folder paths in the registry values are blank or do not exist.
Resolution
Warning: The procedures in this article involve modifying databases used by the BlackBerry Enterprise Server. This can cause irreparable damage, resulting in unexpected server behavior or service failure. Back up the databases prior to implementing any changes.
For more information on creating a Microsoft SQL Server database, see the Microsoft Knowledge Base.

Cause 6

The Microsoft SQL Server has been configured to be case sensitive.
Note: To see if the Microsoft SQL Server is case sensitive, see KB04785.
Resolution
Re-install the Microsoft SQL Server or create a new Microsoft SQL Server instance that is not case sensitive.
__________________
http://blog.port3101.org/hdawg/
Reply With Quote
Sponsored Links
Reply

Bookmarks

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
KB03569 - DB Upgrade Failed. Error Executing SQL statement hdawg Featured BlackBerry KB Articles 0 09-14-2009 09:50 PM
KB18743 - "Failed (error=5406) to convert XML record" error occurs after 5.0 Upgrade hdawg Featured BlackBerry KB Articles 0 07-30-2009 03:23 PM
KB14246 - "Failed to connect to server. Error: 0x80070422" error message hdawg Featured BlackBerry KB Articles 0 06-18-2009 11:08 AM
KB16184 - DB Upgrade Failed error when upgrading BESMgmr database during BES upgrade hdawg Featured BlackBerry KB Articles 0 01-14-2009 07:44 PM
KB16453 - Error occurred executing a SQL statement when attempting to upgrade.... Si Featured BlackBerry KB Articles 0 11-25-2008 10:58 AM


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


 

SEO by vBSEO 3.3.2 PL2