Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 305 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Weird behavior in Sales Orders
Wisa123
Member Posts: 308
Hi experts,
First of all I hope I created this thread in the correct session. If not feel free to move it to wherever it belongs.
One of our clients started to have performance issues when selecting a particular Item in a Sales Line ... Let's name this item XYZ.
As soon as they validate the Quantity the whole Sales Order page is not responding for 5-15 seconds, and after the initial freeze the whole order pages responds really slowly. XYZ is used in nearly every Sales Order (40k SalesOrders a Year)
SideNote: we dont delete Sales Orders when they're done - just mark them as done.
Ok. Now, heres the weird part:
The Item XYZ is slow for every User EXCEPT for users with the SUPER Role. With Super it works like a charm.
I checked the item Card and all the other linked Tables for the item XYZ - there was nothing special about it.
Next i started SQL-Tracing a Non-Super User and found this:
https://us.v-cdn.net/5022383/uploads/FileUpload/ee/75eb944a2a3bd470a3c788d1ddf81e.png
Looks like we are sending a request for every SalesOrder in which the item is used! (A13/.... are SO-Numbers).
For me this looks like the FlowField "Qty. on Sales Order" is somehow broken. I compared Objects and VSIFT views with a standard Version of 2013R2 but wasn't able to find any difference.
I already looked trough Cumulative Updates to find something about this issue, but couldn't find something.
Please excuse my english!
I would greatly appreciate any help, if i can provide you with more information, let me know what you need to know!
First of all I hope I created this thread in the correct session. If not feel free to move it to wherever it belongs.
One of our clients started to have performance issues when selecting a particular Item in a Sales Line ... Let's name this item XYZ.
As soon as they validate the Quantity the whole Sales Order page is not responding for 5-15 seconds, and after the initial freeze the whole order pages responds really slowly. XYZ is used in nearly every Sales Order (40k SalesOrders a Year)
SideNote: we dont delete Sales Orders when they're done - just mark them as done.
Ok. Now, heres the weird part:
The Item XYZ is slow for every User EXCEPT for users with the SUPER Role. With Super it works like a charm.
I checked the item Card and all the other linked Tables for the item XYZ - there was nothing special about it.
Next i started SQL-Tracing a Non-Super User and found this:
https://us.v-cdn.net/5022383/uploads/FileUpload/ee/75eb944a2a3bd470a3c788d1ddf81e.png
Looks like we are sending a request for every SalesOrder in which the item is used! (A13/.... are SO-Numbers).
For me this looks like the FlowField "Qty. on Sales Order" is somehow broken. I compared Objects and VSIFT views with a standard Version of 2013R2 but wasn't able to find any difference.
I already looked trough Cumulative Updates to find something about this issue, but couldn't find something.
Please excuse my english!
I would greatly appreciate any help, if i can provide you with more information, let me know what you need to know!
Austrian NAV/BC Dev
0
Best Answer
-
Wisa123
Member Posts: 308
Hi,
Resolved this issue, the Qty. on SalesHeader FlowField in our Solution was filtered by another field which was a lookup on the SalesHeader itself.
Conclusion: Dont use FlowFields as Filters in Flowfields.
Still weird that the bad performance only occurs with non-super usersAustrian NAV/BC Dev5
Answers
You said the SUPER users are much faster than other users.
This suggest that SUPER users can use the VSIFT view (have permissions) and the other users can't and they have to loop the sales order table.
Run the sql profiller with both users to confirm this and try to synchronize users.
Regards and good luck.
parm
Resolved this issue, the Qty. on SalesHeader FlowField in our Solution was filtered by another field which was a lookup on the SalesHeader itself.
Conclusion: Dont use FlowFields as Filters in Flowfields.
Still weird that the bad performance only occurs with non-super users