Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet

Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Wednesday, October 12, 2011

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.

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , , , , ,


Post a Comment

<< Home

Copyright 2005-2011, J. Brandon George - All rights Reserved