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