Unable to order items in Edit Views while using Asset page

Products

• IT Management Suite
• Asset Management Solution

Issue/Introduction

Unable to order items in Edit Views (for example, under Manage > Computers > Select a computer > right-click > Edit > Change view on the top-right corner to "Manage Views"):

You get error entry:

[ConstraintException: Column 'awc_dkf' is constrained to be unique. Value '2' is already present.] System.Data.UniqueConstraint.CheckConstraint(DataRow row, DataRowAction action) +2117446 System.Data.DataTable.RaiseRowChanging(DataRowChangeEventArgs args, DataRow eRow, DataRowAction eAction, Boolean fireEvent) +316 System.Data.DataTable.SetNewRecordWorker(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge, Boolean suppressEnsurePropertyChanged, Int32 position, Boolean fireEvent, Exception& deferredException) +1669 System.Data.DataRow.EndEdit() +150 Altiris.AssetContractCommon.Web.Manager.ModifyEditFilters.SwapGridControlRows(Int32 index1, Int32 index2) +544 Altiris.AssetContractCommon.Web.Manager.ModifyEditFilters.OnMoveUp() +856 ComponentArt.Web.UI.Menu.OnItemSelected(MenuItemEventArgs e) +49 ComponentArt.Web.UI.Menu.HandlePostback(String stringArgument) +407 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5028

ISSUE REPRODUCTION

• Open any report containing computer resources
• Right-click > Edit
• In the "EditCreateResources" page choose View > Manage Views in the right top corner

• Pick any existing View which populates Selected Items
• Attempt to re-order any item and observe an error:

 

Environment

ITMS 8.7 RTM (GA)

Cause

Known Issue

Resolution

This issue has been fixed in our ITMS 8.7 RU1 Release.

A pointfix is available for those customers using 8.7 RTM version. See KB 261271 "CUMULATIVE POST ITMS 8.7 GA POINT FIXES"