We request that D365fO's standard functionality includes mechanisms to handle transient database disconnections.
Specifically, we would like the platform to implement automatic reconnection processes at the platform level when such disconnections occur.
Details
Microsoft advises implementing custom exception handling to catch the TransientSqlConnectionError exception in add-on programs.
However, since this handling is not provided in the standard features, such disconnections result in abnormal terminations of both online and batch processes.
As a result, we are experiencing frequent "temporary issues" due to transient database disconnections.
AX2012 had settings in the Server Configuration to handle such scenarios at the kernel level:
- Number of connection retries
- Connection retry interval
These settings allowed the system to automatically attempt reconnections to the database upon disconnection.
Therefore, we request that D365fO also implements automatic reconnection mechanisms at the platform level to handle transient database disconnections effectively.