Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Slow lookup times on Debtors/Creditors/Items

Posted on by 80

Good afternoon,

 

I am experiencing extremely long initial lookups in GP2016.  When ever we use Debtor Inquiry, Creditor Inquiry or Item Inquiry

 The first lookup takes about 2 minutes and all subsequent ones about 2 seconds.  A server profile trace reveals that zDP_ASITAB20N_1 is being called  around a thousand times before the initial lookup returns anything.  Below is a small sample of what is happening before results are returned.

zDP_ASITAB20N_1 is a smartlist procedure, can you please advise why this is happening and how I can fix it.

 

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32424,0,4,-32768,0,4,32767

sa

31

110

0

27

4924

102

55:52.4

55:52.4

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32449,0,4,-32768,0,4,32767

sa

31

111

0

27

4924

102

55:52.4

55:52.4

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32474,0,4,-32768,0,4,32767

sa

32

110

0

27

4924

102

55:52.4

55:52.5

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32499,0,4,-32768,0,4,32767

sa

31

111

0

28

4924

102

55:52.5

55:52.5

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32524,0,4,-32768,0,4,32767

sa

31

110

0

33

4924

102

55:52.5

55:52.5

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32549,0,4,-32768,0,4,32767

sa

31

112

0

30

4924

102

55:52.5

55:52.6

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32574,0,4,-32768,0,4,32767

sa

32

111

0

29

4924

102

55:52.6

55:52.6

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32599,0,4,-32768,0,4,32767

sa

31

112

0

35

4924

102

55:52.6

55:52.7

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32624,0,4,-32768,0,4,32767

sa

47

112

0

36

4924

102

55:52.7

55:52.7

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32649,0,4,-32768,0,4,32767

sa

31

111

0

27

4924

102

55:52.7

55:52.7

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32674,0,4,-32768,0,4,32767

sa

16

112

0

27

4924

102

55:52.8

55:52.8

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32699,0,4,-32768,0,4,32767

sa

31

111

0

31

4924

102

55:52.8

55:52.8

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32724,0,4,-32768,0,4,32767

sa

16

112

0

30

4924

102

55:52.8

55:52.9

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ASITAB20N_1 25,0,4,32749,0,4,-32768,0,4,32767

sa

31

105

0

35

4924

102

55:52.9

55:52.9

0X000000000B0000003800440059004E0041004D004900430053002E00640062006F002E007A00440050005F00410053004900540041004200320030004E005F

RPC:Completed

exec DYNAMICS.dbo.zDP_ADH00100SS_1 0,4

sa

0

2

0

0

4924

102

55:52.9

55:52.9

0X00000000030000003A00440059004E0041004D004900430053002E00640062006F002E007A00440050005F0041004400480030003000310030003000530053

RPC:Completed

exec DYNAMICS.dbo.zDP_ASIEXP99SS_1 1,'sa','IV_Item_Number_Lookup'

sa

0

0

0

0

4924

102

55:52.9

55:52.9

0X00000000040000003A00440059004E0041004D004900430053002E00640062006F002E007A00440050005F0041005300490045005800500039003900530053

SQL:BatchStarting

SELECT COUNT(ITEMNMBR) FROM SNF.dbo.IV00101

sa

4924

102

55:52.9

SQL:BatchCompleted

SELECT COUNT(ITEMNMBR) FROM SNF.dbo.IV00101

sa

0

20

0

0

4924

102

55:52.9

55:52.9

*This post is locked for comments

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