› Eiglobal.ini › [Database] › Transaction

Transaction

Description

Specifies whether database transactions are to be used.

This setting must be set to 0 if you are using a Microsoft SQL Server database.

The purpose of the setting is to add stability in the database access process with the help of extended transaction management. (Invoices uses transactions even when the setting is 0, but in smaller chunks.) It works best with an Oracle database.

Normally this flag is set to 0 (default). However, in 5-5 SP1/SP2/SP3 it was switched on by mistake during installation. In new installations of these versions that involve customizations or large volumes, timeout problems may occur and error situations may not recover properly. We recommend that you check this setting and ensure it is set to 0 in Microsoft SQL Server environments.

In older installations where the original Eiglobal.ini file was kept during an upgrade, the setting is not affected.

(In the Invoices 5-5 installation without any service pack, the default setting was 0, as intended.)

Valid values

  • 1 (ok for Oracle)
  • 0 (default – required for SQL Server)