AX 2012 Issue: Cannot execute a data definition language command on Dimension set balance temporary data
So, I ran into something new today with AX 2012. The following error message starting showing up, within an instance that has two AOS(es). It showed up anytime any process needed to post to the General Ledger area.
"Cannot execute a data definition language command on Dimension set balance temporary data (DimensionFocusBalanceTmp). Financial dimension set: 0, 0.
The SQL database has issued an error."
After this, there was a trail of SQL related errors that both AOS(es) trapped and bubbled up to the UI. This happened on both AOS(es) not just one. I tried, to run the following.: DimensionCache::clearAllScopes(); in a job. This had zero affect.
To get past this fast, a restart of both AOS instances was completed, that resulted in the resolution of this issue. I would like to hope that maybe there is a Cache call that could take place that would fix this issue, without having to restart the AOS. However, for now, if you see this, the fastest resolution is a restart of *ALL* AOS(es) within a given instance of AX.
If I get an update on this, for what fixes this, if a hotfix comes out, or if there is a piece of X++ cache clearing code that can be executed, I will make sure and update this post as such.
Hopefully this will help someone out.