Statistics related error during migration to SDM

Products

• CA Service Desk Manager

Issue/Introduction

When trying to upgrade from 17.1 to 17.3 getting an error when applying the MDB patch.  The error presented is as follows in the install_mdb.log:

01-26,18:51:08 ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: The statistics 'service_impact' is dependent on column 'service_impact'.
com.microsoft.sqlserver.jdbc.SQLServerException: The statistics 'service_impact' is dependent on column 'service_impact'.

Cause

This was due to a third party Statistic entry named 'service_impact' which was interfering with the Alter DB statement on column 'service_impact' in table ci_twa_ci.  The Statistic entry named 'service_impact' is not native to SDM and needs to be removed. 

Environment

Release : 17.1

Component : SVC DESK UPGRADE

Resolution

Remove the given Statistic entry from the associated table, in this case, table ci_twa_ci.  There will be a log entry following the above entry that references the ALTER SQL command and the table being modified.

Additional Information

We advise against making direct changes to the backend MDB database as SDM relies on the database operating under the assumption no other applications are making DB level changes.