Hi Eric,
It's good to have you here. I'm looking forward to a lot of interesting blog entries from you....
Hey Eric, great to see you have started blogging. If you need any help about how to administer the CS blogs, just let us know.
Hey great post. This Araxis looks great.
I use the developers toolkit for the same task. I compare the objects of a client database with the standard one that comes with the clients version.
I've been using Araxis for 5 years now and it's a great tool. But I can see I'm not such a heavy user as you. In general I always use Per Mogensen's MergeTool for a full merge and compare in connection with upgrades. It's using a three tier model, where you have the old base, the new base and the modified version of the customer. It's basically the same model as the NAV Developers Toolkit, but that's not so strange, as they simply copied his mergetool (he developed it when he used to work for Navision) and used it as the base for the Developers Toolkit. They even copied the errors that used to be in the Mergetool! But what I like with the Mergetool is that it's giving you the semi-automatic merge, where it's basically merging most of your objects automatically, and you only have to deal about the ones with bigger conflicts.
Araxis I usually use if I only have a few objects I need to compare, and with the three column view you can actually still do some nice manual merges.
Hey Waldo, are you a NAV MVP or an Axarix MVP?
Great post!
I like the drilldown, I might just give Araxis a try. Can I buy shares somewhere first though?
I don't think you can by shares now:
"Araxis Ltd is based in the Isle of Man, British Isles, and is a privately held company. Araxis is entirely self-funding and self-sustaining"...
But if one could, I think I would have bought some a few years ago!
I agree with Erik.
For big merges, I use dev toolkit or mergetool ... for merging a few objects or comparing databases (where this blogpost was about), I always use araxis.
And indeed, you should be able to buy shares of Araxis ;)
Since I don't normally do the actual work of merging, but just need to see what has been done before and after, I think for me this Araxis look ideal.
Good! Even for long term NAV consultants, this spreadsheet is a must for trouble shooting permission problems.
Very good... Especially the part about getting older versions to run!
Now all I have to do is install Vista. :-)
Excellent, this should help a lot of people.
Very valuable...
Good work. This information it’s easy to find it out than partnersource.
Good work! MS should do the same!
The 4616 traceflag needs to be set for version 5.0 running on SQL2005 database even on XP.
I tried setting it as described in this article and it did not work.
I did a Google on this and found that a - sign is needed before the T. So Startup Parameter should look something like this:
-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf;-T4616
i.e. add ;-T4616 to the end of the existing startup parameter.
Just a shame you can't lookup the mbs.microsoft links without a special login!
What would you like to know? May be I can post it here... .
I use a simple economics argument to convince customers.
1. They're most likely buying a server that will support 64 bit
2. The cost of 32 or 64 bit software (Windows & SQL) is the same.
3. A 32 bit standard Windows/SQL install will support 2-3 GB of memory
4. A 64 bit standard Windows/SQL install will support 32 GB of memory.
5. Adding memory to the 32 bit system will require an upgrade to enterprise editions of both Windows & SQL. Even with discounts this can be in the $10,000 + range plus memory
6. Adding memory to the 64 bit system means just buying the memory.
That is very true indeed ... but not known by many people, I guess.
Hey Eric, great blog. I had thought about going to the WPC, but by the time I decided to go, it was sold out, so its great to get all this information from you.
I totally agree about Upgrades, and although the concept has a way to go, they are going in the right direction this time.
By the way, I know that people don't often reply to Blogs, but a lot of people read them. For example your blog on NAV on Vista has about 1,200 link backs, coming from google searches, blogger.com, answers.com,
Oh and here is a cool one, someone searched on google.jp and then read your blog in Japanese.
http://translate.google.com/translate?hl=ja&sl=en&u=http://dynamicsuser.net/blogs/waldo/archive/2007/05/28/dynamics-nav-on-vista.aspx&sa=x&oi=translate&resnum=2&ct=result&prev=/search?q=nssdk&start=20&num=20&hl=ja&newwindow=1&rlz=1t4gglj_enjp218jp218&sa=n
Anyway keep up the great work, a real lot of people are reading your Blogs.
fantastic report. I don't get chance to go to a lot of conferences (being stuck in NZ) and it's great to find out what's going on. I really appreciate your efforts in blogging.
Nice one - keep 'em coming!
Thanks for the kind comments, guys.
Hey Waldo, did they say when the new screen saver was going to be launched?
Does the sharepoint portal webpart work with all NAV objects "as is" or do you need to build objects like with the current Employee Portal?
Interesting stuff. Thanks!
Hey, Gaspode.
I don't know when the screensaver will be launched ... they just said that it's comming.
For the sharepoint client: it will work for all Page objects... The page object is going to give meta data to the dynamics client. They built a web part that is also reading this meta data to display on sharepoint. As simple as that!
To confirm what Gaspode wrote: the actual parameter needed is ;-T4616
(; is the separator from the previous parameter)
Thanks waldo for the great posts here.
That would be very good, but it would also be needed to define globals/locals as that datatype. Or for the moment to define a global/local AS Item.Description.
So when the description of the item changes, all globals/locals based on it change. This is something I had with Progress and I do miss it a lot in Navision.
Good trick :)
Hmm good idea, much easier than putting an icon on every date field in a form, AND its Very Navision like using the ? mark.
Hi Waldo. Yes it would be great. I worked on XAL and then Axapta for a few years before starting on NAV and there are quite a few things that Axapta did much better (for the programmers at least.) I am hoping that the NAV 5.1 and later versions will start to address this. Some things that I miss:
Layers that allow me to easily identify changes and roll them back. Where used in the IDE as opposed to a Developer's toolkit. Fields that do not thow an error if you try to assign a string that is too big. Error messages that get stored up and displayed in an info log. The ability to execute SQL code directly in the database. The list goes on and on...
Hey Eric, nicely written, I am sure its not just you two that didn't know about Index Hinting, so i think this blog will help a lot of people.
Thanks for sharing this.
By the way, if you have problems with SQL using the wrong key in a specific case (e.g., say a form with lots of records), have you tried creating a NEW key specifically for that situation and sorting the form on that, then apply the Hint just to that new key, so that the hinting will not affect other areas of code?
That's indeed a way to avoid that the key is taken for pieces of code you don't want. But if you want it to use an existing key ... then you'll have to watch out. As you know, you can't create double keys... .
You can't create double keys of course, so what I normally do is add a new boolean field to the table, then create a new key including that field, and then filter SETRANGE(MyNewField,FALSE,TRUE);
That is indeed a way to do it. Quite a creative tip, thanks. I will test it out an see what mr. profiler says ;°)
Please let me know the results.
The setrange is not nesesairy because index hint only uses the setcurrentkey.
Yes of course you are right.
Its an old trick I used to use in flow fields to force Navision to pick the key I wanted it to use instead of letting it pick the first one it finds.
Since not everyone have access to partnersource, then I'll recommend you to just download it from the download section:
dynamicsuser.net/.../entry90461.aspx
and
dynamicsuser.net/.../entry90460.aspx
Good call ...
I guess its not NDA anymore I see than Sean has posted some other videos also on You Tube.
That is funny! I FEEL GRRRRRRRREAT!!!!!
Cool!
I cannot install the fix. I get error "the rollup fix cannont be installed by Windows Installer service because the programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!
While I was there I saw some Summit Vids - Perhaps I need to find my way to one of these events
For sure Harry,
if you only get a chance to make one event, then Summit is the one to be at.
That summit video there was made at the party we had at the Museum of Flight, which was a great night out.
This is very good. But the question I remember always hearing is: What's in it for me?
See my comment to Waldo's previous blog. Remember you're dealing with financial systems people. They understand things in terms of "what will it cost me"
dynamicsuser.net/.../sql-server-x64-vs-x86.aspx
This table was actually an extension to my previous blog, where babrown already summarized what is actually in it for NAV customers... .
IMHO indexhinting will not do the trick for one simple reason: SetCurrentKey is only significant for sorting and not for selection. The index to use therefor does not depend on the active key but on the fields on which is filtered.
The indexhint option actually gets "in the way" when there are 2 routes to the same screen, i.e. Customer Ledger Entry screen can be reached through the Navigate functionality (where the filter will be on "Document No.") and from the Customer form (where the filter will be on "Customer No."). The resulting screen has the SetCurrentKey set to "Customer No.", "Posting Date" so for the "Document No." route with index hinting to the Customer No. index will still result in a freeze.....
And still, users are allowed and will use the function to change the Sorting Order in this screen (effectively changing SetCurrentKey) with similar performance impact.
Well, actually, in NAV terms ... with indexhinting, you can USE SETCURRENTKEY to be sure to take the key you want, despite what SQL Server would suggest. That's the whole idea of index hinting: SQL Server doesn't take the key you want it to take .. so you hint that key.
About the two routes: David's suggestion is the way to fix that.
Thanks, I look forward to see the "what's changed" list...
Well Mark actually also posted it to his own blog here:
dynamicsuser.net/.../update-6-for-navision-4-0-sp3-be-careful.aspx
One thing is for sure, if it was not for Arhontis's posting I would have had a really bad weekend.
The ;-T4616 solved my problem.
You'll be up a creek whenever an urgent medical bill or emergency spring up, and your payday is still far out. If an overnight $500 personal loan can help, ...<a href=abaco.ya.com/.../index.html>no fax payday cash advance</a>
I changed the screenshot to the ";-T 4616" ... .
You should update this blog with the new updates!
Review: One of the discussed new features in update 6 is the fact that the new client (build 24143),
Thanks for the elaborate article Eric, very useful and informative
Thanks, Daniel. I have a "writing memory". If I want to remember something, I have to write it down ... and these days ... I'm writing it directly into a blog post .
Thanks for information, this probably will save me from a lot of work in future
Check this info: blogs.msdn.com/.../index-hinting-in-platform-update-for-microsoft-dynamics-nav-4-0-sp3-kb940718.aspx
Thanks, Martin. That is exactly the info we needed... .
you said that it accumulates previous hotfixes. does that include KB931841, KB933727, KB936602 and KB938138?
So correct me if i'm wrong: if we update to this version, to preserve exact same behaviour as previous versions, we have to
INSERT INTO [$ndo$dbconfig] VALUES
('IndexHint=No’)
on each installation. Correct?
Indeed, tested and approved.
It would be great if those sessions could be recorded and made available for download.
Ok, I will do my best.
Basically Microsoft at EVERY office have the technology setup to create and record live meetings. This wont be an issue of technology, but one of IP. Basically do they want to share the information.
If the event is sponsored by Dynamics, then I would guess they would want the information shared. If its MSDN paying the bill, then its a different issue. They would most likely only want it shared through MSDN or TechNET. Which sounds pretty fair to me. In that case they can publish it through the MSDN secure downloads section, and make it subject to MSDN NDA which should cover all bases.
Of course ideal would for this information to be made public.
I talked with the organizers, and really, it's just an infrastructural problem.. .
Hehe! Somehow with my almost 20 years in the industry (17 with Navision) I sort of have heard this story before! Incompetense! But you not only find this with Microsoft, but in general with most companies in the industry! It's sad...
But to you entry about the runtime license. What should actually be the advantage of the runtime license over the normal licenses?
Very simple: the price. Runtime is cheaper.
Ok, good reason, but by how much? And aren't there any other downsides than the fact you can only run one database? And what about the default databases (master, mdbs etc)?
How much I don't know. It depends on the reseller price. The difference was about 5250 EUR in our case.
Also ... it's a full SQL Server. master, mdbs etc are all include. they don't count as a Dynamics database.
How they check it how many database are installed, I don't know. I even don't know if it is checked at all ...
Ok! I'm basically asking not so much for the reason of Dynamics - more because I'm currently running this website on a SQL Server workgroup edition, and was interesting if it was better to change this with a runtime version!
As far as I understand, a "Runtime" is compiled for a specific product (in this case Dynamics). I doubt there is a runtime for community server.
Ok :(
Hey get them to see if they can contact the MSDN or TechNET people, since they are the experts in that area.
HeHe
The runtime license is a fully functonal copy of SQL. The only difference is the legally allowed use. You are restricted to running only the application with which it was supplied.
With publicly accessible SQL servers (i.e. Websites) the only valid license is a processor license. Microsoft requires this because you cannot control the number of people connecting to the system. Also with processor licensing all Microsoft software, on the server, must use processor licensing. That mean both Windows Server and SQL.
This can be an issue for Navision sites that expose access to customers via websites.
Thank you. Very helpful. It would have been nice also to have the release dates in the list.
Very useful list! Many thanks to you.
I have a suggestion too:
Could you make the Major Release Version be a hyperlink to the download page in PartnerSource?
My understanding with the runtime license is you can't use external programs to access the database either, if you want to run some web services or something to connect to your database you need the full version
Note: Microsoft SQL Server 2005 Standard Runtime Edition is sold on a per “NAMED” user basis. This requires a customer to license a SQL User for each person accessing the system. The number of SQL users must be equal to or greater than the number of Professional users on the license. Microsoft SQL Server 2005 Standard Runtime Edition is licensed only as a platform to the Navision product. A full SQL license is required to support any third party products including, but not limited to, other Microsoft products not sold on the Navision price list.
I've got build number 22979 but I don't found here (4.0 SP2).
Thanks.
Asier
could it be a private hotfix?
----
I added the links to the major releases. The older versions didn't have one page with all country versions, so I just picked the NA or W1 version... .
Enjoy!
Pingback from microsoft » New Release Date for Microsoft Dynamics NAV 5.1
Pingback from Xbox » New Release Date for Microsoft Dynamics NAV 5.1
Pingback from New Release Date for Microsoft Dynamics NAV 5.1
Not really a surprise. But it's "nice" to see it on writting. Changing the version to 6.0 really does make sense.
But who want to bet that we don't see it until 2009?
Version 6.0 it’s almost a completed redesign of Navision. So it’s natural that MS is trying to achieve a solid product and it takes time.
Erik I also bet in 2009...
Well ... the release date is always W1, so I guess any localized version will be in 2009...
I am not betting on anything, but I am not expecting anything in 2008.
Well we need W1, then we need Localizations, then we need six months before we see the Upgrade Took kits, so...
Lets get back to selling 5.00
I think using sp_create_plan_guide with OPTION (RECOMPILE) may be the best solution.
SQL don't select the right index because of plan cache and/or OPTION (FAST xx).
In sql2005 the recompile is more selective than in sql200 and that may be one of the reasons for this problem.
Using Index Hints will forse SQL to use ineffective index.
In my NAV 4.03 running sql2005 I have found 18 selects with bad performance because of wrong index. After insert of selects in sp_create_plan_guide performance is fine.
I this way you keep recompile on a very low level.
Did you see the post at dynamicsuser.net
Pingback from Microsoft?? SQL Server??? Reporting Services and Style Sheets …
Hey Eric, thanks for this, pity we cant have this in all countries, but at lest with your Blogs we get some of it.
Keep up the great work.
Hi Waldo, thanks for the update. Really nice for the ones that couldn't make it to the conference. Some people work, you know ...
Regarding the sure step methodology:
Sure Step does not oblige to implement full blown methodology as it provides guidance for all types of projects in all types of companies. That means that it provides guidance for a large complex project in a large company as well as a simple project in a small company.
The tools and the approach of the project manager in both scenarios will be necessarily different.
Except for that sure step is providing a lot guidance and tools that are accepted by all standard project management methodologies (prince2, PMI, ...). These tools are at disposal of the project manager when he thinks he needs them.
It is my personal opnion that if you want to implement Sure Step you need to be familiar with standard project management techniques (check my blog regarding a number of these basic techniques. If you master these techniques, sure step will not only be a nice tool. Only then it will be the key for your project success! If people don't master these techniques, sure step will only document their failure.
Good news is: Plataan offers not only sure step training (in 2 formulas: overview and in detail) but also standard project management training.
Cheers, Vincent - Dynamics MCT
PS: keep on updating us through your blog about Convergence. Super!
Thanks for the update, Vincent. I know there is a lot of Sure Step knowledge with you ... .
Thanks for that info... :-)
A man is trying a very unusual way to propose to his girlfriend. He wants people to forward an email to as many people as possible and he hopes that it will eventually get to his girlfriend. Details here: www.proposal-to-mary.com
Here is what he wants people to send by email:
You could help me a lot to spread my proposal to Mary – it is important that it is distributed as widely as possible so that it eventually reaches Mary. If you would like to support my proposal to Mary, please send the following text by email to a lot of people :-)
------------- SNIP (email text end) ---------------
WHEN YOU RECEIVE THIS, PLEASE HELP TO DISTRIBUTE IT TO OTHER PEOPLE!
For a long time I have tried to find a special way to propose marriage to my girlfriend Mary, whom I know for five years now. I wanted it very special, romantic and memorable, something our grandchildren would still remember.
And here is my idea: I will send out the proposal to Mary to 50 complete strangers, people I don't know - hoping, that they will forward my proposal to as many people as possible, which in turn forward it etc. And some day, I hope, it will reach Mary, after it has travelled a very long way. I know, it will take a long time and I am quite nervous…
From the poem MY Mary will know immediately that the proposal is for her.
I have created a homepage ( www.proposal-to-mary.com ) where you can find the current status of my quest. You can use the homepage to check if the proposal has already reached Mary (in that case it is not necessary anymore to forward the mail).
Once the proposal has reached Mary, I will put a note on these pages. Also I will publish there how many people have read the proposal so that everybody can see how far it has spread and that it is getting closer to Mary.
And of course you will find there what I am waiting for most: Mary's answer! I can't tell you, how nervous I am… Will she accept my proposal? Will she like the unusual way how she got it, through the hands of thousands of messengers all over the world?
Please cross your fingers for me! And please - help me by sending the mail to as many people as possible, to help it spread, so that it eventually reaches Mary.
And here is my proposal:
Mary, please forgive me, as you know English is not my native language. And I am not a poet. But I mean it from my heart.
My angel,
Five years ago, I will always remember the day When fate made us meet, blissful Alaskan moments in May Earth spun around us and a journey began Love, warmth, happiness, enough the years to span.
The longer it lasts the more grows our bond And with 80 still - of you I will be fond Whatever happens, I will stay at your side Through good and bad, together let us stride
No second with you was ever wasted
You are the sweetest I have ever tasted
We have spent so many years - why not a life?
Mary, will you marry me - and become my wife?
Mary, if you have received that and have recognized me, then give me a sign so that I can continue with the romantic part of my proposal…
We were close to rolloing out our fundraising group on V4 when our partner tested and upgraded us to V5. We are now ready to cancel the rollout because of poor performance. MS said they are working on the speed issue but could not give me a date.
That's what I call cross-selling. Anyway: Thanks for the interesting blog.
I was really happy with the new format of this presentation. Last year it was very technical, and in one hour you just can't do that. This years presentation was a great overview, and the sort of thing that lets you know all the areas you need to look at, and some starting points of where to go next. Think of it as "Hello World" for people implementing NAV on SQL.
I agree ...
Me too.
Last year it was all new but it seems that the basic knowledge is generaly available know.
It is up to methodolgy and partner community now.
I love being part of the SQL Perform community.
Part? I think you run that community ...
Only in Holland and Belgium :-)
Well, I as a competitor of SQL Perform ;c) found it somewhat annoying that permanently the SQL Perform Tools were mentioned ;c)) ignoring the fact that other magnificent optimization software is availabe, too ;c)))
But seriously: even from a more objective perspective I think it was too much advertisement and less content. I prefer last year's session.
As expected, Agiles started out with some figures about themselves: Australian NAV partner sincs 1993
Pingback from Techy News » Blog Archive » Directions Diary - ISV Session - Handapps: Mobile Solutions
Great post! It sounds like Directions is much better than Convergence!
Hello Waldo and others,
I am Mandy Dore from agiles, who presented agileWorkflow yesterday at Directions 2007.
I thought I should let you know that agiles are a Germany company, based in Hamburg. I am orginally from Australia, hence the confusion. :)
Also, the Markant example was not intentially made complicated, but yes you are right, they did have complicated processes that were made simple by the implementation of agilesWorkflow. But Markant is just one example.
It is quite difficult for you to convey all the information from the session into a short blog, so for those who are interested in understanding more, please contact me directly on mandy.dore@agiles.net.
And Waldo, I would love to make you fully convinced, ;) so let's discuss it further together.
Mandy.
Ai, didn't expect anyone to read my blog .
Was it Helen who spoke at the session?
Wasn't this a bit strange session title? I mean at what point are anyone migrating from C/SIDE (short for client/server integrated development environment) to SQL. Based on what you described above it sounded more like a session on migrating from the native database to SQL.
Well but still interesting!
Well I think a lot of people are reading it. In fact more than the view number say, as the view number doesn't include those who read it from RSS...
It is. Based on a short description from Mark, it's basically "how to upgrade your C/SIDE database to SQL without losing your client".
Actually the real session title was "changing alphabets", but that doesn't say much to most people. That's why I changed it to "Migrating from C/SIDE to SQL".
I can't say, because I arrived late at the session, and I missed that ... .
Ok, I just ask because I have know Helen Russel of SCS for many years. She's a very nice lady, the owner of SCS...
Nobody like that anyone is getting something before others. And especially in the Dynamics NAV world there has always been a lot of jealousy between the partners. And now after MS introduced the MVP's, then they just point their eyes toward the MVP's instead! The only real difference is that before MS, all the beta programs where secret!
Btw. what is a PAM?
The sessions at Directions sure sounds much better than Convergence! I know they will have it next spring in Paris, but does anyone know when?
Interesting post, and a subject close to my heart - glad to see it's being discussed.
I think the maintaining of correct object information in Object Designer should also be included in the discussion on standards. How many times have you seen an object marked as modified, with no version list change and no comments in the Documentation trigger?
Thanks for that info. Good to know that...
If I'm not mistaken, the Paris Directions will be held from 16-19th of April 2008.
I asked and yes, it was her .
PAM = Personal Account Manager.
It the first point of contact at Microsoft for a MS Dynamics NAV Partner
And guess what other event is on that week
Yeah, that sucks. I really would have liked to go to the summit.
As Eric wrote in the previous Blog posting (dynamicsuser.net/.../platform-updates-overview-3-70-b-5-0.aspx):
"It would have been nice also to have the release dates in the list."
Please try to get and publish these dates. Thanks for your affords in advance.
P. S.: Still a very usefull overview! *Thumbs up!*
FYI: There is a new (updated) posting by waldo availible:
dynamicsuser.net/.../platform-updates-overview-3-70-b-5-0-update-1.aspx
Thanks for the blog Waldo!
I really enjoyed presenting and preparing for the event. Thank you for your input.
I noticed that a lot of people just do not know the risks in migrating until their fist project fails.
Good thing that Micheal Nielsen, Kim Ibfelt & Darren Layborn were there and noticed the issue.
It did put a little extra pressure though to have these guys on the first row.
Funny also to see a blog about my own session thinking I was the one who started blogging at TechEd only 18 months ago.
Now I am presenting myself...
No prob, glad that I had the chance to review the slides, else it wouldn't have been so good hehe.
To be honest, the slides and the structure of the session would be a good beginning for some kind of migration course. May be a chapter for in Dave's next book?
What I will do is migrate the slides to a whitepaper and upload to the downloads of our forums.
That would be very useful.
It doesn't have to be a white paper, "best practices" is also good .
I didn't search yet, but can you point me where I can find the release dates?
Furthermore: the links didn't work, but now they do .
I'd like to add this one:
4.00 SP3, Update 7, Build 25307, KB943227
As I am working as a freelancer I do not have the rights to view the microsoft knowledgebase. Is it possible to publish this information here.
For those that are also working as freelancer and not being a MVP how do you get the latest information about the Dynamics products?
Greetings, Remco
I don't find anything about KB943227. Jorg, can you give an URL?
mbs.microsoft.com/.../KBDisplay.aspx
Here's the link.
Remco, that is the reason Eric posts it. He is getting it because he pays MS a lot of money and shares it for free afterwards.
There is no way to get access to partnersource as a freelancer. If you want an update, contact the partner of the customer you are working for and request it. You should never implement a hotfix anyway without telling the partner.
That is not entirally true. As partner, you can get the info from partnersource. You don't need to pay extra.
We have a PABS agreement that gives us many advantages. Amongst the advantages is proactive info. When something interesting is published on partnersource, I get it by mail. Now, I must say, most of these kb articles were NOT sent by mail!
I updated the list with update 7.
Hé Mark,
I know the link, but the that doesn't solve my problem. I will try if the partner will give me the extra information. And off course the partner does know that i'm using this hotfix!
Greetings
When I was on the plane to New York a few weeks ago (After Convergence, but before Directions), I wrote
The "Error" bug in CU 1 is known. It is problem of the CU1. Workaround is to call message instead and right after the message call Error(''); It will work as error, message will be showed correctly (but just with the "i" icon instead exclamation).
I talked with some developers about this, and it was indeed quite known. The workaround with the Message and Error('') I did not get from them and I will test it out... .
Thanks, Kine!
Thanks Eric! It workes!
Almost got it right ... changed the "low changing fruit" to "low hanging fruit" .
Hi Waldo, nice blog-article. I will refer future students to this when explaining when to use the fob and when to use the txt format for objects.
Cheers
Vincent
Microsoft Dynamics MCT
Hey, that's cool .
I wrote the article, but I was doubting to put it online. Glad I did though .
Yes Eric, very useful blog, I am sure it will help a lot of people.
Just to add to this, you can also do this in the normal C/SIDE editor without every having to export anything. Like this:
Find all the objects that have the Optin used.
Open the object, and start to save it.
At the prompt to save Yes/No de-select the object to compile.
(So save the object un-compiled)
Repeat for all objects.
Now go back to the tables with the Options.
Change the option string.
Repeat for all the required tables.
Now select all the objects that are un-compiled.
Hit F11.
Since the objects were saved in text format, its just like using a text editor, in that the integer value is not used.
Thanks for sharing this, David.
It actually makes we wonder. If you save the object uncompiled ... and you export the object ... do you get the text file in stead of the fob file?
Yes that's correct. If you export an uncompiled object, then you only export the text. When you compile it you export both the executable object AND the text.
An extra remark for adding an option to an existing list of options:
Not just add it to the end, but add some , before it.
In general I start to use the 20th value for the next option. This way, you leave some space for future standard options.
E.G.
"FIFO,LIFO,Specific,Average,Standard"
becomes
"FIFO,LIFO,Specific,Average,Standard,,,,,,,,,,,,,,,Waldo"
If tomorrow MS decided to do this:
"FIFO,LIFO,Specific,Average,Standard,Some MS Value", you do not need to change the value of option "Waldo" in the database.
Also use this in the option-captions.
The beautiful thing is that the empty option-values are NOT shown between the possible option to choose from.
I wrote the below blog some time ago (right after the session) but I was waiting for te slides to complete
@ Find statements: Steven said MS is "beginning to" replace the FIND('-') with FINDFIRST where necessary, in their new development and in the code they "review" (that's what I understood).
He DID say that these 2 statements did two different things... :-)
If you need the ppt, I can send it to you (left you a message via "contact").
@ Find statements: let's just say that things are not clear yet, and are still not clear for many people .
I did not get a message yet, but thanks already .
It has been on partnersource for a while now, but I wanted to highlight it again. Microsoft assembled
I recieved the slides from one of the attendees (thanks Bram De Daele ). It isn't available for download
Here is your reporter back with more news about the Belgian MSDN/Technet evenings . This time, the topic
Did you see this post at dynamicsuser.net
Indeed, we have such a recording device and I really hope that we'll be able to record all the next sessions. In the near future we should also get a second device so if there are more sessions at the same time, we'll record them all. See you next time.
There is an interesting post over at dynamicsuser.net
Pingback from Pages tagged "microsoft"
Great stuff! I was actually working on a private NAV-ADO project at the very moment I noticed your post in Google Reader :-) My project might show up in the Mibuso downloads if I get it to work ;-)
Only comments:
* You should mention the risk for SQL-Injections. An evil person with permission to create companies could execute any SQL statement in your database impersonating the service user with this solution.
* You should mention the possibility of using "Integrated Security=SSPI" to use the credentials of the current AD user instead. (Some times it is a better solution, sometime not)
But a yet another great article - keep'em coming :-)
Thanks pdj for this info. It is indeed something to watch out for. I know I didn't handle security very well in this post, so your comments are very valuable... .
Just wanted to wish y'all happy holidays!!! To cover everyone, here are the greetings in most languages
Recently, I had to do a small project. A client of us wanted to see the global inventory of all its companies
I have two new build Nos
5.0.25581.0 (KB944919) latest one!
5.0.24632.0 (KB936885)
Do you have URL's as well, because i can't find them in the knowledge base?
Pingback from waldo’s blog » Blog Archive » Using ADO & Stored Procedures in C/SIDE
Pingback from waldo’s blog » Blog Archive » Merry Christmas & Happy New Year
Pingback from waldo’s blog » Blog Archive » Platform updates overview ??? 3.70.B ??? 5.0 Update 1
You don't need to know any URL if you know the KB No.
Example for KB944919:
Directions EMEA 2008 : http://www.directionsemea.com/
And what about update KB945349 for 4.0 SP3?
You're right. I added this one.
It seems that I don't get proactively informed anymore .
Thanks to Natalie, I added two more updates on 5.0. This is the new overview. Released Version Update
Waldo, I think that you have mixed up some info:
KB 945349 (4.0 Update 8) includes two Build Nos.: 5.0.25653.0 and 4.0.3.25638.
Hence 4.0 Update 8 has to be Build No. 25638 instead of 25653 in your list.
Build 25653 for 5.0 is missing.
:-)
You are absolutely right. Thank you very much for the info.
It's becoming quite complicated with all those updates I must say.
It is not too late ... but still late. I haven't said a word about Directions EMEA 2008 yet, while
I am happy to announce Outlook Integration Update for Microsoft Dynamics NAV 5.0 . This update is now
Does anybody know why they changed Codeunit 418, 448, 449.
I couldn't find anything in the whitepaper or website why they changed the objects.
I'm kind of in doubt here. Especially after reading the different KB articles.
With a fresh new SQL 2005 64bit server and NAV 4.0 SP3, which update should we take?
I would go for Update 8.
Where can they be downloaded?
This is explained in the KB article. You have to request the hotfix from Microsoft.
This is a very challenging blogpost in my opinion. I see many stories going around on what would be the
Interesting!
Looking forward for article "monitoring your code"
Great Post - Lots think about !!
Does 2.6 support x64?
No, it does not, I'm afraid. You need a special x64 xp_ndo.dll as well.
Is a runtime upgrade an option?
Well, we are currently using 2.6/2000 and looking to upgrade the server, trying to take advantage of more RAM, but only can with x64
Indeed ...
So, given the info above, it looks like AWE as you describe would be our best alternative, right?
Indeed. The switches in boot.ini and AWE in SQL Server seem to be your things to use...
To avoid the "NEXT FROM HELL" (this perfectly describes the proble!), my advice is:
If you have a loop and in it you want to change a field, ALWAYS use a second variable. Why do I say this?
1) this rule is easier than "If you have a loop and in it you want to change a field and that field ........."
2) If you don't have the problem, but later some other programmer (or also you) has to change another field in it it can become a "NEXT FROM HELL" and you have to change your code (and most of the times the other programmer doesn't do this!).
Great post.
Clears the fog somewhat ;)
What I miss in general is the behaviour using the MARK functionality as it also is a way of filter data. Sometimes I use MARK instead of a second record to avoid the "NEXT TO HELL" trap.
Please, try to avoid using MARK on SQL Server.
It is very difficult for SQL Server to figure out what to do with it. It is not unlikely all queries will result in table scans - many database calls - or whatever - because it is not possible to use a decent filter (which results in a decent WHERE-clause in SQL Server)... .
Interesting post. But what about using any secondary key in a Findset-Loop?
Your results on counting fetches and/or selects would be heavily different. I recommend using a FINDSET only in loops wehre you know that there are less than "500" records in the resultset. If you are using FINDSET with a key different to primary key you will cause many selects. The "select top 501 *" do not create a trigger, so there ist no way to fetch the next records behind 501.
By the way, it's the same damn thing when you are using a FIND(-) in a loop with modifying records. If you do not use locktabe (or findset(true)) you will get many new selects while looping if you use a key different to primary key.
Thanks once again for the extra effort you put in to help the NAV developers of this world. God knows we need all the help we can get.
When is the book "Advanced Dynamics NAV Programming" going to be published?
A very good post! Keep them coming and soon you have material enough for the book!
Actually I also got a question on this I would like to hear your experiences on.
A long time a go I was told that using the MODIFYALL was always a very good option. But how is SQL Server actually treating this command?
I mean if I need to update two fields?
Example 1:
SETRANGE(MyField,'FILTERVALUE);
MODIFYALL(MyOtherField,'NEW VALUE');
MODIFYALL(MyThirdField,'ANOTHER NEW VALUE');
Example 2:
FINDSET(TRUE);
REPEAT
MyOtherField := 'NEW VALUE');
MyThirdField := 'ANOTHER NEW VALUE';
MODIFY;
UNTIL NEXT=0;
Which example would be better?
And what if ex. we had to call the VALIDATE trigger?
I think example 3 is best:
RESET;
SETCURRENTKEY(...);
SETRANGE(MyField,'FILTERVALUE');
FINDSET(TRUE[,TRUE]);
recOtherRecord := rec;
recOtherRecord.MyOtherField := 'NEW VALUE');
recOtherRecord.MyThirdField := 'ANOTHER NEW VALUE';
recOtherRecord.VALIDATE(MyFourthField,'YET ANOTHER NEW VALUE');
recOtherRecord.MODIFY(FALSE); // or (TRUE);
And if you have a VALIDATE-trigger, it is impossible to use MODIFYALL.
Nice article, it's indeed a smart idea to use the SQL profiler in combination with Client Monitor to find how record set manipulation CAL get spitted out in SQL statements :-)
Best Regards from France,
Tarek Demiati
Freelance Dynamics NAV (Navision) Developer
Thank you for the kind messages. Who knows there will be a hardcopy bundle some time .
Let me create a "part two" blog post where I will handle MODIFYALL, DELETEALL and MARKing records, OK?
That's what I say Eric, soon you'll have enough for a small book!
Few new articles about NAV on SQL released by experts: Lars Lohndorf-Larsen article "Record-level locking
Hi Waldo, have you ever done this for a SQL 2005 database? We have some code that worked on SQL 2000 and now get an error saying that the SQL-DMO cannot be used to connect to the server and you must use SQL Server Management Objects (SMO) instead.
Hm, strange. I wrote the above using an SQL2005 database...
Problem
Solution
First install the client and then install the roll up patch.
That is absolutely right ... and that counts for all platform updates. You have to have an installed client of NAV, else it won't find it to update... .
This is a problem for partners/developers/consultants, but usually not for end users.
Great you keep this up to date Waldo. I always read your Blogs with great interest. However you have misunderstood microsoft's update system.
Updates are a collection of KB's issued as an update. For 5.00 there is only one and that is KB 943858
The other once are hotfixes or stand alone KB's if you will.
You are btw. missing KB 948512 on SQL performance.
Keep up the good work.
Cheers,
Soren
You are absolutely right on that one, but I was already aware of it. It just makes life easier. Talking about Service Packs, Updates, Hotfixes, KB-articles ... it's just too complex.
Actually, I wanted to do it like Update 1.1, Update 1.2 and so on ... Probably, when Update 2 comes out, I'll rename them ;°).
Thanks for the heads-up!
I can't find the hotfix you mentioned, by the way. Is it a private one?
I had this issue at a customer of ours. The error message " Login failed for user 'sa' because
I guess the KB is not publich jet, but it is on the way. I just know it because I have the files and KB here for testing and it finally solves some the the crazy performance issues we have been fighting with since the release of 5.0.
hi just a little question for you....can you tell me what does mean h1 cy2008?...sorry may for the ot...thanks a lot bye
I wouldn't say - I still recommend for just adding the options at the end of the string.
The best way is to set it to the End plus about 10 commas.
So not
FIFO,LIFO,Specific,Average,Standard,Waldo
but
FIFO,LIFO,Specific,Average,Standard,,,,,,,,,,,Waldo
The reason is very simple ... merging.
Hi Waldo,
there are at least two new ones:
4.0.3.25709 in KB946247
5.0.25344.0 (only SQL) in KB943581
Refer to mbs.microsoft.com/.../KB__NAV.htm to find perhaps even more.
When you make tables please tell the contents refers to what and please be clear when writing the stuff as some people are not up to your level
All I can say is that I do my best in being as clear as possible :|.
Here is the next I-think-up-to-date version of the Service Packs/Updates/hotfixes/Knowledge Base Articles
Any problems with tending to help you? ;-)
As you did not seem to know the page with the latest KB article summary yet, you perhaps don't know this one where I took it from, too:
Hot Topics Navision
mbs.microsoft.com/.../navision
The site looked different until February: there were many KB summaries (for each month back to 2006 or 2007). It is a pitty that MS now has erased all former infos :-/
I love your help! It makes my blog definitely more valuable .
The site you mentioned is now in my "favorites". Thanks for that!
One word on this blog: WOW!!!!!
Is that an abbreviation or something :)? For World Of Warcraft? Or Windows on Windows?
.
Thanks, Kriki .
Since a few months now, we have been working on a new initiative in Belgium: the Belgian Dynamics Community
Hi,
Please I need someone to help me out urgently.
I have installed SQL Server 2005 and Navision client (sql server option) on my system and I was able to connect to the database, restore data and do all sort.
When I tried connecting from another system, a got an error message cannot find server. I typed the serverpath and name but it still gave me the same thing. Could this be because the systems are in workgroup not domain? Or do I have to set anything on the other systems? (Like the host file when using the native database server). Please help me out
Secondly, I dont know how to bring the stored procedure into SQL, I have already unzipped the xp_ndo.dll file into the binn directory of SQL installation. Can anybody send me the codes on how to do this.
Please, I'll appreciate your urgent response.
Thanking you in anticipation
You can reply back to debby_box@yahoo.co.uk
I suggest that you open a new thread on Mibuso for that ... then more people will respond ... .
When you copied the xp_ndo in the binn folder, you can add the extended stored procedures by adding them manually on the master database.
Just wanted to say thanks again for this post. I am currently going through some issues with NAV 5.0 SQL 2005, etc. which requires applying some of these updates to try and improve performance.
I know that in order to check if I have applied the correct version I can find the build number (Help, About, Double click on the Version No.) and then Google it to find which update it is. The Google link returns this post. Very useful!
but from where can i download it, on microsoft they say that there is an update named KB 931841 but they don't give the link!! on this link : mbs.microsoft.com/.../General.aspx{1A824679-0B9B-4BA7-BF5A-C6EB77FC43B3}&NRORIGINALURL=/partnersource/products/navision/newsevents/news/msdynav40_sp3_officevistacompatb.htm?printpage=false&NRCACHEHINT=Guest&printpage=false&wa=wsignin1.0 ... i ca't find the update ...what can i say "i love microsoft"
Plese help
Thanks!
Are you serious? I wonder if "live" would give the same results .
May be this can help you:
dynamicsuser.net/.../platform-updates-overview-3-70-b-5-0-sp1.aspx
Recently (last Thursday) I joined the MSDN Evening, organised by Microsoft, to learn more about how to
Actually it's no wonder that you've been found in google ... msdynamics.de is not the only community that links to your blog, quite sure ;-)
On monday, I will be off to Convergence US 2008 in sunny Orlando . I have some mixed feelings about it
Have fun at Convergence and looking forward to your blogs.
Thanks, Rashed.
Have fun! And say hi to everyone I know.
/Mark
Have a great time Eric.
i for one will be waiting in anticipation for the high quality blogs that you are now famous for at these events.
Sorry that you are there "alone" this year, and good on you for going.
It seems that I will not be able to attend many sessions this year. Too many things to do behind the
Good stuff Eric, keep it coming! Wish I were there.
Thanks, Daniel.
By the way, I found the book that Scott recommends: It's the Wrox one: www.wrox.com/.../productCd-0764584979.html
A simple way how to handle different Company-Names would realy very much apprichiated. The report should be able to let the user select the company and an sp is generating an dynamic select statement. Anyone has an example how to solve?
C#/VB: Many reports do have attributes on wich you can define the value with an expression. Within this expression, you just can use VB. It took me a long time until i recogniced that my C#-Code ist not valid despite of the framework.
Very good blog by the way!
Today, it's not a NAV day at all. Very few NAV sessions - and actually not one where I'm interested
I like you lively writting style. It's easy to read in one go even bigger posts.
Thanks, Bruno.
Now, i'm not an RS specialist. But be careful of making your stuff dynamical. You should consider to not making SP's, or SELECT statements dynamics because of the fact that it won't be cached (as also mentioned in the blog)
Eric,
great stuff, keep it coming if possible. Its a pity that your "duties" are keeping you from more sessions, as I would love to read more of your blog posts. It sounds like you have your plate full being there alone.
Yeah, well, me being here alone has something to do with it :).
It's going to be a busy day. Three sessions and quite some work at the booths. I love Michael Rosenorn's
I would like to know if they are going to change it to web service in 6.0. That way they can get rid of commerce gateway and don't have to use NAS.
It'll make the setup a lot easier.
Martin Nielander (from the systained engineering team) and Jesper Reabild wanted to give an overview
This session is presented by Michael DeVoe and Robert Miller. They're both really good, so I expect
This session is driven by Chad Aberlen, one of the Microsoft Escalation Engineers. Most of his expertise
Those tools must be made available on SQL Server, so we can schedule them without having to install the Job Queue. Can you ask while you're there?
I'm willing to think about auto update statistics, I've read a lot of comments saying that it's really not that harmful. However I find the logic flawed to use autostats as well as a routine that manually does it. If auto statistics is so great, then why do we need any tool to update the statistics? Likewise, if you create a tool to update statistics manually, why would you also need to automatically update statistics?
Then I also strongly disagree with having a tool create indexes on SQL Server that don't exist in the NAV table design, I would never recommend that either.
This all sounds very negative, but I am really very happy that they are working on this. It is very good to see though that they are addressing this need, very positive.
[quote user="waldo"]
Keep in mind, if you want to go to the NAV2009 RoleTailored client, you'll have to upgrade to the latest version (5.0 SP1).
[/quote]
This reminds me, I have been trying for about 18 months now to get an answer of whether there will be a Data conversion required for 2009. Have they stated anything yet about that.
No official confirmation yet. And if you ask, they say something like "we are indeed really trying to avoid a datamigration".
Personally, I can understand why they want to keep their options open. You never know what the future is going to bring... .
@Waldo: If the future is not yet made at this point (Q2), availability of NAV2009 in Q4/2008 is not an option.
PS: Waldo, thanks for the great job keeping us updated!
Pingback from Neuerungen im Service Pack 1 für Microsoft Dynamics NAV 5? » Blog der Microsoft .NET / Dynamics NAV - Group Halle
I have some time on the airport to write down some final thoughts of what this Convergence meant to me
Sounds over all like a great event then. I am so glad to hear that it was better than Copenhagen.
I really appreciate reading your blogs, they really do help everyone.
Great work Eric.
Glad you had a good time, but reading your notes I am happy to have staid home altouhg I would have loved to spend some time with Olga to. :)
Excellent series of blogs Eric, thank you very much for taking the time.
Hm, didn't you read the part "This was by far the most interesting one - as well as personally as professionally" .
Just wanted to point out the good AND the bad.
Thanks for all the info Eric
Great blog! It's almost as if I'm there, but not really.
Thanks for the comments, guys .
Funny, these "Performance Optimization Tools" grow like mushrooms ;c)
Is it also "free-of-charge" - as my "NAV/SQL Performance Toolbox"?
It is free of charge for partners. And they were looking into it for making it available for customers via customer source as well ... but couldn't confirm if this was possible or not.
>This sounds cool, but really ... I want to do this from within SQL Server, not from within NAV
>The next tool, SQL Index Defragmentation Tool, works with the sys.dm_db_index_physical_stats DMV. You use this to defragment indexes, which can have a noticeable impact on performance.
I would like to share a solution for doing dynamic index optimization, with the Navision community. It's a stored procedure that does index rebuild online or offline, index reorganization, statistics update, index reorganization and statistics update or nothing based on fragmentation level and LOB existence. It's using sys.dm_db_index_physical_stats just as the SQL Index Defragmentation Tool.
blog.ola.hallengren.com/.../3440068.html
blog.ola.hallengren.com/.../Documentation.html
This reduces the time it takes to do index maintenance considerable. It also reduces the sizes of your transaction log backups during the index maintenance.
The solution has been very thoroughly tested and it has been running on a large Navision installation for about 6 months.
Ola Hallengren
http://ola.hallengren.com
How do you see these tools as compared to the other "tools" available for SQL performance optimization? I am here thinking about the ones from SQL Perform and the other companies specializing in this.
Ola, thanks for sharing!
Eric, I would still go for the SQLPerform solution myself for the reasons I mentioned above. It's a maintenance tool, but it still needs some work for sure... .
Pingback from dynamicsuser.net/.../new-release-date-for-microsoft-dynamics-nav-5-1.aspx
As promised, 5.0 SP1 W1 is available for download . Versions W1 (WorldWide), DK (Danish), DE (German
Just a pity they release it just before they take the site down for maintenance. Did anyone manage get it before they took partner source down?
[quote]Our Apologies
From Friday March 28th, 2008 at 6:00pm to Monday, March 31, 2008 at 2:00am CST (GMT -6:00), VOICE, PartnerSource, CustomerSource and Commerce (NBE), CLT systems will be unavailable as they will be down for maintenance. [/quote]
I see the new Microsoft Web site just came on line, so I guess this is why partner source was down. Hopefully we get a new version tomorrow (of partner source I mean).
I did see the pages on partnersource, but I was at a customer, so I didn't download it yet. Now, PS is off line ... . Too bad indeed.
Pingback from ServicePack 1 für Microsoft Dynamics NAV 5 verfügbar » Blog der Microsoft .NET / Dynamics NAV - Group Halle
I just couldn't resist posting these links: The Waldo Ultimatum: www.youtube.com/watch
He doesn't remember who he is because he left his passport in Mexico :) Stay tuned for the sequal 'The Revenge of MexiWaldo'
LOL.
Actually, the problem was just the opposite. I knew who I was, but couldn't proove it - and they DID catch me there :|
Not that i have a slow connection but has anyone noticed that it can be quite painful to get into PartnerSource...
It was down all weekend, so all the people (like me) that do all their downloading over the weekend had to catch up on Monday, so it was just under heavy load. It seems to be ticking along nicely now though.
The Waldo Ultimatum is great. Obviously someone with too much time on their hands but definitely fun.
PS I forgot my Passport at Disney after Directions, so you are not the only one. Ended out stranded in NY till they found it. But not anywhere near as much fun as your Mexico story.
Thanks again Waldo. Every time I need to get to the 5.0 SP1 download page, I know the easiest way to get to it is via your blog. Much easier than searching on PartnerSource.
Yesterday, I got the message that my MVP-title has been "renewed". I must be doing something
Congrat's to and keep those blog's comming...
I sure will :-)
Keep good work
Congratulations both of you!
And keep the blogs coming!!!!
congratulations !!!!
Well done.
Excellent news Eric, well deserved, congratulations!
Thanks for the kind words, guys.
Well done Waldo. You fully deserve it.
Cheers, Dave.
Sorry for being a newbie at this, but what do you mean by "Runtime Upgrade to Vista-supported clients"?
Well, that's actually an upgrade of only the client. The functionality stays the same. I actually comes down to using a new version of the fin.exe or finsql.exe .
I was told today by our Solution Center and have since verified for myself, that NAV 4.0 SP1 seems to work just fine on Windows Vista - so long as you're connecting to a C/SIDE database (if you connect to a SQL database, it bombs out).
Congrats! Keep those blog posts coming!
Congratulation Eric, that was deserved...
Finally found some time to write Part II of this topic. The first part was quite a popular post, if I
There's a reason why some people are MVP's :) another great blog Eric
Thanks for the time you took to provide us with this great info!
Congratulations with your updated status.
Another year of blogging. I'm looking forward to your blogs on the EMEA direction sessions you will host ;-)
Well .. I will not be blogging my own session, off course . Maybe afterwards, I will make a blog of the contents ... but that's a big "maybe".
It has been a while. Not much has changed, just the SP1 is now officially released (but I already added
Yet another great entry in your blog. Just sad this overview isn't available directly on PartnerSource :-(
I would suggest you added some similar links for SQL updates:
support.microsoft.com/.../913089
support.microsoft.com/.../LN
great Blog wWaldo,
i was wondering about the following KB's if they are missing in the summary:
936719
940043
945992
945339
See also:
premier.microsoft.com/default.aspx
You were right .. I added the two new ones.
Thanks, man!
The links to the 1.4 and 1.5 updates are to the premier site which not all partners have access to. (At least I don't :-()
However; if you just take one of the other links to PartnerSource you can replace the kb no. and the links works fine.
Thanks pdj. I updated the links... .
You get access to premier when you get a PABS (Partner Advantage Business Solutions) contract with Microsoft. We have it, and it is linked to the same passport as the one I log into partnersource. So I didn't notice it :|.
Have a look at this - you won't believe it:
Seems my overview is becoming less useful ... or in other word(s): useless .
Still, it's behind the "passport", so it'll not show up in google or anything. I'll still add it on my blog until they make it more public .
Thanks, Natalie.
Nah Waldo,
you're noncompetitive - they do not keep it up to date like you do :-)
Your page is WAY better! More frequent updates. More hotfixes. Links to base versions.
I just noticed that Partnersource now offers a few "public" RSS-feeds, but they are also not up-to-date. Nice work Microsoft :-(
Check it at mbs.microsoft.com/.../rssfeeds
In short: Keep up the good and valuable work Waldo, it is much appreciated :-)
:) OK, I'll go through with it .
Thanks Waldo, for updating the List. Your List has a better overview!
If found another one for 40SP3:
KB 948302
see KB 931638 for a list of 40 (maybe there are more updates in that list for 4.0XX)
You shouldn't even have thought about stopping with it!
New hotfix update (not included even on the official site):
Build 26410
KB 950920 (not published yet)
Type: Standalone files for client and NAS.
It seems that I'm not going to blog this directions. It's a bit akward for me, being able to
Pingback from Kriki’s blog » Moving from native C/SIDE to SQL by Mark Brummel
Well he has some big shoes to fill, but I am sure he can reach your standards. I look forward to seeing this.
I hadn't put this on my blog yet, but people asked me to give a presentation about Hardware on Directions
What format is this presentation in? It contains a lot of xml files but no .ppt or am i missing something?
Great presentation, Waldo. It's amazing to see all of this information collected in one place.
Can I ask you what your hardware recommendations are for the tempDB?
In this thread (dynamicsuser.net/.../114694.aspx)
David had the idea to put it on its own RAID 1 for large databases.
The format is in powerpoint 2007. You can download a compatibility pack here:
www.microsoft.com/.../details.aspx
Definitely for big databases, I would put it on a seperate RAID 1 as well. In SQL2005, it seems that the tempdb is used more then 2000...
I have got good feedback on your session. It were busy days for me, so I missed the time to say hello to you and thank you ....
Thanks, Gerdien. And also thanks for the perfect organisation!
Working on a new update again. Will be published soon enough.
Thanks for the heads up, Guys!
And wito - it was nice meeting you :-)
I think it's a shame you didn't blog here! I remember from some of the other conferences it has been very interesting to see the different bloggers different views on the same sessions...
And then of cause, I also find it a shame that the users here on http://dynamicsuser.net will not see the blogs from Directions...
I am writing the "final thoughts"-posts because it seems interesting for me to have somebody's
Pitty that I missed this one. I hope that next year... ;-) but there is so many events and I cannot be everywhere...
oooh, so that's what waldo looks like :p
@Kine:
I know ... that's what my worry is as well. I'm skipping WPC.
@QQ:
I read your post on mibuso as well. Who the hell were you, man ?
OK ... don't know how to react here...
Great post Eric, we had a great time again.
See you thursday.
I can find some reasons why you were so calm during your presentation:
1) Good preparation.
2) You knew very well what you were talking about. It was not something you learned and just reproduced, but something "you lived"!
I wanted to wait until I received some pictures, but I won't. I'm a little bit too excited about
Great event and kudos for bringing this together. Let me know you if you in the future need any help from the NAV Core team and I will be happy to help you out.
Seems to be a new 4.0 version out:
4.0.3.26410 (from KB 950920).
Also, the build of NAV 5SP1 is 5.0.26084.0.
Thanks
Daniel
we'll sure do! And thanks again, Claus!
Yep, indeed.
I'm already working on a new table and will publish it soon.
I have some new interesting links as well that I would like to share.
Thanks for the heads up!
I can't work in Navision 4.0 sp3 with Vista Sp1
What build?
In a conference like Direcionts EMEA , I noticed again how interested people can be in sometimes such
Do you have a text file of the object that you could share?
Yes Eric, this is a nice simple and neat solution to a very commonly requested issue.
Thanks for sharing it.
I've already sent a link to this blog to customers :)
:)
o-ow, I hope they like it .
@thaugh
I have no .txt available. If you just follow the description, it won't take long, I guess... (I hope).
Great tip. So simple and yet so useful. It's funny how often the best solutions are the simplest.
Thanks again!
I'll start using it with all my customers from now on!
Great!
Hey Waldo! Thanks for the event. Me and the guys (aka Same Same But Different) had great fun playing at the beautiful location! :-)
Keep up the good work!
/Roel
Great tip
The best solutions are simplest - this is really neat and really useful - thanks a lot
There is one more important hotfix for 4.0 - KB 950920, build 26410.
Viktoras
I love this tip and have been playing about with it. I've added a couple of extra features and I'll post something about it when it's done, but I have a question. Is there any way of stopping someone from clicking on the form and pressing ESC which then closes it? Other than setting Close Forms on Esc to No. I tried putting EXIT(FALSE) in the or putting something in the OnQueryCloseForm() but that is BAAAAD and you can't exit the company or NAV. Any ideas?
Thanks. I already added it to my (new) list. Seems like I have to update it asap. Will do it as soon as I sorted out something with Microsoft... .
Thanks, Guys!
@Gaspode: I have been strugling with that myself and I don't see a solution (yet). The only way (for now) is to change the option "Close Forms On Esc" to "No".
But honestly, we don't do that.
Here we go:
Build 4.0.3.26170
mbs.microsoft.com/.../KBDisplay.aspx;en-us;949866">mbs.microsoft.com/.../KBDisplay.aspx
Build 4.0.3.26565
mbs.microsoft.com/.../KBDisplay.aspx$en-us$952355&wa=wsignin1.0
I found one more blog with hotfix information:
blogs.technet.com/gediminb
Hi it's me again. OK so I had a go at doing some things with this idea. If you're interested, take a look at my post on gaspodethewonderdog.blogspot.com/.../where-am-i.html
I did come across a few issues so maybe some of the clever readers of your blog could answer the bits that don't work. Thanks for the inspiration and thanks heaps for posting the idea. Cheers, Dave.
The updates keep on coming ... so we keep updating. If it continues with this tempo, we'll have quite
you should bookmark this one:
mbs.microsoft.com/.../microsoftdynamicsnavsupportnorthamerica.htm
The majority is also useful for non-NAs and represents a great part of the partnersource link list that I have showed you earlier.
wow ... that's an interesting site, indeed.
Going to add it in the next update.
thanks!
Hey thanks Waldo, I was wondering where I should send feedback.
I was just re-reading my post, and should make something clear. With "...but tell them how bad it is", I don't mean that I find it bad, but that you should send the comments on how it can be approved ... not comments like "hey, I like the fast bands" or whatever!
Personally, I like a lot about the new client, and everything about the new integration possibilities. So no complaints here ... .
On the 15th of May, we had our first "real" information evening organised by the Belgian Dynamics
while i was checking the updates that i had to download for the 5.0 release i noticed something in the list. I consider the Build No. to be leading in the above list. KB943581 is before Update 1 and has Update 0.1 as prerequisite. KB945339 has Build No. 25560 (directly after Update 1?).
I also found a new one KB948512 (Build No. 26026)
Well, build No. is indeed "leading".
I didn't know the build no. of KB945339 (therefore the question marks). If the build is 25560, indeed, it should be rearranged in the table.
KB945339 is very badly explained in the article as well. No prereqiusites defined, later build than update 1, only a finsql.exe ... so it's doomed to fail.
I'm pretty sure it is going to need the update 1.
thanks for the info. i'm going to update my table and put a new one online asap.
it's me again! I wrote about different KB numbers!
KB943581 is before Update 1 (< build no.) and has Update 0.1 as prerequisite in the description.
KB945339 is after Update 1. See the SYMPTOMS section in the KB description:
You run one of the following products:
• Microsoft Dynamics NAV 5.0 with Update 1 installed
• Microsoft Dynamics NAV 4.0 with Update 6 installed
Thanks to Nathalie i found out that you can download NAVXX40SP3 including Update 6 (KB940718)!
Thanks Nathalie!
And thank you Waldo for publishing this list!
You are 100%, absolutely, entirely correct.
I already updated my table and it seems I have to publish it asap .
By the way, I'm not a big fan of update 6 - the "locking during error message" makes me not want to use and recommend it. From 6.2 this is solved... .
Hi does it work in acitrix environment running on w2003 servers ?
thx
Jeff
Yes, that should work...
Natalie pointed my attention to the link of the North American Support team. I have "stolen"
Have a nice holiday - you deserve it! :-)
Waldo,
first i want to wish you a very nice holiday. Enjoy it!
KB943581 has Update 0.1 as prerequisite in the description. See the Symptoms section:
You apply hotfix 936885
...
IF you use the download link 4.0 SP3 from the above table:
See the Announcement section:
29 FEB 2008 The local downloads on this page has been updated with Platform Update for Microsoft Dynamics NAV 4.0 SP3 KB 940718
So if you download 4.0 SP3 from Partner Source you now have the one with Build No. 25143!! I think the link to 4.0 SP3 has to be in front of Update 6 now?
Thanks wito.
I updated the table in this post (again). Sorry for this, folks.
They're not making it easy on me .
I think I'm going to remove Update 1 to 6 in the next update.
I'm not agree with you about RAID 5. The best practices on SQL Server 2005, for max performance, (source MCS France) are RAID 5 for data, RAID 0+1 for log, RAID 1 for tempdb.
Last month (23 rd – 25 th April), Claus Lundstrøm and I took to the road and drove all the way from Vedbæk
Hm... you're not going to find a discussion here, I'm afraid. But feel free to discuss this on mibuso to get another one's opinion.
You could go for RAID5 for data (mainly used for reading), but I would never do that. I don't want a write queue ... not even (and definitely not) for the data disks.
But again, feel free for opening a thread on mibuso or dynamicsuser... .
Dear All,
I m using Vista on my system and want to run navision 4.0 Sp3. so can anybody help me out how do i run it.
Time for the next chapter for the "what impact does my C/AL have on SQL"-story. I already covered
Is it possible to run the client without having to elevate the permission level to local administrator ie selecting "run as administrator"? I don't want to give users administrator level access to their machines.
John
Because I'm a Belgian, and Belgium is in group 2, I'm a bit more excited about the Group 2 releases
Yup!!!
It is what I forgot today - check the Patnersource if the version is already released!
Thanks for the info...
Glad I could be of your assistance .
I found following information on partnersource and I found it worthwile to put it online. I didn't
Woohoo...sounds more like new pain in the...
Better watch out for paintballs...rrr
Thx and grtz!
I am not quite sure, but with this code you will face at least one additional problem:
You start looping through 2800 records, mark every second one, and the you loop again through the marked 1400 records.
But if you loop through a recordset with more than 500 records, FINDSET is the worst idea to use, because SQL has to fetch x times 500 records (in your case, 6 and 3 times 500 records), which makes performance really bad. Microsoft strongly recommends to use FINDSET only with less than 500 records in the recordset, so that SQL does only perform ONE single SELCT TOP 500 command.
In recent Microsoft statements, FINDSET (with or without parameters) is regarded as being slow, unforeseeable and problematic due to strange locking behaviour.
Try FIND('-') instead, which is recommeded for loops with more than 500 records, and your performance should increase. Maybe the marks are not the problem at all...
Hm, I don't agree.
As you can read in mij first post (dynamicsuser.net/.../what-impact-does-my-c-al-have-on-sql.aspx), I had to conclude that it is safe to be using FINDSET at all times.
Can you point us to the documents, websites, stuff where microsoft recommends this?
Here some links:
www.mibuso.com/.../viewtopic.php
(advantage of find('-') compared to findset)
And an exercpt from the Microsoft resource kit:
"When you use FINDSET without any parameters it functions as a firehose and fetches
around 500 records. If you want to retrieve more than 500 records, you can still use
the FIND('-') function. Alternatively, you can use FINDSET(True).
If you need less than 500 records, use LOCKTABLE and then FINDSET."
Locking Poblems with Findset (there are additional articles available, I think):
blogs.msdn.com/.../Default.aspx
(search for FINDSET and read the following comment regarding locking problems)
This is, why I won't use FINDSET anymore. In some of our projects, we had performance problems and even deadlocks due to FINDSET, because it locks more than the filtered records. With FIND('-'), everything worked fine and fast.
But this might also depend on the case, of course ;-)
Sorry, dude, but I still have big doubts on this. I did my own tests (as you can read in my post (URL above)), and the results were quite clear.
When marking records, it just doesn't matter. Probably it'll loop in cache. And still, if not in cache, it does a seperate SELECT for every record. No SELECT TOP 500 at all (because there is no filter, there is no WHERE-clause).
Furthermore, if just looping (not marking), I did my tests, and (als Stryk also mentions in the link you sent me) it does client side cursoring for the first 500 records. That's why (when looping more then 500 records) you first get a SELECT TOP 500, and immediately after that a SELECT * (it looped the first 500, noticed there were more, and therefore getting the rest of te records the same way as FIND('-') did).
That's what is clearly shown in the client monitor and SQL Profiler.
But let's be sure. We are interested in what is fastest. I'll try to think of a scenario tomorrow to test this out in a big database... . Hope to find some clear results on this... .
Ok, I agree with you (and your test results), which are a very good work. But does it reflect the multi-user environment, which we try to optimize in our projects?
Imagine a company, typing in orders every minute and an automatic sales reservations for all items. FINDSET is fast, agreed - in a single-user environment! But with the unpredictable locking system, in a multi-user environment, I would not bet on FINDSET but on FIND('-'). I had two projects, where I could prove this behavior. FINDSET loses all performance advantages due to its locking problems.
I cannot prove this with a comparison in microseconds - but all deadlocks and waiting periods were gone at the time I replaced FINDSET.
Your idea to use a larger database is good, but maybe you should also try to build up a test scenario in multi-user style ;-) Because fast is only, what is fast in single- AND multi-user environments. It doesn't help our customers if a single user is able to work fast, and 10 users suffer from performance.
But you are right, in single-user scenarios, FINDSET should win the contest...
Hey thats very useful info thanks.
Whilst it is always implied that a Service Pack upgrade does NOT require a data upgrade, its good to see them specifically confirm this with this version.
I will try to think of a way to simulate what you mean, but it's nog going to be easy though... .
New update for NAV5SP1: mbs.microsoft.com/.../KBDisplay.aspx$en-us$954191&wa=wsignin1.0
Here is a new update of "THE" list . Enjoy! Released Version Update Build No. KB number Prerequisites
its me again. Did you had a good vacation?
Look at (for 50SP1)blogs.technet.com/.../microsoft-dynamics-nav-5-0-sp1-latest-available-version-build.aspx
:
Microsoft Dynamics NAV 5.0 SP1 build 26084.
Current available fixes:
5/29/2008. KB 953245; build 26654. Cfront folder. "C/Front hangs while generating a lot of temp files "
6/11/2008. KB 952373; build 26751. Client folder. "Selecting specific Printer Tray does not always work"
6/26/2008. KB 951631; build 26751. Client folder. "NAV 5.0 SP1 locking error when you print a report that calls code in a form"
6/30/2008. KB 953545; build 26751. Client folder. "Local variable values not updated in debugger"
6/26/2008. KB 954342; build 26810. Client folder. "NAV shows unexpected results when filtering, and may crash "
and for 40SP3:
blogs.msdn.com/.../buildnummern-bersicht-microsoft-dynamics-4-0-service-pack-3.aspx
Thanks, wito. When I was checking them out, I couldn't open the KB articles, zo I guess they're not public yet... . I will update them when they come available.
Finally, there is some (good) documentation available regarding the local functionality of NAV. For a
Pingback from AMD Talk » Microsoft Dynamics NAV 5.0 Local Functionality
Pingback from Pregnant Man » Microsoft Dynamics NAV 5.0 Local Functionality
I know that they told us that they are working on this documentation one year ago. I am happy that they finished it and now we have it available. Good for all of us who are working with international projects etc.
Famulos news, I have only been waiting 17 years for this.
Thanks Eric for the links.
I agree ... it was worth sharing it :)
But still, some countries are missing, like Czech Republic... it seems like GR1 and may be some other countries are on the list...
Belgium is on the list, and that's group 2.
I understood it's a local "initiative", so you should wake up the Czech Microsoft People ;°)
thank you very much! This is my searching for my job! But I can not download from UK???!
How do you mean?
I was asked by MSDynamicsWorld.com to write a small piece about NAV2009. Not easy to do, because as MVP
Pingback from windows server raid 1 or raid 5 performance sql
... Нашел интересную информацию опубликованную Waldo в своем блоге dynamicsuser.net/.../microsoft-dynamics-nav-2009-what-s-to-expect.aspx
For you information:
the number of descriptions have been extended. You can find everything here:
mbs.microsoft.com/.../MSDNAVlocalfunct
Pingback from Bookmarks about Microsoft
As you might have noticed, I changed the table a little bit. I think it's far more useful to see
after installing the client folder Im still getting
error"programm that should be updated cannot be found or the fix is not for this version of the programm.... blabla!" what else do i need todo
Normally, I would have done an article about Sumindexfields on versions previous to 5.0 SP1, but I decided
$Cnt is used internal by the SQL Server to find out when the record can be removed from the indexed view again.
When is scheduled the next event ?
BTW : Do you accept French in your Belgian gathering ? ;-)
I was there, unfortunatly the only person I recognized and had a chance to say hello and talk to was Hynek (he was one of my Navision trainer in the UK back in 1997) and Jorg.
I've recollection having seen Luc, Eric & Mark but back then I did not have a picture to put against the names, so next time I will say hello :-)
Hey well done Eric,
There is a ton of info out there about Indexed views, but you have done a great job of finding the important stuff, and summarizing it all in one place.
PS I wish you a fast recovery on the knee.
@Bjarne: Ok, thx. Does this mean that every indexed view has a $Cnt-field?
@David: Thanks, David. Also for the knee. It's something I'm not looking forward too. In 9 months, I will be able to play basketball again ... . Not really a 'fast recovery', is it?
Going to Directions US?
Off Course!
If there are french-speaking people, we just do the presentation in English.
Just check www.dynamicscom.be to check for next events...
Only if the view definition uses an aggregate function or GROUP BY, the SELECT must include COUNT_BIG(*). The name of the column is no matter. Here it's called $Cnt but you can call the column what you want.
Good to know: there is a platform update available for 5.0SP1. More info here:
Why is it when I try to open the doco file above I get a http403 and says website requires me to log in.
I guess because you need to log into partnersource (first). This is problably more useful:
When I do this, my shapes seem to be on top of the textboxes (so I cannot see the text) - I know I am missing something simple...
You need to add the shapes first - then the labels afterwards, and then the labels will appear on top of the shapes instead of being hidden :)