Monday, August 27, 2007

Caching and Indexes

Well, today I have to trouble shoot a weird problem for my customer (Ax30SP5). The problem is like this:

A LedgerTable consists of 822 records. Using the following select statements (in a job) yield different results.

a) While select ledgerTable
{
// work...
}
[This returns 822 records]

b) While select ledgerTable
where ledgerTable.accountNum >= [something] &&
ledgerTable.accountNum <= [something]
{
// work...
}
[This would only returns 278 records]

The interesting aspect of this problem is it only fails in a certain company. Yet the data in ledgerTable is the same as in other companies. Also, there's no problem if I use other fields in the where clause.

After playing around with parameters and settings I've figured:
i) If I change the caching from Entire Table cache to another type of cache, the problem's gone but this impact the performance of the system. [The problem comes back if I change it back to Entire Table cache]
ii) I can change the "Primary index" to another index to solve the problem. [The problem actually disappear even after I change the primary index back to its original one]

During the debug process I read through some articles and other resources. While I have no logical explanation on this, it seems that there's a slight chance the client side record caching would fail. Which in turn leads to problem in record selection related to primary key. [For record cache populates itself with primary key]

P.S. Anyone who has a better idea of what's happening please kindly share it with me. Thanks in advance.

Friday, June 22, 2007

Known issues when upgrading to Dynamics AX 4.0

Last updated 6/6:
Link (Require partner source access)

Wednesday, May 23, 2007

Tabax v0.3 is out

Finally, Tabax v0.3 is out. Thanks to Max Belugin and other contributors, now we can use this awesome tools in DAX 4.0!!

Check it out.

Friday, April 13, 2007

Hot Fixes released in March 2007 for Microsoft Dynamics AX

Check out the latest Hot fixes released by Dynamics AX team.

Link

You will need partner source log in to access the page.

Thursday, April 12, 2007

Exporting a table (or temp table buffer) to an excel file.

I've recently created a class to help export a temp table buffer to an excel file. I'd share it here for whoever interested. Cheers~

Download

Note: The code comes with no warrenty, use it at your own risk.

Wednesday, March 21, 2007

Dynamics AX 4.0 Trace Parser (beta) tool

Just saw a post regarding a beta tracing tools for Dynamics AX 4.0 Here.

Instead of writing similar introduction, please follow the above link to find the description and links for download. [Partner source log in required to download the tool]

Thursday, February 01, 2007

Customizing Infolog through SysInfoAction (by Kamal)

Today I saw this very interesting article by Kamal on "Customizing Infolog through SysInfoAction":
http://casperkamal.spaces.live.com/Blog/cns!9138ED475277CD63!207.entry

Wooo....Enlightenment!!

Thursday, January 04, 2007

Tabax for 4.0 follow up

After taking some time looking into it, I found those missing functions were due to tabax not able to find the correct image to load. The problem is the line of code that returns the path to the [DAX path]\application\share\include now returns [DAX path]\client\share\include instead. Fair enough, I just put the images into client folder instead and the functions are back.

However, the other problem regarding tabpages switching not working properly is outta my league. Hope someone can figure it out.

Wednesday, January 03, 2007

Tabax for DAX 4.0

Yurii has post an article on getting tabax to work on DAX 4.0. I tried it on SP1 and I had to change the security reference within assertDevelopment method also.

At this point some functions seems to be missing and the tab isn't 100% working (but close enough). It is functional but I missed many of the stuff I can do on 3.0.

It'd be nice if it's fully compatible with 4.0 in the future.