Problem:
Client receiving failure/crash when opening a workspace in Enterprise Analyzer. Other users do not have the error and the user receives the crash on multiple machines. The error message returned can be generic with no specific details or reasons for the crash.
Resolution:
If only a specific single user is receiving the crash, the error can be related to a corrupt Options file for the user. This is especially true if there was a preceding crash or unexpected closure of the tool.
New options files can be reassigned to the user so that the erroneous ones no longer cause the failure during the opening of the workspace. Please note that this will reset the user's options and search filters.
Perform the following SQL queries, replacing USER with the UserID of the single user.
delete from optionsSelected where OptionsID in (select ID from options where Owner = 'USER');
delete from options where Owner = 'USER';
#OracleWorkspace
#SQLServerExpress
#RepositoryQueries
#Workspace
#SQL
#EnterpriseAnalyser
#RepositoryBrowser
#SupportTip
#EnterpriseAnalyzer
#DB2
