Weird behavior in Sales Orders

Wisa123
Member Posts: 309
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
-
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
-
Hi,
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.
parm0 -
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
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions