web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Error Code: 50110 = Maximum file size exceeded Operation will fail"

(0) ShareShare
ReportReport
Posted on by

A user is trying to run a consolidation and it is failing with the stack trace below.  He tried it two times yesterday, and the event documented in the following KB article was logged a couple of minutes prior, so it seemed to be related.  Does anyone know if the temp files are still limited to 4 GB in 2012 R2?

https://support.microsoft.com/en-us/kb/2437099

He ran it again today, but the event wasn't logged, so now I'm having doubts about whether the consolidation failure was due to the temp file...

Infolog for job
Completing processing for batch . (5637281028)


Infolog for task
Consolidating legal entity CORP for . (5637319249)


Cannot create a
record in Consolidations dimension values (TmpLedgerConsDimensionValueItem).


The operation failed.

An error occurred
during the consolidation process. All consolidations that match the criteria
for this consolidation event have been deleted. You must process the
consolidation again.


Microsoft.Dynamics.Ax.Xpp.ErrorException:
Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.


   at
Dynamics.Ax.Application.LedgerConsolidate.Sumandtransfer(TmpLedgerConsTrans
_sumTransact, TmpLedgerConsDimensionAttribute _consolidationDimAttr,
TmpLedgerConsDimensionValueItem _consolidationDimValueItem) in LedgerConsolidate.sumAndTransfer.xpp:line
56


   at
Dynamics.Ax.Application.LedgerConsolidate.Run() in
LedgerConsolidate.run.xpp:line 44


   at
Dynamics.Ax.Application.BatchRun.runJobStaticCode(Int64 batchId) in
BatchRun.runJobStaticCode.xpp:line 54


   at
Dynamics.Ax.Application.BatchRun.runJobStatic(Int64 batchId) in
BatchRun.runJobStatic.xpp:line 13


   at
BatchRun::runJobStatic(Object[] )


   at
Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String
MethodName, Object[] parameters)


   at BatchIL.taskThreadEntry(Object
threadArg)

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    on at

    the TmpLedgerConsDimensionValueItem is an inmemory table which will create a file when exceeding 128kb. It will do this on the tier it is running (so either client or server side). You could:

    find out what tier is used, if client then run it on server.

    or change the tabletype from inmemory to tempdb. then your SQL will be used instead of your memory.

  • Community Member Profile Picture
    on at

    Thanks so much Boye!  I believe it is running on the server tier as the temp file is being created on the AOS server in the service account's profile, not the client workstation.  

    If I change the table type to tempdb, do you know what is required for that change to take effect?  Will I need to recompile X++, CIL, and or/database sync?

  • Community Member Profile Picture
    on at

    yes you need X++ and

    if it runs in batch you certainly need CIL

    and you are changing the data dictionary so a sync is also needed.

    You have to go all the way this time.

  • Community Member Profile Picture
    on at

    Thanks Tony for raising up this issue, I made tables property to TemDB instead Inmemory , after All Sync. and compilation , I hit Consolidation and its keep  on going for more than 12 hours.

    I am not sure if its working . Any suggestions ??

     

    Thanks,

    Kumkum

       

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans