Does this site look plain?

This site uses advanced css techniques

Evolution Logo

Most of the housekeeping tasks in the iSystems Evolution™ payroll service-bureau system are done by administrators using the EEC (Evolution Enterprise Controller), but one common task — rebuilding the temporary tables — can be done from the Evolution application client itself. This Evo Tip provides instructions for how to perform this.

Rebuilding TMP_TBLS requires admin rights, so it may be required to login as the explicit admin user - this will become apparent if the required menu items are not found on user's menu as shown.

Rebuilding of temp tables is done one client at a time per thread, and for small numbers of clients (one or two) it will complete very quickly. This process may be run during live production, though for doing full rebuilds it's recommended to wait until the off hours due to the amount of time it takes and the load it puts on the system.

progress display Progress is shown in the Current status display, and the last numbers (m/n) shows how many (m) of the total (n) have been completed.

Note - there is no elegant way to interrupt a temp-table rebuild.

Update: In the past, it was recommended to backup+restore the TMP_TBLS database after rebuilding, but this is no longer necessary as of the Plymouth release. Don't bother.

This is not necessary or recommended when rebuilding just a few clients.

2007/06/26: First published
2018/04/09: updated