Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 296 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
NAS cache (?)
J-A
Member Posts: 6
Hi
Have a NAS that seems to cache the data in tables.
We run a SQL2000 and Nav 4.0
What we do is that we have a NAS that imports files from the disk.
From the file we generate an sales header and multiple sales lines
Everything works fine exept this.
If a user changes the "Unit Price" on the Item card, the NAS still picks the old price.
The old price does not exist anyware in the system. It's like the data is cached and never released.
This is some pseudo code to explain what we do
codeunit 1, check parameter, call codeunit 50000
Codeunit 50000, start a timer and do a loop
In timer-loop, check if any new file exist to import, if so, do a clear on the variable for codeunit 50001
Codeunit 50001, import the file. Use local parameters. Use validate on all fields on the sales line. Both the No., Quantity, UoM fields should call the price calc mgmt, and they do, but recieves the old price.
If i Stop the service and restart it, everything work fine.
If I open up the imported order in a clinet and press F2 in No. and then enter, the correct price is recieved.
anyone have any idea why it behaves like this?
Additional note:
We also changed a vendor some time ago, and changed the Gen. Bus. Posting Group.
This change did go through and the correct data was recieved.
Have a NAS that seems to cache the data in tables.
We run a SQL2000 and Nav 4.0
What we do is that we have a NAS that imports files from the disk.
From the file we generate an sales header and multiple sales lines
Everything works fine exept this.
If a user changes the "Unit Price" on the Item card, the NAS still picks the old price.
The old price does not exist anyware in the system. It's like the data is cached and never released.
This is some pseudo code to explain what we do
codeunit 1, check parameter, call codeunit 50000
Codeunit 50000, start a timer and do a loop
In timer-loop, check if any new file exist to import, if so, do a clear on the variable for codeunit 50001
Codeunit 50001, import the file. Use local parameters. Use validate on all fields on the sales line. Both the No., Quantity, UoM fields should call the price calc mgmt, and they do, but recieves the old price.
If i Stop the service and restart it, everything work fine.
If I open up the imported order in a clinet and press F2 in No. and then enter, the correct price is recieved.
anyone have any idea why it behaves like this?
Additional note:
We also changed a vendor some time ago, and changed the Gen. Bus. Posting Group.
This change did go through and the correct data was recieved.
0
Comments
Regards
The singleinstance feels like a longshot. Since i do a clear on the codeunit and i'm pretty certain that i don't have multiple instances of it, I can't see how that would help.
The SELECTLATESTVERSION seems like the thing to use.
I'm not sure i can recreate the error but I will test it later today. If i'm not able to recreate it I will have to wait until the cache have grown up big enough to generate the error. But if the SELECTLATESTVERSION works, I will never get this error again.
Anyway. I will make a new post when I made the tests