Other recent Dynamics AX Blog postings

Samstag, Dezember 30, 2006

Happy New Year!


I want to wish all of my readers a happy and brilliant NEW YEAR!

Freitag, Dezember 29, 2006

Goodbye, axdat.udb !!!

One of the very good things about Dynamics AX 4.0: there is no axdat.udb file anymore! All information about users online etc... is kept in the database.

The table that holds the users' data is called SYSCLIENTSESSIONS.
The table that holds the AOS' data is called SYSSERVERSESSIONS.

It seems to me that SysClientSessions will contain the sessions that had been logged in on the current day (no matter if they are still logged in or not). Currently logged in sessions will have the field STATUS set to 1.

Samstag, Dezember 23, 2006

MERRY XMAS!


I wish all of my readers and friends a very merry and wicked Christmas !!!!

Donnerstag, Dezember 21, 2006

Sending Emails via SMTP on AOS server

I had the following problem: our partner made a class which sends emails to users via SMTP using the SysMailer class. It works well using a local client. Unfortunately, when you run the class in batch, it gives you a .NET permission error (the BatchRun class has the RunOn property set to "server").

I don't have any knowledge in .NET, but fortunately I found a similar problem in Fred Shen's blog (http://fredshen.spaces.live.com/). I mailed him my problem and instantly got an anser and a solution !

Here is the Fred's answer. I tried it and it works! (I marked the changes to be done in the method with red color)

Whenever you initialize the sysmailer class, put InteropPermission.assert() before new SysMailer(). When you look into SysMailer.new() method, you may find that the COM c = new COM(' CDO .Message') is not in the scope of interopPermission.assert(). (I thought it should be a code defect) So alternatively, you can restructure the codes in SysMailer.New() as below:

void new(/* COM c = new COM(' CDO .Message')*/)
{
COM cdoConfig;
COM c;
InteropPermission permission = new InteropPermission(InteropKind::ComInterop);

;
permission.assert();
c = new COM('CDO .Message');
_COM = c;
//BP Deviation Documented
if (_COM.configuration() == null)
{

And that's just what I want to achieve with my blog: to get to know people and to help each other. So again: THANX A LOT, FRED !

Montag, Dezember 18, 2006

Enabling SQL trace in Dynamics AX 4.0

If you want to trace your SQL statements in DAX 4.0 (e.g. long running queries), you have to enable the SQL trace flags in the user options. But that's not all. You will see nothing unless you enable it on the server, too!
Go to the Dynamics AX Server Configuration Utility, tab "Tracing" and enable the flag "Allow client tracing on Application Server instance".

Freitag, Dezember 15, 2006

Ctrl Alt F4 not working?

2 weeks ago, I got a new laptop and started working on it with Dynamics AX 4.0. Unfortunately, the good old shortcut for "Go to main table", i.e. Ctrl-Alt-F4 did not work anymore. First I thought it's because of DAX 4.0, but then I found out that the shortcut was working on other PC's. I remembered that I had the same problem years ago and fortunately I found the reason:

The display driver of the graphics card was the villain. You have to disable the shortcuts in your graphics driver, then the "Go to main table" shortcut will work again.

Mittwoch, Dezember 13, 2006

Blog design updated

I just made an update of the design of the blog. I always wanted to have the actual "text" part bigger which it is now.
I hope you'll like it.
P.S.: The next Axapta article will probably be about the new global search.

Freitag, Dezember 01, 2006

Dynamics AX 4.0 SP1 (aka DAX 4.01) released

You may have read that in other blogs: Microsoft has released the SP1 for Dynamics AX 4.0 today.
You can download it from Partnersource (if you are a partner) or CustomerSource (if you are a north american customer).

All others (like me) cannot download directly but must contact their Axapta partner.

Dienstag, November 21, 2006

Adding Favorites programmatically

In Dynamics Ax 4.0, each user can have a Favorites pane. Normally, you can add a menu item to the Favorites pane by dragging and dropping it. I created a small job where you can see how to add a form programmatically to the Favorites pane. (The job has been created using some standard methods).

The job can be downloaded from Axaptapedia here: http://www.axaptapedia.com/images/6/63/Job_hw_addToFavorites.xpo

The Axaptapedia page for this is: http://www.axaptapedia.com/Adding_Favorites_programmatically

Next steps can be: adding a query to the favorite via X++, add a button on each form to add it to favorites

Montag, November 20, 2006

AOT search: project now on Axaptapedia

The upload to Axaptapedia works now, so you can download the last project now at http://www.axaptapedia.com/images/9/99/AOT_SearchExtended.zip

Donnerstag, November 16, 2006

AOT search within search results

One of the things that happen to you when you take an active part in a community is that you actually build up a community. This way, I get emails with questions about Axapta but also people send me their projects to test them.

So, a guy called Jonathan Watkins asked me if I can test a tool called "AOT Search extended" for him. Well I did now so I will share it with you all.

What does the tool do? When you search something in AOT, you get a load of results. And what if you then subsequently want to search inside these results?
That's where the tool can help you. Just before you do your initial search, click on "Save results". After the search has finished (or you stopped it), click on "New search" and it will ask you if you want to search within your previous results.
Cute, isn't it? The tool has been made in Axapta 3.0 SP4, but will also work in other 3.0 versions.

I have created a page in Axaptapedia for it, you can find it here: http://www.axaptapedia.com/AOT_Search_within_search_results

You can also download the tool directly from here: http://www.geocities.com/axaptafreak/Files/aot_searchextended.zip

And, as always: my apologies if you cannot download the file. I have no webspace so I have to put it on my Yahoo Geocities account which has limited traffic allowance.

Mittwoch, Oktober 25, 2006

Extension of Best Practice Checks: Complexity Analysis

Today I stumbled over an interesting PDF. It is called "Measuring Complexity In X++ Code" and written by Anders Tind Sørensen.
It looks like a Bachelor thesis for the Technical University of Denmark and what it is all about: Anders makes an addition to the Best Practice Checks in Axapta to measure the complexity of the written code. This is made by some rules like: number of lines, comment percentage, depth of inheritance, number of children, etc...

All changes made to Axapta are inside the PDF and an xpo is also mentioned, but I could not find it (and no mail address of Anders...). As there are no copyright restrictions in the document, here is a link for you to download it: http://www2.imm.dtu.dk/.../imm4708.pdf

Donnerstag, Oktober 12, 2006

Semicolon in classes: another hint

This is kinda follow up to one of my previous posts where I showed a link to Max Belugin's conclusion about semicolons in classes. (Orig post here: http://axaptafreak.blogspot.com/2006_03_01_axaptafreak_archive.html)

Today I found another funny thing about it (well it's not really my idea of fun but whatever).
I added some lines in the Info class, method startupPost (it was in fact to automatically start Tabax, a great tool by Max Belugin). Now: it was working when I started the Axapta client locally on my PC (using a 3-tier client).
But: when I logged on to a terminal server and started the Axapta client there (also 3-tier, same application, same database, same everything), it DID NOT WORK !!?!?

It took me some time to find out what the error was: a missing semicolon after the variable declarations. I still can't imagine why on earth it was working locally on my PC and not on the terminal server (there were no errors or so, it just skipped the lines).

Freitag, Oktober 06, 2006

Tabax: tabbed Axapta interface !!!!

My friend Max Belugin has implemented another great tool for Axapta: Tabax

With Tabax, you have all your open Axapta windows displayed at tabs just underneath the standard icon bar. It's great if you work with your windows maximized because now you can switch between the windows with just a click.

There are some more features like: opening table browser with a click (it will take the datasource of the current form and open the table broser for it), editing the current window, showing xreferences for the current window.

You can get it from here (it's strongly recommended!): http://www.axaptapedia.com/index.php/Tabax

Dienstag, Oktober 03, 2006

BREAKPOINT command in X++

Hi! I'm back on track and the first thing I want to share after my vacation is a rather undocumented X++ statement: BREAKPOINT

In any X++ line, you can write BREAKPOINT; which will trigger a breakpoint on this line and open the debugger. With that, you could circumvent the fact that Axapta does not know conditional breakpoints and you could write a line like that:

if (i>10)
BREAKPOINT;

I have been using this statement for years, it has been working since Axapta 1.5 (the first version I had).

Freitag, September 01, 2006

On vacation yeah!

I'll be on vacation the next 3 weeks. I wish everybody a pleasant time using Axapta.

Freitag, August 25, 2006

Final confirmation: AX ISO from MSDN working

I re-installed Dynamics AX 4.0 from the MSDN ISO on a new server and it is working. The only thing I'm missing now is a demo company (that used to be included on the 3.0 Installation CD's).

Mittwoch, August 23, 2006

ISO seems to work, Axapta not....

The ISO from MSDN seems to be okay now. But somehow I cannot get Ax to start. I'll reinstall my VirtualPC or try it on a different server.

Dienstag, August 22, 2006

Dynamics AX 4.0 ISO available again on MSDN

I just saw that the ISO is available again. I'll try to download and install it and will keep you informed if it's working now...

Mittwoch, August 02, 2006

Dynamics Ax ISO from MSDN not working

It's now confirmed by me: the Ax 4.0 ISO you can download from MSDN is corrupt. I'll keep you informed when a new version is released.

Dienstag, August 01, 2006

Dynamics Ax 4.0 available on MSDN downloads

Dynamics Ax 4.0 can be downloaded from MSDN if you have an MSDN subscription (my subscription is MSDN general). There is a post in a Microsoft newsgroup that the ISO might be corrupt, I'll check that as soon as my Virtual PC is set up...

Mittwoch, Juli 26, 2006

Sorry!

Yesterday the blog was not available for some hours. There must have been some error during the last publishment of the blog so it wasn't displayed. Anyway, it's working again.

And to give you something to look for: I am doing a little project with which you can choose "Excel" as filetype in Axapta and the report will be opened in Excel afterwards automatically.

Montag, Juli 24, 2006

Tes procedure to check whether you can send mails via SMTP

I am trying to do some emailing out of Axapta at the moment and I found an old post in the development-axapta mailing list that provides a way to check whether you can send mails via SMTP using telnet.
You can take a look at the post here: http://www.mail-archive.com/development-axapta@yahoogroups.com/msg09750.html

Another tip: if you have installed McAfee VirusScan, it might block all connections on port 25 on your PC (to avoid mass-mailing viruses using this standard SMTP port). So check it and disable it if you want to use SMTP from your PC.

Mittwoch, Juli 19, 2006

Axapta Blogs and one more feed

Well, first of all: of course I forgot my own RSS feed in the list! Gosh! So here it is of course:
feed://feeds.feedburner.com/axaptafreak

And here are some other excellent blogs that do not have an RSS feed unfortunately: (the later ones do not show much activity but the first ones are brilliant)
http://axcoder.blogspot.com/
http://fredshen.spaces.msn.com/PersonalSpace.aspx
http://casperkamal.spaces.msn.com/PersonalSpace.aspx
http://axaptabuilder.blogspot.com/
http://dynamicsdoodles.blogspot.com/
http://axutilities.blogspot.com/
http://axgeek.spaces.msn.com/PersonalSpace.aspx?_c=

Freitag, Juli 14, 2006

Dynamics AX 4.0 Implementation Guide

You can download the new implementation guide here: http://www.microsoft.com/downloads/details.aspx?...

It seems like it's the same as the online version in MSDN and unfortunately it misses the same pages, too. But it's better than nothing, isn't it?

Dienstag, Juli 04, 2006

Project: Create Multi Files from xpo

Hi!
A long time ago, I wanted to be able to have the old XAL way of exporting elements in Axapta: that every element gets its own file. Therefore I made a class which will exactly do that. Parameters are: filename of xpo file and directory where the single files will be stored.
What will the class do: it will go through the xpo, scan for elements and make one file for each element. Then, you can use a file comparison tool (e.g. Beyond Compare) to compare the two directories and you will see all the new elements, changed elements and so on.

So, what is it for?
I have been using this class for years to compare releases, whole layers of different applications and so on.
I also used it for comparing new service packs to old service packs: just export a whole standard application and another one with SP1, run the class on both xpo files and compare the two directories with a file comparison tool.

There are some limitations to the class:
  1. You cannot re-import the created file. Reason: I have to remove one line in the file where the date of the export is stored. Due to the multi-language capabilites of Axapta I cannot figure out where that string begins. But I never wanted to re-import the xpo due to limitiation number 2:
  2. The created file will not have the nice layout of the original. It will miss all additional spaces. This is due to the fact that Axapta cuts off unnecessary spaces when reading lines into a container.
    The project can be used for Axapta 3.0 xpo files.

Anyway, I hope you will enjoy this little tool. You can also drop me a line into my inbox.
The project can be downloaded from the Dynamics User Group site here: http://dynamicsuser.net/files/18/ax_tools/entry1933.aspx

Donnerstag, Juni 22, 2006

Microsoft Dynamics AX information starting to flow...

Today I saw that Microsoft starts putting more AX information into MSDN. Here are some links where you can get the newest articles:

  • Using Microsoft Dynamics AX: Here you can select the kind of info you want to see: for users, IT admins, developers and common technical articles
  • MSDN Dynamics AX: The starting point where new AX information is put into MSDN, just click on any subject in the MSDN tree below. At the moment, it seems as if the MSDN tree is prepared but there is not much content, only a few things are available (like here: upgrading to Dynamics AX )

Freitag, Juni 16, 2006

All old technet postings in one PDF file

Ever wondered where all the documents from the "good old Axapta Technet" have gone? Well, just some days before Microsoft turned the old Technet off, I downloaded ALL documents (that is not the discussions! Those have been transferred by Microsoft into the Axapta newsgroups) and made one PDF file out of them.

The PDF, however, contains all the news articles, tips & tricks, etc. posted by Microsoft and so on. Some of the documents may be available somewhere at Microsoft sites, some may even have found their way into the official help docs.

Those who still know the old technet will recognize some of the docs, the newbies may take a look into it and check what's still interesting to them ('coz the content is more than 17 months old now).

I have uploaded the file on the Dynamics User Group site. If you are already a member, you can download it here: http://dynamicsuser.net/files/18/ax_documentation/entry820.aspx
If not, I think you have to register first (but it's worth doing so)

Montag, Juni 12, 2006

UPDATE: Axapta 3.0 Kernel Rollup 2 Performance Comparison

I have now made a second test run using the same Oracle DB once for the standard 3.0 SP3 kernel and once for the Kernel Rollup 2.
The tests showed no significant difference between the two kernel versions so my final statement is: the kernel rollup 2 has the same performance as the standard 3.0 SP3 kernel.

Freitag, Juni 09, 2006

Axapta 3.0 Kernel Rollup 2 Performance Comparison

I made a comparison of the performance using an Oracle 9i database. The test set is the same as in my comparison between Oracle and SQL 2005 and here are the results:

  • There is a major decrease in performing large select/filter statments in forms. In one of my test forms, the filtering in the form took more than twice as long using KR2.
  • Some reports ran a little bit faster using KR2.
  • Overall: the performance using KR2 was about 10% less than using a standard 3.0SP3 kernel. If only reports are compared, KR2 was about 4% better than standard 3.0SP3.
I will rebuild the statistics on my Oracle DB and run the test again, as the first point is a little disturbing to me.

Freitag, Juni 02, 2006

Axapta Blog now has more than 10.000 visits

Hi all!

Last month was the month with the most user visits on my blog so far: almost 1400 visits in May 2006. There are now more than 10.000 unique visits in total, too (>14.000 incl. reloads).
I hope everybody is enjoying the blog and gets some info out of it (I try my best).

Have a nice day!

Mittwoch, Mai 31, 2006

Axapta 3.0 Kernel Rollup 2 released !!!

The Kernel Rollup 2 has been released. Here are links to the fix list and the readme:
KR2_Fixlist.htm

(Edit: I removed the link to the readme due to copyright reasons)

Dienstag, Mai 30, 2006

Search for item id in config id lookup (in queries)

We had the following problem: we are using a lot of config ids for items. Now, when you click on the lookup button of a config id field in a form, Microsoft has made some changes so it will only show you the configs of the current item (in the form).
This does not work, however, in a standard query (like a report query). There, the lookup for config id will show you *all* config ids of *all* items in Axapta.

The easiest possible way to make it a little more usable for me was to add the ability to search for item ids in this lookup (which is not possible in standard).

So please download the changed form here and enjoy: http://www.geocities.com/axaptafreak/Files/configidlookup.zip

Montag, Mai 29, 2006

Display session's AOS name in online user form

When you have more than 2 AOS servers in your Axapta setup, you might experience the following problem: the online user form will only tell you whether the user displayed is currently working on the same AOS as you (then it will say "thin") or on another AOS (then it will say "NotAOS").

As long as you only have 2 AOS that's not a big problem, as "Thin" will mean the user is on the same AOS as you and "NotAOS" means he is on the other one.

But if you have 3 or 4 AOS, "NotAOS" will not tell you on which of the other AOS the user is working on.

So, here you can download a little project where one column is added to the online user form displaying the AOS setting of the user (including AOS cluster information):
http://www.geocities.com/axaptafreak/Files/hw_sysusersonline_aosname.zip

You will see the additions I made when you compare the elements in Axapta. It's not a big deal but I needed that info very often so here it is for you.

Montag, Mai 08, 2006

Axapta Audit Trail (Table TransactionLog)

2 things about the audit trail:


  1. Palle Agermark has posted an interesting article about the audit trail and when records will be created depending on the TTS level of the application. You can read it here: http://blogs.msdn.com/palle_agermark/

  2. We recently ran into the problem that we got error messages in Axapta saying "Cannot create a record in Audit Trail. The record already exists." We are running Axapta 3.0 SP3 (upgraded some years ago from 2.5). Unfortunately, the error is repaired in SP4, but you can actually repair it also in SP3.

    Go to the class "ReleaseUpdateDB_V30toV30SP" and copy the method "RepairTransactioIdPerTableV30toV30SP" into a new job. (NB: The method will only exist in a SP4 or SP5, of course).
    In the job, you have to comment the first line after the variable declaration, that is this.tableProgress(tablename2id('dataArea'));
    You can run the job and all your entries in the SystemSequences table will be corrected.

    Please also check the table SQLSYSTEMVARIABLES in your database. Check the value for the parm "Index". If it is below 256, you also have a second problem -> please write a comment and will explain further what to do.

Freitag, April 28, 2006

Dynamics Ax 4.0 Supported Configurations

A Microsoft bloke has posted a whitepaper on his blog which tells us which hardware/software configurations will be supported by Dynamics Ax 4.0. Here is the link: http://blogs.msdn.com/nolansax/archive/2006/04/12/574801.aspx

Montag, April 24, 2006

Microsoft Dynamics Ax 4.0 Supported Configurations Whitepaper

A Microsoft bloke has posted this document about different hardware configurations for Dynamics Ax 4.0 in his blog. Here is the link: http://blogs.msdn.com/nolansax/archive/2006/04/12/574801.aspx

Freitag, April 21, 2006

Reports displaying *****

If you have a report that only displays ***** instead of numbers, you have one easy way of showing the correct numbers without any modifications:
Print the report to a file and open it in Excel (field delimiter is TAB) --> you will see all the numbers in Excel.

Donnerstag, April 20, 2006

Axapta 4.0 Layman Specification March 2006

There is a new Layman Specification available for Dynamics Ax 4.0 available. Some Microsoft bloke has put it on his blog, so here is a link to it:
http://blogs.msdn.com/nolansax/archive/2006/03/28/563084.aspx

Axapta Performance Oracle9i SQL2005 Part 2

I have conducted some more tests and the results stay the same:
SQL 2005 is about 14-20% slower than Oracle9i.
But I know that Microsoft is working very hard that this changes with Dynamics Ax 4.0

Dienstag, April 18, 2006

Axapta Performance Comparison Oracle 9i and SQL2005

I finished the first performance tests and here are the results. The configuration is as follows:
Oracle: 9.2.0.4, used Axapta client is 1951.3733
SQL2005: used Axapta client is Kernel Rollup 1

The test server is a P4 2.8 GhZ with 2GB of RAM. Both Oracle and SQL2005 have 1GB RAM assigned (not at the same time. Either Oracle OR SQL2005 is running.)

The first tests show that SQL2005 is about 25-30% slower than Oracle if the database is running in SQL2000 mode.
The performance is a little bit better when running in native SQL2005 mode: then SQL2005 is about 14-19% slower than Oracle.

The biggest surprise was that Oracle was always faster when a certain test (form filter/report execution) was done the second time and the data was coming from cache. It seems that the caching algorithm of Oracle was much better than from SQL2005. There was a range of 45-150% worse performance in SQL2005 when getting data from cache.

Freitag, April 14, 2006

Axapta Blog is featured community

Today I saw that my blog is a featured Microsoft community at the moment. Wow.
I just also wanted to tell you what I am doing right now: currently I am doing a performance comparison of our system between Oracle 9.2.0.4 (currently our live system) and SQL2005.
I have read in many forums that the Kernel rollup also decreases performance. Well, I will also try to check that.

Mittwoch, April 12, 2006

Specifying empty date values

If you want to set a date field to an empty date or need to compare if a date field is empty, you can use the datenull() function. It is a method of the Global class and will simply return 01\01\1900.

This leads to more things:
  1. You can write dates in Axapta X++ editor using backslashes, e.g. 14\04\2006
  2. An empty date in Axapta is specified as January 1st, 1900.
  3. You can use methods from the Global class without having to write "Global::". So, you can write "if date == datenull()" and you do not have to write "if date == Global::datenull()". This works with all the methods from the Global class.

Montag, April 10, 2006

Axapta 3.0 SP5 Fixlists

Here are the links to the fixlists of the Service Pack 5 (SP5) for Axapta 3.0.
And: Please, Microsoft, give European customers access to CustomerSource...

Attention: the Geocities page where the files are located have limited download capacity. So if it doesn't work, check later. (I still don't have any storage capacity).

Financial management
Manufacturing Service Organization
Supply Chain Management
Tech 1
Tech 2

Mittwoch, April 05, 2006

Fixing online user form bug (Ax 3.0 SP3 on Oracle)

There is a standard error in the online user form that is occurring with Oracle only.
Please check the "Info" class and there the methods:

  • licensedUsers
  • licensedComUsers
  • licensedAOSUsers
  • licensedObjectServers

In all those 4 methods (well, "licensedUsers" is the most important, but please change the others as well), add the following line to the "select sysconfigtemp" statement:

&& sysConfigTemp.ConfigType == ConfigType::AccessCodes;

So, the select statement should look something like this:

select sysConfigTemp
where sysConfigTemp.id == licenseCodeNum(...)
&& sysConfigTemp.ConfigType == ConfigType::AccessCodes;

Why all that? Well, when you start the Online Users form, Axapta will check how many users are in your license. It will then only show online users up to that amount. The methods above are not giving back the correct numbers because they are looking into the wrong record. So, Axapta thinks you are in demo mode and will only display 3 users. Why is it only on Oracle? --> On MSSQL, there is a Clustered Index used on the Sysconfig table so that Axapta chooses the right records by chance !

Example: the method "licensedUsers" looks like this in standard Axapta 3.0 SP3

select sysConfigTemp
where sysConfigTemp.id == licenseCodeNum(SysUsers);

The Id that should be selected is 10.

Problem: there are 2 records with ID 10! --> one with ConfigType = "AccessCodes" (that would be the correct one) and one with ConfigType = "ConfigurationKey"

Montag, März 20, 2006

Semicolon in methods: now I know why!

Today I found a very interesting entry in Max Belugin's blog. It explains why sometimes you have to put a semicolon in a method between the variable declarations and the first line of code. Finally, I understand know why! (Thanx Max!).
Here's the link: http://axcoder.blogspot.com/2006/03/magic-semicolon.html

Dienstag, März 14, 2006

Axapta 4.0 Layman Specification

No time to hesitate anymore: the Axapta 4.0 Layman's specification can be downloaded from numerous sites already, so here it is, too: things you can expect from Axapta 4.0. The doc is from december 2005.
I've put the file on some free storage sites, and I also apologize for any inconveniences for you when you download the file. I am sorry, but I do not have any webspace...
http://www.savefile.com/files/8987583
http://s5.simpleupload.de/fb875f6aa/MicrosoftDynamicsAX_LaymansSpec_1205.zip.html

Dienstag, Februar 21, 2006

Axapta Kernel Rollup 1: Compilation error

Due to a wrong file, you may get a compilation error with the kernel rollup. The file "AXSYSDE-AT.KTD", located in the Bin directory, has one error.

There is a blank line in the file causing the problem. Open fhe file with an editor and search for 1245. Directly above, there is a blank line, and above that line the text "Apostrophe (')". Delete the blank line and save the file using the same filename. Afterwards delete the file AXSYSDE-AT.KTI (Indexfile for the KTD) in the same directory and restart Axapta.

Mittwoch, Februar 15, 2006

Axapta Kernel Rollup 1: Field RECVERSION added to every table

The kernel rollup 1 adds a new field to the table COMMON and therefore, all Axapta tables get that new field.

It is called RECVERSION and rumours say that it is needed for the new Optimistic Concurrency checking (you can read about this in the previous blog entry). There is, however, no information about the field in the official release documents.

There is also the possibility that you will have to wait for a very long time after you first start your Axapta database with the new kernel rollup: as the system has to add the RECVERSION field to every table in Axapta, this may take quite some time for large tables.

Mittwoch, Jänner 25, 2006

Axapta 3.0 Kernel Rollup 1 released !!!

Finally, it has been done: Microsoft has released the so-called "Kernel Rollup 1" for Axapta 3.0.
With that kernel rollup, Microsoft adds the SQL 2005 compatibility for Axapta.

The highlights are:
• Compatibility with SQL Server 2005
• Optimistic Concurrency Checking for SQL Server 2000 and SQL Server 2005
• Enhanced Axapta SQL Server Tracing Utilities
• Increased SQL Query Performance
• AOS Enhanced Stability and Logging
• AOS Abort if Listener Thread Fails
• Enhanced Password Security (application update required)


If you want to know what is contained in the rollup, take a look here:
http://www.geocities.com/axaptafreak/Files/KR1_Fixlist.htm
http://www.geocities.com/axaptafreak/Files/KR1_Readme.doc