Over the last month we were facing a situation where the Dynamics AX 2009 Kernel was generating incorrect SQL Queries in a specific constellation:
So as a result the mentioned fields don't exist in the SQL Server database.
Sometimes, especially then when the AOS was under a very heavy load, the Dynamics AX Kernel was generating SQL Queries that included the non-existing (disabled) fields (columns), of course resulting in a SQL Server error.
The AOS was logging the following error message to the event log:
As there was no consistent way to reproduce this random, sporadic issue, is was very hard to find the real root cause. Without going into further details the most important information is that the root cause of the issue was finally found.
The Dynamics AX 2009 SP1 Kernel Hotfix KB970335 is solving this issue.