Assistance during projects

Help in issues solving.

Installation and configuration of all kind of open source software.

Assistance during systems installation.

Example: blocking application batch, sometime failing.

A new accounting software had been integrated, along with a large number of batches, including one for deleting closed operations after a certain delay.

The root cause was that the solution provided did it all in one database transaction, which could last several hours, sometines ending after the counters has opened.
The application was unusable while the batch was running.
Sometimes. it crashed at the database level, because the transaction was too big, and there was no more space left.

The annual clean-up was awaited with some concern.

After discussions with people in the accounting, it became clear that there was no functional reason to proceed in this way, and that it was possible to work at the level of a accounting transaction.

So I wrote a small tool that lets you delete a configurable number of deletion of unary accounting operations, within a transaxtion. It turned that is was perfectly possible for users to work a the same time as the cleaning batch.
The annual clean-up went very smoothly.