Skip to content

x Want to ask a question or reply? Click here to join the group.
Options
  • State Not Answered
  • Replies 1 reply
  • Subscribers 37 subscribers
  • Views 1238 views
  • Users 0 members are here
Browse Forums
Announcements
62
topics
77
replies
Customization and Integration
89
topics
301
replies
Financials, Projects, and Administration
92
topics
247
replies
General Discussion
222
topics
555
replies
Installation and Technical Issues
131
topics
433
replies
Manufacturing, Distribution, and Applications
38
topics
77
replies
Reporting and Analytics
54
topics
223
replies

Explorer error message: Unhandled exception has occurred in a component in your application.

FWW
Posted By

Explorer stopped working for one user and only in live database. Explorer still works in a Pilot database for that user.

When the user opens an Explorer, the Settings window is empty:

Error message is: Unhandled exception has occurred in a component in your application. If you click Continue, the application will ignore this error and attempt to continue.

Key not found: 'Filter'

Parameter name: Key

If Continue is selected, the following message appears:  Key not found: 'Filter' Parameter name: key

Version: Sage 500 ERP 2019 Product Update 5 (Version 8.00.5.0)

Any suggestions on how to get Explorer back working for this user?

Parents
  • 0

    I found the solution here: Solution ID 224924550061904:

    Have the Sage 500 ERP user reporting this error try to duplicate from another workstation. If the issue can be duplicated from another workstation, it is possible that there are desktop settings that have been corrupted for that user. Make a backup copy of production database, restore this copy and perform the subsequent steps against the copy. Try the following steps that will delete data records from a couple of specific Sage 500 ERP tables. 1. Obtain the Sage 500 ERP userid 2. Log into SQL Server with an account that has permission to delete records, typically sa 3. Switch to the copied Sage 500 ERP application database 4. Execute: DELETE FROM tsmDataViewSettingUser WHERE UserID LIKE '%AAA%' 5. Execute: DELETE FROM tsmUserDesktop WHERE ActualUserID LIKE '%AAA%' 6. Have user login to Sage 500 ERP and try to duplicate reported issue (Replace AAA with userid from step 1)

    Thank you,

    FWW

Reply
  • 0

    I found the solution here: Solution ID 224924550061904:

    Have the Sage 500 ERP user reporting this error try to duplicate from another workstation. If the issue can be duplicated from another workstation, it is possible that there are desktop settings that have been corrupted for that user. Make a backup copy of production database, restore this copy and perform the subsequent steps against the copy. Try the following steps that will delete data records from a couple of specific Sage 500 ERP tables. 1. Obtain the Sage 500 ERP userid 2. Log into SQL Server with an account that has permission to delete records, typically sa 3. Switch to the copied Sage 500 ERP application database 4. Execute: DELETE FROM tsmDataViewSettingUser WHERE UserID LIKE '%AAA%' 5. Execute: DELETE FROM tsmUserDesktop WHERE ActualUserID LIKE '%AAA%' 6. Have user login to Sage 500 ERP and try to duplicate reported issue (Replace AAA with userid from step 1)

    Thank you,

    FWW

Children
No Data

*Community Hub is the new name for Sage City