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 ======