View Single Post
Old 08-20-2007, 03:36 AM   #6
SimonMac
Talking BlackBerry Encyclopedia
 
SimonMac's Avatar
 
Join Date: Feb 2006
Location: Leeds, UK
Model: :(
PIN: Absent :(
Carrier: None :(
Posts: 451
Default

Not sure which is the db_install log but:

Code:
[30000] (08/16 16:20:27.875):{0x398} Processing file 4.1\UpgradeV20060502.sql
[30000] (08/16 16:20:27.875):{0x398} GetScriptDir - Scripts loading from: C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\
[30000] (08/16 16:20:27.875):{0x398} Replacing variables in [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\server\DBInstallScripts\SqlServer\4.1\UpgradeV20060502.sql]
[30000] (08/16 16:20:27.875):{0x398} Executing file [C:\Program Files\Research In Motion\BlackBerry Enterprise Server\ConfigUtil\db\AGDatabases\BES_SQL_Generated\UpgradeV20060502V070816162026.sql]
[30000] (08/16 16:20:27.875):{0x398} SQL being executed:
 USE "mdss"
[30000] (08/16 16:20:27.875):{0x398} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  Changed database context to 'mdss'.
[30000] (08/16 16:20:27.875):{0x398} SQL executed successfully
[30000] (08/16 16:20:27.875):{0x398} SQL being executed:
 
if not exists(select name from sysobjects where xtype='U' and name='FEATURE_VERSION')
begin
    CREATE TABLE dbo.FEATURE_VERSION
    (
      NAME varchar(256) NOT NULL,
      MIN_VERSION  varchar(128), 
      MAX_VERSION varchar(128), 
      CURRENT_VERSION varchar(128), 
      DEVICE_ID bigint NOT NULL,
        CONSTRAINT   PK_FEATURE_VER   PRIMARY KEY (NAME,DEVICE_ID)
    );
end
[30000] (08/16 16:20:27.875):{0x398} SQL executed successfully
[30000] (08/16 16:20:27.875):{0x398} SQL being executed:
 
if not exists(select name from sysobjects where xtype='F' and name='relationship28')
begin
    ALTER TABLE dbo.FEATURE_VERSION ADD CONSTRAINT relationship28 FOREIGN KEY (
    DEVICE_ID
    )
    REFERENCES DEVICE (
    DEVICE_ID
    );
end
[30000] (08/16 16:20:27.890):{0x398} SQL executed successfully
[30000] (08/16 16:20:27.890):{0x398} SQL being executed:
 
DECLARE @id bigint;
DECLARE tmp_cursor CURSOR FOR SELECT DEVICE_ID FROM DEVICE
OPEN tmp_cursor;
FETCH NEXT FROM tmp_cursor INTO @id;
WHILE @@FETCH_STATUS = 0
begin
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'Discovery', '1.1.0', '1.1.0', '1.1.0'); 
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'Provisioning', '1.1.0', '1.1.0', '1.1.0'); 
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'System', '1', '1', '1'); 
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'Transport', '1', '1', '1'); 
 INSERT INTO FEATURE_VERSION (DEVICE_ID, NAME, MIN_VERSION, MAX_VERSION, CURRENT_VERSION) 
                      VALUES (@id, 'Security', '1', '1', '1')
[20000] (08/16 16:20:27.890):{0x398} SQL Error Message from CBESDBInstaller::ExecuteSql.executeDirect: SQLSTATE: 23000 Native error: 2627 Message: Violation of PRIMARY KEY constraint 'PK_FEATURE_VER'. Cannot insert duplicate key in object 'FEATURE_VERSION'.
[30000] (08/16 16:20:27.890):{0x398} SQL Informational Message from CBESDBInstaller::ExecuteSql.executeDirect:  The statement has been terminated.
[30000] (08/16 16:20:34.249):{0x398} [PIPTOOL]: Exiting PIPTool from AGDBDlg.
====== END OF LOG ======
__________________
No longer have 15 Domino 6.5 Servers
No longer have 6 BES 4.1.3 Servers
No longer have 2613 Users
But still have the 1 Constant Headache?!?!

Offline   Reply With Quote