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

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

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 17.X

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