Results 1 to 2 of 2

Alright, I'm about ready to give up on this thing. Everytime I get to the ... Server Admins forum

  1. #1
    begemanm's Avatar
    begemanm no está en línea Stack level 1
    Join Date
    Sep 2007
    Posts
    1

    Native error:207

    Advertisement



    Alright, I'm about ready to give up on this thing. Everytime I get to the database setting part of the setup I get the error "DB upgrade failed. Error executing SQL Statement." Below are the setup log, I've tried uninstalling sql and blackberry and starting over but it doesn't seem to make a difference. Anyone have any ideas?




    000] (11/27 02:36:23.515):{0xF58} SQL being executed:

    if exists (select name from syscolumns where object_name(id) = 'ITPolicyTemplate2' and name = 'ITPolicyItemData' and isnullable = 1)
    begin
    alter table ITPolicyTemplate2 alter column ITPolicyItemData VARCHAR(2048) not null
    alter table ITPolicyTemplate2 ADD
    CONSTRAINT DF_ITPolicyTemplate2_ITPolicyItemData DEFAULT ('') FOR ITPolicyItemData
    end
    [30000] (11/27 02:36:23.515):{0xF58} SQL executed successfully
    [30000] (11/27 02:36:23.515):{0xF58} SQL being executed:

    /*
    * Create the ITPolicyTemplate table if it doesn't already exist. This table will no
    * longer be used, but will continue to be created to avoid database errors when running
    * 3.5 BES Management consoles against the 3.6 database.
    */
    IF EXISTS (SELECT name FROM sysobjects WHERE name = 'ITPolicyTemplate' AND type = 'U')
    drop TABLE ITPolicyTemplate
    [30000] (11/27 02:36:23.515):{0xF58} SQL executed successfully
    [30000] (11/27 02:36:23.515):{0xF58} SQL being executed:

    /*
    * Delete the BESRouter table if it exists - not used anymore
    */
    IF EXISTS (SELECT name FROM sysobjects WHERE name = 'BESRouter' AND type = 'U')
    DROP TABLE BESRouter
    [30000] (11/27 02:36:23.531):{0xF58} SQL executed successfully
    [30000] (11/27 02:36:23.531):{0xF58} SQL being executed:

    /*
    * create indexes implicitly via constraints/primary key
    * cluster by name
    */
    if not exists (select name from sysobjects where name='IX_ServerConfig_Name' and xtype='UQ')
    ALTER TABLE ServerConfig ADD
    CONSTRAINT IX_ServerConfig_Name UNIQUE CLUSTERED (ServiceName)
    if not exists (select name from sysobjects where name='PK_ServerConfig' and xtype='PK')
    ALTER TABLE ServerConfig ADD
    CONSTRAINT PK_ServerConfig PRIMARY KEY NONCLUSTERED (id)
    [30000] (11/27 02:36:23.531):{0xF58} SQL executed successfully
    [30000] (11/27 02:36:23.531):{0xF58} 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] (11/27 02:36:23.546):{0xF58} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'RouterLinkStatus'.
    [20000] (11/27 02:36:23.546):{0xF58} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsExpired'.
    [20000] (11/27 02:36:23.546):{0xF58} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsFiltered'.
    [20000] (11/27 02:36:23.546):{0xF58} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsForwarded'.
    [20000] (11/27 02:36:23.546):{0xF58} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsPending'.
    [20000] (11/27 02:36:23.546):{0xF58} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 42S22 Native error: 207 Message: Invalid column name 'MsgsSent'.

  2. #2
    STL8700's Avatar
    STL8700 no está en línea Stack level 2
    Join Date
    Sep 2006
    Posts
    92
    Anyone have any advice on this issue? I am having the exact same problem. Sorry to bump such an old thread, but my install log is almost identical to the above post...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •