I am facing below error while insert a table into for your info i am uploading excel data into data table from the data table ,after this writing datatable into MYSQL database.
Facing above error while uploading into sql table ?
1 Like
Hi,
Different version of the Database Activities package, not compatible with version of UiPath!
Install the previous version of database package and try.
Hi
Check this knowledge base from UiPath
Cause : 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
Some relevant forum post as well for your reference
Cheers @nabisab.18
Hello @nabisab.18 , Check your Query, An Error may occur due to the Worng Query or Mismatch Table name. Check your Table name.
- The datatypes of each column should be exactly matching with the datatypes of the db columns and excel
- Column names should be an exact match
- The driver you are using should support bulk insert
Please check these
Cheers
Can you pls share me old database packages download path ,i am unable to find it .
Hi @nabisab.18
I feel like this is purely due to compatibility issue
Have a view on this knowledge base from UiPath team
Cheers
@Palaniyappan @neha.upase @Anil_G @Gokul_Jayakumar
I am using below drivers for configurations
Mysql server version: 8.0.30
Jdk/jre -1.8 or 11
MySql connector -odbc 8.0.30
Still facing same error also tried with downgrading database packages version available as per manage package UiPath latest version .
Shall i check with older database packages such database packages 4.0 version or other.
Pls let me know how to download older packages of database or where it is available ?
Thanks in advance
You can get that from Design tab → manage packages → All Packages → search for UiPath.Database activity and get the version you want
yes Column names and types are correctly only .
Let me know any better approach for this soluttion.
@Yoichi @Palaniyappan @Theresa
I have used above all the version ending with same error .
Earlier who has faced this error they tried with database packages for version 4.1 or 3.1 so for them it was worked out.
On this view i wanted to try even that also as of now i am not able fix this error ,can you please let me know Is it UiPath version is matters with MySql Version . Please clarify me it may be silly but it’s trial and error for me …
Your inputs are valuable to me to get through this error .
The error message “Insert: ERROR [: MySQL][ODBC 8.1(a) Driver][mysqld-8.1.0]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 in UiPath” means that there is an error in your SQL INSERT statement. The error is occurring near the DEFAULT VALUES clause.
There are a few possible reasons for this error:
- The column names in your INSERT statement do not match the column names in the database table.
- The data types in your INSERT statement do not match the data types of the corresponding columns in the database table.
- You are trying to insert a value into a column that does not allow NULL values, but the value that you are trying to insert is NULL.
- There is a syntax error in your INSERT statement.
To resolve this error, you need to identify and fix the problem with your SQL INSERT statement. You can do this by checking the MySQL documentation for the correct syntax for INSERT statements. You can also try running your INSERT statement in a MySQL client, such as MySQL Workbench, to see if the error occurs there.
Here are some additional tips for troubleshooting this error:
- Make sure that the column names in your INSERT statement are spelled correctly.
- Make sure that the data types in your INSERT statement match the data types of the corresponding columns in the database table.
- If you are trying to insert a value into a column that does not allow NULL values, make sure that the value that you are trying to insert is not NULL.
- Check the MySQL documentation for the correct syntax for INSERT statements.
- Try running your INSERT statement in a MySQL client, such as MySQL Workbench, to see if the error occurs there.
If you are still having problems, please provide more information about your workflow and the specific UiPath activity that you are using.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.