Invalid column name (SQL) on fresh install
 

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.

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 ?

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.