During a product version upgrade, or a maintenance update, of CA Service Desk Manager, the MDB would be updated.
The updates to the MDB may include new tables, new attributes of existing tables, or changes to data type of existing attributes of existing tables.
For example, when upgrading from CA Service Desk Manager 12.6 to CA Service Desk Manager 14.1, the MDB Upgrade step may attempt to run the following SQL command to increase the size of the SUMMARY attribute/column of the CALL_REQ table from 240 bytes to 255 bytes:
ALTER TABLE CALL_REQ MODIFY SUMMARY NVARCHAR2 ( 255 )
If, during the attempt to run the SQL command, an index exists on the SUMMARY attribute, then the MDB upgrade would fail with the appropriate code and message.
For an Oracle mdb database, in particular, you may receive "ORA-30556" and "Unable to modify column" messages, such as the following:
ORA-30556: either functional or bitmap join index is defined on the column to be modified
INFO - MDBTools_0339I - Upgrading object 'CALL_REQ.xml' from version '4.0' to version '5.0'
- Unable to modify column
The messages would be written to the MDB installation log file.