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'.
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.
Release : 17.1
Component : SVC DESK UPGRADE
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.
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.