How to fix the error "MDBTools_0309E - DBDriver failed to install" that occurs while running the setupmdb command for installing a MDB Patch?

Document ID : KB000031110
Last Modified Date : 14/03/2019
Show Technical Document Details
Issue:
From install.log:

"MDBTools_0309E - DBDriver failed to install" that occurs while running the setupmdb command for installing a MDB Patch.

SETUPMDB log shows:

ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: The index 'evt_x0' is dependent on column 'sym'.
Environment:
CA Service Desk 14.1
Cause:
This problem occurs due to the index 'evt_x0' being present on the 'evt' table in the MDB.
Resolution:
  1. Login to SQL Management Studio as a SQL administrator;
  2. Expand MDB Database;
  3. Expand the table dbo.evt -> Expand Indexes -> Right-click on evt_x0 -> Select Script table as -> Create to -> Copy the complete CREATE INDEX into a text editor;
  4. Right-click on the 'evt_x0' index and delete;
  5. Run SETUPMDB to install the MDB patch.

Upon successful completion of SETUPMDB, go back to the SQL Query Window and paste the copied 'evt_x0' index saved in step #1 above and execute the query to recreate the 'evt_x0' index..