When using a multi tenant environment such as MariaDB, you could potentially see the error below if you left a workstation running overnight with SalesPartner open - particularly where you have hibernating computers or PCs that are left on standby / sleep.
[FireDAC][Phys][MySQL] MySQL server has gone away.
The solution is to add these two extra AutoReconnect options in the MariaDB connection definition via
C:\spartner\FDConnectionDefs.ini
Using Notepad to edit the INI file copy and paste this text.
ResourceOptions.AssignedValues= [rvAutoReconnect]
ResourceOptions.AutoReconnect= True
Then save the INI file and restart SalesPartner to apply changes.
RSS Feed
