Hi all,
I have a page which returns user data. In the page is a function that returns a count of a number of rows from another table filtered so only relevant rows are counted.
However, I've recently had to change the code in the function, which should change the number of rows returned, but it remains the same. The page saves and compiles ok and without any error messages or warnings. The date and time against the page in Object Designer do change suggesting the compile has succeded.
To ensure the change has taken effect, I changed the function so the very first line in it returns a specific number (using "EXIT(101);") but I am still getting the previous value (which happens to be 3) returned, both when I view the data in the RTC or if I call the page through web services. I've restarted the web services and several other things to try to force the change to be picked up but it flat out refuses.
I've added and removed test fields/values to the page.
I've stopped the service and tried to access the page while it wasn't running.
I've removed the relevant row for the object in the Object Metadata table and compiled it to force the data in the table to update.
After restarting all the navision web services on the middle tier server, all of the folders in the folder "C:\ProgramData\Microsoft\Microsoft Dynamics NAV\60\Server" have today's date except the one I need to be refreshed, which is still dated 7 dec 2012.
I've looked at all objects in the database that are dated on or shortly before 7 dec 2012 and they all compile ok too.
In short, I cannot get my changes to a page to be presented, and I'm seeing no errors.
Can anyone offer any suggestions?
Thanks,
Karl
0
Comments
There are several other blog entries about this issue with different suggestions to improve the situation, but I still haven't found any "silver bullet" to get it to work everywhere.
Peter
As I was looking into this a colleague suggested I stop and start the services in a specific order.
After doing this in the following order, my data started to appear as expected. However, I am sure I tried this before posting and can only assume I restarted the web services service before the RTC service.
Stop the web services service.
Stop the RTC service.
Start the RTC service.
Start the web services service.