Sign In with your
Trend Micro Account
Need Help?
Need More Help?

Create a technical support case if you need further support.

"Process failed with exception..." error message appears when upgrading to Policy Server 6.0

    • Updated:
    • 5 Sep 2017
    • Product/Version:
    • Endpoint Encryption 5.0
    • Platform:
    • Windows 2008 Server R2
    • Windows 2012 Standard
    • Windows 2012 Standard R2
Summary

When upgrading the Policy Server to version 6.0, the following error message is displayed:

Process failed with exception "The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.MobileArmorUser' and the index name 'OneUserOneDomain'. The duplicate key value is (<Name of user>, ). Could not create constraint. See previous errors..."

Details
Public

This issue occurs when the upgrade detects a duplicate user in dbo.MobileArmorUser.

To resolve this issue, manually delete the duplicate user from dbo.MobileArmorUser.

  1. Take note of the duplicate user that is stated in the error:

    "The duplicate key value is (, )"

  2. Log on to the SQL Management Studio.
  3. Select the SQL database and navigate to Databases > MobileArmorDB.
  4. Right-click on MobileArmorDB then select Tasks > Back Up.
  5. Back up the database.
  6. Select the SQL database and navigate to Databases > MobileArmorDB > Tables.
  7. Click on New Query then type in the following:

    select * from dbo.MobileArmorUser where UserID = '<Name of duplicate user>'

  8. Take note of the duplicate user's "UserIndex".
  9. Click on New Query again then type in the following:

    delete from dbo.MobileArmorUser where UserIndex =  '<Duplicate user's UserIndex>'

  10. Close the SQL Management Studio then re-run the Policy Server Installer.
Premium
Internal
Rating:
Category:
Troubleshoot; Install; Upgrade
Solution Id:
1118095
Feedback
Did this article help you?

Thank you for your feedback!

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


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.