Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

Reply
New Member
Posts: 1
Registered: ‎02-20-2009
My Device: Not Specified

Can not get remote SQL database to install during setup.

 

I am installing BPS on a windows 2003 server using an existing SQL app server.  The database appears to be installed but then the setup asks to backup database and perform upgrade.  In the install logs I get the following errors at the end of the log.

[30000] (02/20 09:39:29.702):{0xFD8} SQL being executed:
 


/*
 * Migrate the BESAgent table if it exists and delete it - not used anymore
 */
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'BESAgent' AND type = 'U')
BEGIN
  declare @ServerConfigId int
  declare @BESAgentName varchar(255)
  declare @BESAgentMachineName varchar(255)
  declare @MailServerName varchar(255)
  declare @ServerDN varchar(3000)
  declare @LinkStatus smallint
  declare @SRPid varchar(255)
  declare @MsgsExpired int
  declare @MsgsFiltered int
  declare @MsgsForwarded int
  declare @MsgsPending int
  declare @MsgsSent int
  declare @AdminAcctName varchar(255)
  declare @GlobalExternalServices smallint

  DECLARE copy_cursor CURSOR FOR
  select BESAgentName, BESAgentMachineName, MailServerName,
  ServerDN, RouterLinkStatus,
  SRPid, MsgsExpired,
   
[20000] (02/20 09:39:29.734):{0xFD8} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'RouterLinkStatus'.
[20000] (02/20 09:39:29.734):{0xFD8} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsExpired'.
[20000] (02/20 09:39:29.734):{0xFD8} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsFiltered'.
[20000] (02/20 09:39:29.734):{0xFD8} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsForwarded'.
[20000] (02/20 09:39:29.734):{0xFD8} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsPending'.
[20000] (02/20 09:39:29.734):{0xFD8} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsSent'.
[30000] (02/20 09:39:38.280):{0xFD8} [PIPTOOL]: Exiting PIPTool from DBInfoDlg.
Highlighted
Guru III
Posts: 32,127
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry PRIV, Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook,BT Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: Can not get remote SQL database to install during setup.

Did you run the creatdb.exe on the SQL server before the install?

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V