635
Hello,
On the Group Maintenance (9528000) Screen, when a new group is created and saved with no error, the PVlist does not pull the new Group. We also have this problem with the User Maintenance Screen (9526000).
Has anyone else had a similar issue with Dynamics 2011 FP1 SP2?
Thanks!
*This post is locked for comments
Hey Rick,
It looks like when we installed Renown (3rd Party App), it created a Userrec and Usergroup table in the application Database duplicating the System Database. I have removed both of these and the Group/User Maintenance screens are working correctly.
Thanks for the suggestion!
You should not have a userrec table in the application database. It should only exist in the system database. I suspect that someone, at one time, copied userrec into the application database causing this issue. Just to be sure what I am saying, I looked at several application databases and none have a userrec table.
Thanks for the response.
I believe we have found the issue. When the new Group/User is created in Dynamics the Userrec table on the system database is update, however on the Dynamics screen the PVrec is pulling Userrec data from the application database. I've manually copied the new Group/User into the application database Userrec table and the PVrec pulls the updated data.
Is there a setting in Dynamics to select which Database to pull the Userrec table from?
Do you have any customization on the Group Maintenance screen & User Maintenance Screen?
If yes, you may have to check the VBA code in those screens.
If no, you may need to analyze this issue in the backend (Sql Server)
Group Maintenance:
This is the PVRec procedure "UserRec_Type_UserId, "G"; 0; 127; 0; 0, used in the Group maintenance. Below is the SQL Query is used in the PVREC procedure.
Select * from UserRec where UserRec.RecType LIKE 'G' and UserRec.UserId LIKE 'XXXXX' order by RecType, UserId
XXXXX- Newly created Group ID.
You can use the above sql query to check whether the newly created group available on the backend(SQL server) or not.
User Maintenance:
This is the PVRec procedure "sm_UserRec_UserId", used in the User Id field of User maintenance. Below is the SQL Query is used in the PVREC procedure.
SELECT * FROM UserRec WHERE UserId LIKE 'XXXXX' AND RecType = 'U' ORDER BY UserId
XXXXX- Newly created User ID.
You can use the above sql query to check whether the newly created user available on the backend(SQL server) or not.
Hope this helps.
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (