Navision 2.0 to 3.7 payroll upgrade slow HELP?

jbull

we are upgrading a client from Navsion 2.0 to 3.7 and the upgrade toolkit has worked fine with a few bumps up until the H/R Payroll portion of the upgrade which is running awefully slow. Codeunit 87200 has been running for nearly 10 hours with no end in site.... is this normal? I know that there were some keys we could disable/enable for the item tracking portion of a recent upgrade that made a huge difference in speed on the upgrade but I can't find anything regarding the payroll portion. Thanks in advance for any tips! :?

sbhamidi

That codeunit is slow. It goes through all the payroll ledger entries to process 'em. Depends on how big the table is for that database.
We faced the same issue. We increased the DBMS cache which helped partially.

Captain_DX4

This is completely normal. There is no status window letting you know the progress (extremely frustrating!) and it does crunch through an incredible amount of data. You will get a dialog signifying completion at the end of the run, if I recall correctly.

Good point to note for anyone upgrading North American payroll... If you anticipate 1 day offline for your customer (say a v2.x database around 1 GB size, so 1 day would be a fair estimate), anticipate going 2 more days offline for payroll upgrades! The codeunits take forever to run, and it does not leave everything in a state that you can immediately run a payroll. We found several things that required updating in the Employee Paycontrols (one person had a garnish, and the process decided to assign it to everyone; stuff like that...) It does work in the end, but anticipate more time than normal to accomplish everything.

jbull

I'm posting my own fix in an effort to help others avoid the problem. I used an Idea that worked for us on a similar upgrade where I disabled all but the first couple of keys on the item ledger entry table to bring an upgrade from about 30 hours down to 3. I cancelled the payroll upgrade process that had been running for 13 hours and went into the Payroll Ledger Entry table and disabled all but the first key of the table. I restarted the payroll update and it ran in 1 hour and 40 minutes and then I re-enabled the rest of the keys on the Payroll Ledger Entry table and saved the object which took about 10 minutes to rebuild the keys.... so the whole process finished in less than 2 hours.... amazing.... hope this helps someone else.