Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / PO Generation Takes 5+...
Microsoft Dynamics GP (Archived)

PO Generation Takes 5+ Minutes

(0) ShareShare
ReportReport
Posted on by chadbruels 1,582

A client's environment is taking 5 to 10 minutes to generate a PO. I captured a SQL trace and I'm focusing on the finding that the following tables are accessed repeatedly:

exec RELEC.dbo.zDP_B3900100F_1 NULL,NULL

exec RELEC.dbo.zDP_B3910300SS_1 'P0219910'

exec RELEC.dbo.zDP_B3970300SS_1 'P0219910'

exec RELEC.dbo.zDP_B3910100SS_1 'P0219910'

exec RELEC.dbo.zDP_B3900200SS_1 '<username>','011'

If I filter on just the B3910300 table, I find that this zDP procedure is called for it 18,454 times. This lead me to look at some of these tables and I find POP10100 has 17,700+ records and B3910100 has 17,400+ records.

Can you help me focus in on what is happening?

*This post is locked for comments

  • chadbruels Profile Picture
    chadbruels 1,582 on at
    RE: PO Generation Takes 5+ Minutes

    We have Binary Stream performing an analysis as these are their tables. Thanks for your consideration.

  • Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: PO Generation Takes 5+ Minutes

    Do you know what these zDP_B3910300..... procedures are from, as they don't appear to be default Dynamics GP dex procedures?

    I know we have tables and procedures that begin with BE, BC and BM, but I don't have a B3910300 object in my Dynamics GP environments.

    If they are from a third-party, you may want to contact the supplier of that product, as they may have seen this performance hit already, and have a fix for it.

    As well, I'm not sure what the P0219910 table or object is either, as I don't have that in my Dynamics GP environments either.

    Thanks

  • Suggested answer
    kdd281 Profile Picture
    kdd281 465 on at
    RE: PO Generation Takes 5+ Minutes

    Did you try check links to clean things up?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans