ISSUE: Activity Detail window freezes up, locks up, and doesn't print when you click Process.
The below is the path to take to Activity Detail:
GP > Tools > Utilities > System > Activity Detail.
Anyone else experience this? And what can you do to fix it?
*This post is locked for comments
My question would be how many records to you have in the system table of SY05000?
If you have a large amount of records, I'd recommend to open the 'Remove Activity Tracking Detail' window and remove a range of activities after a specific date of time.
You an also make a backup of the SY05000 table before removing records from this table if need be.
I looked through our case history but we don't have anything unique to the Activity Detail window freezing or locking up, any different than any other GP window in the application.
As the 'Activity Detail' window is most likely l at the records in this table, I would start there.
Thank you
what exactly are you looking for?
Are you just trying to find what the user has open and what they're working on, or what user is logged in, or what resource might be locked?
I would just view all this data in SQL, I find it easier to view it. Granted that's as long as you have access to it.
I would just check the following tables in Dynamics:
Dynamics.dbo.Activity -- User logon
Dynamics.dbo.SY00800 -- Active user window and report
Dynamics.dbo.SY00801 -- Active user process
Tempdb..dex_session & dex_lock -- orphaned sql logins after Activity table is cleared
I might have the description of the following tables off by a little but it's how I remember them.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
