Console error while resizing columns: "An error occurred while refreshing. Check the Altiris log for more information."

Products

• IT Management Suite

Issue/Introduction

You may observe that when you try to resize any columns in a task, the SMP (Symantec Management Platform) console will throw an error in some occasions.

The issue happens when you try to resize the description or start time columns etc.... 

Note: You found that if you are logged into the SMP server as the service ID (AppID) you can resize them with no issue but if you login as user that is a Symantec admin it still causes the issue. If you login as any other user besides the service ID (AppID), the issue will replicate.

------------------------------------------------
[1] 4/14/2016 12:22:33 PM (w3wp)
Altiris.TaskManagement.UI.Controls.Grid.AltirisGridControl.LoadUserSettings
Error while restoring personalization properties
Input string was not in a correct format.
   [System.FormatException @ mscorlib]
-----------------------------------------------

Environment

ITMS 7.x, 8.x

Cause

Known issue. Possible corruption on "UserSettings" table.
 

Resolution

Run the following query and reopen the SMP Console with the desired account:

TRUNCATE table UserSettings