Customer Sales History- Slow/Hangs

ashbhardwaj

Hi

My client is running on NAV 4 SP2 .

Customer Sales History is working fine for some customers but for some customers it is taking more time or some times it hangs.

I have checked the Keys & other possible code is this some thing related to Customer No.. or some wrong date entries etc...

What needs to be check is there anu bus in this ver..

Please advice

Thanks
Ashish

kine

1) Native or SQL?
2) Did you tried to use Client Monitor to see what takes so long?

ashbhardwaj

Hi
It's on SQL.
It's very strange issue working fine for some cutomers having large data but stucks for some customers or hangs for customer having 1-2 entries.

yes i have use client monitor.....but not very much help

kine

All depends on exact version of NAV client, SQL updates and SPs installed, hardware configuration etc.

Alex_Chow

If all your clients are on the same version and it hangs only on a couple of customers, then I'd place my money on the hardware configuration. What is the specification for your client?

ashbhardwaj

Hi Just Check with Client Monitor for a cuctomer
it's taking time in this
SQL Statement SELECT * FROM "La Rousse (Live)$Sales Shipment Line" WHERE (("Sell-to Customer No_"='FOLE01')) AND "Sell-to Customer No_"='FOLE01' AND "Document No_"='SSHP-416603' AND "Line No_"<10000 ORDER BY "Sell-to Customer No_" DESC,"Document No_" DESC,"Line
Elapsed Time (ms) 296703

Very strange why it's looking for line no.>10000????
for other customers it's looking for line no. > 10000

Any thing wrong in data??

Please help