User logon freezes GP - zDP_PM00201SS_1

(0) Share

Report

Posted on by Community Member

Greetings!

I have a user that when they login, Dynamics GP 2015 R2 the application goes "Not Responding".

I have enabled DEXSQL logging and found the following recursive call occurring for what appears to be every vendor (we have 100,000+).

What is this? Any way to disable this? I believe it has something to do what activity on the home page. I tried disabling that.. even reset those SYS tables controlling the user's homepage role & preferences to no avail. Any advise is greatly appreciated - Thanks!

/* Date: 05/25/2017 Time: 10:01:28
stmt(165910800):*/
{ CALL BNSFL.dbo.zDP_PM00201SS_1 ( '{VENDORID}' ) }

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Community Member on at

Like (0)

Report
Copy link

Link copied!

Is this specific to only one user on any machine in the system, any user on that one system, or a breakdown of the two?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Impacting a single user logging into GP from any machine.

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report
Copy link

Link copied!

Haven't ever experienced anything similar, but is it much of a loss other than time to create a new user and duplicate the security and settings? If the problem persists then it would likely be part of the setup for the user and I would question any changes made in the past few days to the user settings.

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,061 Moderator on at

Like (0)

Report
Copy link

Link copied!

Ryan,

As suggested by Scott, try create a new use & duplicate the security settings. If behavior persists, than investigate if that user has some 'reminders' or alerts setup in GP regarding the vendor master table (i.e. on hold warnings).. if you have a large vendor table (PM00201), that could be the cause of it.

Was this reply helpful? Yes No
Suggested answer

Eduardo B 7 on at

Like (2)

Report
Copy link

Link copied!

Hi! please check if the user has any "task" or "alerts" configured after Great Plains starts.

select * from DYNAMICS..SY01403 where userid='XXXXX' --user tasks
select * from DYNAMICS..SY01404 where userid='XXXXX' --user alerts

After deleted those records, it solved my problem!

Thanks

Was this reply helpful? Yes No