BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 05-03-2012, 10:39 AM   #1 (permalink)
New Member
 
Join Date: Jul 2008
Model: 9860
PIN: N/A
Carrier: Orange FR
Posts: 7
Post Thanks: 0
Thanked 0 Times in 0 Posts
Red face Invalid column name (SQL) on fresh install

Please Login to Remove!

Hello,

Installing BES 5.0.3 on a VM : W2008R2/SQL2008R2 ends up with an sql statement error :


[30000] (05/03 17:35:57.722):{0x754} SQL being executed:

create view dbo.vUserConfigStats as

SELECT s.MsgsForwarded, s.MsgsSent, s.MsgsPending, s.MsgsExpired, s.MsgsFiltered, s.MsgsFailed, s.Status, s.LastFwdTime, s.LastSentTime,
s.LastContactTime, s.LastMsgExpired, s.LastXPAction, sd.ServerTime, sd.ModelName, sd.PlatformVer, sd.AppsVer, sd.PhoneNumber, sd.IMEI,
sd.HomeNetwork, sd.VendorID, sd.PasswordEnabled, sd.HandheldConfigStatus, sd.HandheldConfigCheckTime, sd.DCID, sd.FlashSize,
sd.ITPolicyName, sd.ITPolicyTime, sd.IMSI, sd.ICCID, sd.ESN, u.*
FROM dbo.UserConfig u INNER JOIN
dbo.UserStats s ON u.Id = s.UserConfigId LEFT OUTER JOIN
dbo.SyncDeviceMgmtSummary sd ON u.Id = sd.UserConfigId
[20000] (05/03 17:35:57.722):{0x754} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Nom de colonne non valide : 'IMSI'." Native error = 207
[20000] (05/03 17:35:57.722):{0x754} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Nom de colonne non valide : 'ICCID'." Native error = 207
[20000] (05/03 17:35:57.722):{0x754} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Nom de colonne non valide : 'ESN'." Native error = 207

[20000] (05/03 17:35:57.722):{0x754} [CBESDBInstaller::executeRetryDDL] SQL Error for:

create view dbo.vUserConfigStats as

SELECT s.MsgsForwarded, s.MsgsSent, s.MsgsPending, s.MsgsExpired, s.MsgsFiltered, s.MsgsFailed, s.Status, s.LastFwdTime, s.LastSentTime,
s.LastContactTime, s.LastMsgExpired, s.LastXPAction, sd.ServerTime, sd.ModelName, sd.PlatformVer, sd.AppsVer, sd.PhoneNumber, sd.IMEI,
sd.HomeNetwork, sd.VendorID, sd.PasswordEnabled, sd.HandheldConfigStatus, sd.HandheldConfigCheckTime, sd.DCID, sd.FlashSize,
sd.ITPolicyName, sd.ITPolicyTime, sd.IMSI, sd.ICCID, sd.ESN, u.*
FROM dbo.UserConfig u INNER JOIN
dbo.UserStats s ON u.Id = s.UserConfigId LEFT OUTER JOIN
dbo.SyncDeviceMgmtSummary sd ON u.Id = sd.UserConfigId
[10000] (05/03 17:35:57.722):{0x754} An attempt to install the database was unsuccessful. An error occurred while executing an SQL statement.. Failed to create the database [BESMgmt]
.


The database BESmgmt has been created but when trying to gether sql infos from its column the installer stops.

Redid everything from scratch, same result with SQL2005 Express or SQL2008R2.
TCP/IP is enabled on SQL, IPv6 is disabled, port 1433 is static and ticked in the installer (the db is created anyway).
Besadmin has sysadmin rights, local admins, domain admin etc all according to BBY KBs.

Thanks for your patience in helping me sorting this out.
Offline  
Old 05-03-2012, 04:35 PM   #2 (permalink)
BlackBerry Extraordinaire
 
Join Date: Mar 2006
Model: 9700
Carrier: t-mobile Germany
Posts: 1,362
Post Thanks: 11
Thanked 69 Times in 66 Posts
Default Re: Invalid column name (SQL) on fresh install

First of all, the besadmin account should never be a member of the "domain administrators" group, Dont know if you just tried to say you did everything and then wrote just everything which came to your mind. But check this again.

About the SQL error:
I never experienced this. My first guess is, you maybe better use an US english system and try installing on this. French is a language with many accents, and " or ' can make a difference in SQL server syntax.
There is a KB from Microsoft about this:
PRB: Call to SQL Stored Procedure Returns 'Invalid Column Name'

Or, maybe uninstall all SQL server instances you need, uninstall the Microsoft native SQL client, set your language and region preferences to US english. Reboot the server and try a new install.

You also can try to use the "createdb.exe" utility in the installer folder, located in the "database" folder to create the besmgmt database:
Download a SQL express server matching your locale and install.
Read:
Create a BlackBerry Configuration Database - Upgrade Guide - BlackBerry Enterprise Server for Microsoft Exchange - 5.0

about how to customize the BESMgmt.cfg file
run the command: CreateDB.exe BESMgmt.cfg

Maybe, this makes a difference ?

Last edited by nobody7290 : 05-03-2012 at 04:38 PM.
Offline  
Old 05-04-2012, 03:31 PM   #3 (permalink)
New Member
 
Join Date: Jul 2008
Model: 9860
PIN: N/A
Carrier: Orange FR
Posts: 7
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Re: Invalid column name (SQL) on fresh install

I followed this procedure :

Create a BlackBerry Configuration Database
If the security required by your organization does not allow applications to have permissions to create or upgrade databases, you can run the CreateDB executable on the database server to create the BlackBerry® Configuration Database instead of using the setup application. After you create or upgrade the BlackBerry Configuration Database using the CreateDB executable, you can run the setup application using a Windows® account with minimum requirements to the database server.
Before you begin: Verify that the appropriate permissions are configured on the database server.

Log in to the computer that hosts the database server using a local administrator account or a Windows account that has SQL administrator permissions.
Copy the BlackBerry® Enterprise Server installation media to the database server that you want to configure as the host server for the BlackBerry Configuration Database.
Extract the contents to a folder on the computer.
Navigate to <extracted_folder>\Database.
Open the BesMgmt.cfg file in a text editor.
Change the file to include information that is specific to your organization's environment.
Save and close the file.
Open a command prompt window.
Change to <extracted_folder>\Database.
Type CreateDB.exe BESMgmt.cfg.



and restarted the whole installation process...then i was able to point to the BESmgmt and it did the trick.. go figure. (SQL2008R2)

Thanks for your answer.
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

Similar Threads for: Invalid column name (SQL) on fresh install
Thread Thread Starter Forum Replies Last Post
Security Update for SQL Server 2005 Service Pack 3 KB2494113 Will Not Install damianwalters RIM Software 1 12-09-2011 09:55 AM
4.1.6 upgrade failed - fresh install? GiantGuineaPig BES Admin Corner 11 03-11-2009 03:15 PM
DB Upgrade Failed. Error Executing SQL statement SimonMac BES Admin Corner 18 09-27-2007 08:03 AM
Database Backup...and restore. how? alwayzurboy BES Admin Corner 8 07-03-2007 07:24 AM
How to downgrade to OS 3.8 or fresh install 4.0? neelb General Legacy Device Discussion 3 03-19-2005 04:52 PM





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