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. diagnose debug reset  diagnose debug disable diagnose debug flow show function-name enable diagnose debug flow show iprope enable diagnose debug flow filter saddr x.x.x.x diagnose debug flow filter daddr y.y.y.y diagnose debug flow trace start 99999999 diagnose debug enable To stop debug: diagnose debug disable diagnose debug reset  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.