Import Consolidation from File works very slow.

EugeneB
EugeneB Member Posts: 2
edited 2014-06-12 in NAV/Navision Classic Client
Dear Colleagues,

We have performance problems while consolidating data from daughter companies and we would appreciate any comments and suggestions how to improve/overcome the issue.

Environment: NAV classic client (32 bit, finsql.exe, MS Dynamics NAV 2009 R2) in 2-tier configuration.

Report 92 “Import Consolidation from File” works very slow (Consolidation of financial data (General Ledger entries) from different companies to Consolidated Company for analysis and reporting). Import is performed from *.xml file (near 11 Mb) and takes about 4 hours. The process is run on the terminal server (24GB RAM, 12 CPUs) and uses only one processor core of the server, the other 11 cores are idle.

The question is whether this is a normal situation that the process of 11 Mb importing takes so long? If anyone has used this functionality – what’s your experience? Perhaps there are suggestions how to improve.

Thanks in advance,

Eugene

Comments

  • kriki
    kriki Member, Moderator Posts: 9,121
    Normal is that only 1 core is used.

    Check out if the file is on the same server your NAV client is running on. If it is on another server, it is slow.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • aliennav
    aliennav Member Posts: 449
    And what can be done when running Import database option. This is taking 12-14 hours to completely run the consolidation process?
  • jglathe
    jglathe Member Posts: 639
    The consolidation core (CU432) completely transfers the needed data into temporary tables first. This can be a bottleneck for processing when you have companies with lots of G/L transactions. The consolidation function was changed this way in NAV4.0 if i remember correctly. To speed it up you would need to redesign it.

    with best regards

    Jens

Categories