This article can be used to recover from a corrupt user preference entry in the galaxy database.
- Author: Joseph Hefner
- Published: 09/17/2015
- Applies to: Application Server 3.1 or later
In order to confirm you are seeing this issue, the first step is to try logging in as another user to see if the problem goes away. If security is not disabled, it may be the default user in which case you will need to enable security and add a new user to test with. Another indication of the problem is to look for the error message below in the SMC Log Viewer:
Exception when loading snapin-
ArchestrA.IDE.BrowserControls.GraphicBrowserControl,There is an error in XML document (6, 19).
*Note - Before going through the steps below make sure you have a good backup of the galaxy
To resolve this you co go through the steps below:
1) On the Galaxy Repository machine, open SQL Server Management Studio and locate the Galaxy database. In this case the Galaxy database is called "Test".
2) Expand the Tables and locate the dbo.user_profile. Right click it and choose "Select Top 1000 Rows"
3) Identify the user_profile_id for the user that is seeing this problem. In this case, it is the Default User and the user_profile_id is 3.
4) Click the "New Query" button :
5) Execute the query below against the Galaxy database to clear out the custom user preferences for the user. Make sure to substitute the "3" below with the user_profile_id returned in step 3 above:
delete from user_preferences where user_profile_id = 3