Import Consolidation from File works very slow.

EugeneB

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

kriki

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.

aliennav

And what can be done when running Import database option. This is taking 12-14 hours to completely run the consolidation process?

jglathe

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