pmarques
(Pedro Marques)
November 8, 2017, 8:59pm
1
My users have complained that opening the Serial Number Assignment form is very slow. I ran a trace and found out that the GetRows method from the PlantConfCtrl BO is taking around 20 seconds. This doesn’t make much sense as there’s only 3 plants in our system. Checking the database on table Erp.PlantConfCtrl shows the 3. Any thoughts?
@aidacra Anything else I can troubleshoot?
Bart_Elia
(Bart Elia)
November 8, 2017, 10:35pm
2
A similar question just popped up yesterday from a different customer so a new ticket with support will be welcome.
Question -
How many companies / sites / warehouses / partbins do you have?
Anything change in those lately?
1 Like
pmarques
(Pedro Marques)
November 9, 2017, 1:23pm
3
I’ll put a ticket in.
We have 3 companies, 3 sites (1 per), 27 warehouses, 70 bins. Really nothing extraordinary.
pmarques
(Pedro Marques)
November 9, 2017, 1:28pm
4
Ticket # is CS0000680510.
1 Like
Bart_Elia
(Bart Elia)
November 9, 2017, 1:59pm
5
Is attached to the other report and making is way thru triage. Much thanks
1 Like
pmarques
(Pedro Marques)
November 20, 2017, 5:34pm
6
I’ve just sent the trace logs.
I find the following server trace to be quite strange:
<Sql queries="22768" cacheHits="0" time="17645.5375" qryTypeCount="6" />
That’s an awful lot of queries for this.
Bart_Elia
(Bart Elia)
November 20, 2017, 7:28pm
7
cacheHits=“0”
cries
I have had conversations internally when the issue came in. I don’t know the status but keep after them to keep you updated