05-26-2009, 01:12 PM
|
 |
Proprietor
|
|
Join Date: Nov 2008
Posts: 2,238
|
|
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:
- One or both of the MDSS and MDSS_Dis databases already exist.
- Mixed Mode authentication is not turned on.
- The account used to install the BlackBerry Enterprise Server software is not assigned the role of System Administrator.
- A duplicate job beginning with RIM exists, for example RIMPurgeHistoryBESMgmt.
- The DefaultData and DefaultLog registry value paths are blank or do not exist.
- 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:
- Turn on Mixed Mode authentication.
- 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:
- Assign the role of System Administrator to the account used for installation purposes.
- 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:
- Open SQL Enterprise Manager.
- Expand the BlackBerry Enterprise Server hosting the BlackBerry Configuration Database.
- Go to Management/SQL Server Agent and select Jobs.
- Delete all job instances that begin with RIM.
- Restart the installation process.
If SQL Enterprise Manager is not installed, complete the following steps:
- Connect to the BlackBerry Configuration Database.
- At a command prompt, type the following command:
- For Windows Trusted Authentication
osql -S <BlackBerry_Enterprise_Server_name> -E osql -S <BlackBerry_Enterprise_Server_name> -U <user_name> -P <password>
- 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
- Repeat the previous step for all jobs starting with RIM.
- 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.
- Connect to the BlackBerry Configuration Database.
- 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
- 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/
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
