You’re offline. This is a read only version of the page.
Hello - Does anyone have any tips on how I can report, via SQL, on the notes field on the user table? Basically, I'd like to build a query to return the notes, by user. I'd like to store info on a user in the notes field, hence the request. I am aware that the Notes Master table is SY03900 table, and that the user master table is SY01400. I appreciate any input you can offer. Thanks.
*This post is locked for comments
If these tables are full again, especially the last two, when no one is in GP then you have network disconnects going on. Make sure you tell your users to exit GP when they leave for the day. You may need to research what is causing the disconnects.
DYNAMICS..ACTIVITY
DYNAMICS..SY00800
DYNAMICS..SY00801
TEMPDB..DEX_LOCK
TEMPDB..DEX_SESSION
@Richard, I am getting same issue again .Is there any other way to find the issue ?.
@Richard,
I ran the above query. I tried to edit the Note field and can edit the Note field. As of now,No issues with that. I will double check tomorrow and day after tomorrow If I face any issue with that I will let you know Richard.
Thank you very much .
All tables need to be empty when no one is in GP. Execute
DELETE TEMPDB..DEX_SESSION in SSMS when no one is in GP.
@Richard,
I ran above queries when no one is there in GP and result is like below.
first 4 queries returns nothing and the last query return many more rows with the column names session_id,sqlsvrsp_id.
Hi Richard,
I didn't run the above queries. Now Users are working in GP. So, I will run on tomorrow and let you know.
Thanks,
Pavan
Have you run this while no one is in GP? These tables need to all be empty while no one is in GP.
DYNAMICS..ACTIVITY
DYNAMICS..SY00800
DYNAMICS..SY00801
TEMPDB..DEX_LOCK
TEMPDB..DEX_SESSION
Hi Almas ,
I have verified for the triggers in Note Table (SY03900). But there is no Triggers in the Table.
Thanks,
Pavan
Pavan check if notes table have any custom trigger on it, because custom triggers on tables cause this issue.
I am facing an issue with Note field .Whenever I Want to Edit the Note field in GP ,It throws an error as below "This record has been changed since you opened this window.Changes won't be saved". Why I am getting this error. Please help me in this.
Thanks,
Pavan
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (