Dynamics Community Forum Thread Details

Cleaning up the syMenuMstr table

I have duplicate entries in the syMenuMstr (sy07110) table and i have deleted all of the entries for my product id. I have login and these menu items are not being repopulated. Is there another step in this process? I was working on the assumption that if you deleted all entries related to a product id in this table, the login process will rebuild menus for that product id.

Hey Jason,

If I understand you correctly you are missing toolbars when you log into GP. These are actually controlled in table SY07125. You can delete the records from this table and the records will be recreated when the user logs back into GP. You can use the following script to remove the records:

DELETE FROM DYNAMICS..SY07125 WHERE USERID='UserName'

DELETE FROM DYNAMICS..SY07121 WHERE USERID='UserName'

I have seen the toolbar still missing after deleting records from this table. This is caused by the template records not being correct in the SY07125. If running the scripts above don't resolve the issue run the following scripts and let me know the results.

SELECT * FROM DYNAMICS..SY07121

SELECT * FROM DYNAMICS..SY07125

Thanks,

Jonathan Fear

Quick Links

Leaderboard