Troubleshooting Tip: Getting error when trying to reload/refresh an Excel workbook file connected to SQL Database

[jbernabe]

Description	This article describes when an Excel workbook file gets an error message when trying to reload/refresh. This Excel workbook file was connected to the SQL Database and accessed via WAN. Error message received: '[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation'. '[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv())'.
Scope	FortiGate.
Solution	The error message were appearing only when security profile IPS was enabled on the firewall policy.  Run debug flow on the FortiGate CLI console. diag debug reset  diag debug disable diag debug flow sho fun en diag debug flow sho iprop en diag debug flow filter saddr x.x.x.x diag debug flow filter daddr y.y.y.y diag debug flow trace start 99999999 diag debug en Review the debug flow result and find if there is a log message msg="anti-replay check fails, drop". If there is a log message msg="anti-replay check fails, drop" disable the anti-replay on the firewall policy. config firewall policy     edit x         set anti-replay disable     end Once anti-replay is disabled on the firewall policy, the Excel file can now reload/refresh without any error.