Unable to use current database after upgrading Mobile Security (TMMS) from version 9.0 to 9.2

- Updated:
- 24 Nov 2016
- Product/Version:
- Mobile Security for Enterprise 9.0
- Mobile Security for Enterprise 9.1
- Mobile Security for Enterprise 9.2
- Platform:
- Android 2.3 Gingerbread
- Android 3.x Honeycomb
- Android 4.0 Ice Cream Sandwich
- Android 4.1 Jellybean
- Android 4.2 Jellybean
- Android 4.3 Jellybean
- iOS 5.0+
- iOS 6.0+
- iOS 7.0+
- Windows Phone 8.0

Summary

An error message appears when opening the TMMS Management Console after upgrade from version 9.0 to 9.2:

This error occurs when upgrading the database schema from 1.4.22 to 1.5.16:

Failed to alter table [Policy_Wtp]'s column [AutoFilterEnabled] because the database upgrade only half done.

Details

Before doing changes, please back up or take a snapshot of the server.

Follow these steps to resolve the problem:

Stop the Management Server service.
Open the SQL Management Server Studio.
Execute the SQL, solve_db_upgrade.sql to manually complete the database upgrade.
Start the Management Server service.

Rating:

Category:

Troubleshoot

Solution Id:

1110527

Feedback

Did this article help you?

Thank you for your feedback!

What was the problem with this article?

The image(s) in the article did not display properly.

The article did not provide detailed procedure.

The article is hard to understand and follow.

The video did not play properly.

The article did not resolve my issue.

Others. Please specify.

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:

We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

Thanks for voting.

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:

We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.