Database Insert Activity Is Failing

Why error [42000] [MySQL][ODBC 8.0(w) Driver][mysqld-8.0.23] is thrown. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT VALUES' at line 1 while using Database insert activity?

The possible cause of the issue is the compatibility between Driver and SQL Database version. So, please make sure that the driver installed is compatible with SQL database version. Refer the Microsoft JDBC Driver For SQL Server Support Matrix - to check compatibility between driver and SQL version.

Also it is suggested to check the behavior by upgrading the Uipath.Database.Activities package version.