Does anyone had this issue in using Kinetic on premise?
When we create a new TO and try to add a new line it’s taking roughly more than 2 minutes per line item.
When I do the same in testing environment, it works perfect with no big delays.
Thanks.
Not exactly, but I definitely believe it. TFOrdDtl is my archnemesis.
1 Like
I don’t think I understand your comments, but this issue happened since last week. Nothing has changed lately, they just started to see this long minutes delay for each line they want to add on a Transfer Order…don’t see what can be the root cause.
Any ideas?
This part is probably the obvious one, but: TFOrdDtl is a Transfer Order Line. It’s the table for that.
My point is that TFOrdDtl is notorious for dragging down queries. I don’t have a clue why.
It used to hang up MRP for us - there is a SQL query (not BAQ) that MRP runs against TFOrdDtl that typically runs in seconds (or less) but would go over an hour at random and even exceed server timeouts (thus killing MRP).
So I’m just saying, I can see how that particular table is inexplicably causing issues.
Been there - with ‘TFOrdDtl’ specifically.
You can try forcing a better plan, once you find your query that is bombing out.
1 Like
Oh yeah, the landing page crashed the whole app pool, too: