Last update: 13 November 2019 (cf)
Fabasoft Folio, more precisely the Fabasoft Folio COO-Services, has built-in error handling for about a dozen of ORA error codes. If one of that error codes is received, the COO-Service is trying to retry the query, and on further errors, will finally force a reconnect to the Oracle Instant Client.
This Oracle error codes are hardcoded into Fabasoft Folio to retry the query, and finally to force a reconnect to the database:
It is not possible to disable the error handling of the mentioned error codes, but it is possible to extend the list of error codes.
Adding further error codes should only be done with agreement from Fabasoft Support. Adding inappropriate error codes may lead to further errors, and unpredictable behaviour of the Oracle Database and Fabasoft Folio.
Follow these steps for every COO-Service object in Fabasoft Folio:
(The codes of the example are taken from the above list, therefore already hardcoded in Fabasoft Folio and not needed to specify explicitely).
After you have changed all COO-Service objects, open the Fabasoft Folio Server Management, navigate to your domain, and run All Tasks / Synchronize registry entries from the context menu. Caution , this will restart all backend services of the domain.
Double-check the values in the registry of the backend servers:
HKEY_LOCAL_MACHINE\Software\Fabasoft\Fabasoft Component Server\Domain x.y\Service x\Environment now should contain the CommunicationErrorCodes key.