New Member
Join Date: Jul 2008
Model: 9860
PIN: N/A
Carrier: Orange FR
Posts: 7
|
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.
|