We ran into an interesting problem with one of our larger GP Web Client implementations today. The client has about 250 users running the GP 2015 web client. At about 11am we started to get reports that new users could not access GP through the web client but existing GP web client users were unaffected. As part of the troubleshooting process we found that when you logged into the GP Web client, AD authentication completed successfully, company selection and initial screen load all completed without a problem but when it got to the point where it populates the Home Page or body of the GP interface it hung. The Home Page section would stay grey, and the GP client would hang and not allow the user to click on any of the navigation links within the GP interface on the left.
Additional testing of the GP thick client was successful and did not experience the same problems.
Ultimately we found a deadlocking in the database with the following stored procedure:
DYNAMICS.dbo.zDP_ADH00100SS_1;1
Anyone have any idea why this happened? Basically any new GP Web Client sessions where getting blocked by the above request.
*This post is locked for comments