MDBTools install error=3 when upgrading to CA Service Management 17.X.
Article ID: 129511
Updated On:
Products
Issue/Introduction
Install.log:
[CommonProcessUtilities] 03-14,10:51:51 Loading mdb...
[CommonProcessUtilities] using Service_Desk
[CommonProcessUtilities] 03-14,10:52:43 MDBTools install error=3
[CommonProcessUtilities] 03-14,10:52:43 Setupmdb exit /B return code=3
[ActiveProcessHolder] Exit Monitor. Process ID (PID): 4788
[CommonProcessUtilities] Command terminated with error
[SDMPatch] Copying log files from E:\Soft\CA\Service Desk Manager\patches\cum2 to C:\Users\pxh000\AppData\Local\Temp\7\casm\Patching\GOA_20190314_104301\SDM_MDB_20190314_105144
Install_mdb.log:
03-14,10:52:42 INFO - MDBTools_0306I - SQL text:
03-14,10:52:42 INFO - IF EXISTS (select * from syscolumns where id=object_id('evt') and name='sym')
03-14,10:52:42 INFO - BEGIN
03-14,10:52:42 INFO - ALTER TABLE [evt] ALTER COLUMN [sym] nvarchar ( 100 ) COLLATE Latin1_General_CI_AS NOT NULL
03-14,10:52:42 INFO - END
Update sql failed:IF EXISTS (select * from syscolumns where id=object_id('evt') and name='sym')
BEGIN
ALTER TABLE [evt] ALTER COLUMN [sym] nvarchar ( 100 ) COLLATE Latin1_General_CI_AS NOT NULL
END
03-14,10:52:42 DEBUG - The index 'evt_x0' is dependent on column 'sym'.
03-14,10:52:42 INFO - MDBTools_0308I - Installation of last object failed, requeuing it to the end of the list.
03-14,10:52:42 INFO - MDBTools_0305E - Error processing table 'evt.xml'; details follow:
03-14,10:52:42 ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: The index 'evt_x0' is dependent on column 'sym'.
com.microsoft.sqlserver.jdbc.SQLServerException: The index 'evt_x0' is dependent on column 'sym'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:799)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:696)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:669)
at com.ca.mdbtools.DriverApp.updateDB(DriverApp.java:2697)
at com.ca.mdbtools.DriverApp.apply(DriverApp.java:2256)
at com.ca.mdbtools.DriverApp.installSchemaDriver(DriverApp.java:1085)
at com.ca.mdbtools.Utilities.run(Utilities.java:1678)
at com.ca.mdbtools.Utilities.main(Utilities.java:1042)
03-14,10:52:42 ERROR - MDBTools_0307E - SQL text:
03-14,10:52:42 ERROR - IF EXISTS (select * from syscolumns where id=object_id('evt') and name='sym')
03-14,10:52:42 ERROR - BEGIN
03-14,10:52:42 ERROR - ALTER TABLE [evt] ALTER COLUMN [sym] nvarchar ( 100 ) COLLATE Latin1_General_CI_AS NOT NULL
03-14,10:52:42 ERROR - END
03-14,10:52:42 ERROR - MDBTools_0309E - DBDriver failed to install!
03-14,10:52:42 INFO - MDBTools_0104I - Total time: 0H:0M:50S.
03-14,10:52:43 MDBTools install error=3
03-14,10:52:43 Setupmdb exit /B return code=3
Environment
CA Service Management 17.X
Cause
This problem occurs due to the index 'evt_x0' being present in the 'evt' table.
Resolution
Follow the steps below:
(1) Go to SQL Management Studio and drop the index is causing the issue;
DROP INDEX [evt].evt_x0;
Or you can delete it manually:
(2) Run the installer again;
(3) Go to SQL Management Studio and create the index again;
CREATE UNIQUE INDEX [evt_x0] ON [evt] (
[sym],
[tenant]
)
Additional Information
Make sure you have a backup of the MDB you are going to upgrade.
Feedback
