UIPATH mariaDB Insert 오류

Ask in Your Language Korea RPA 개발자를 위한 공간
,
1

UiPath 지침에 따라 mariadb를 잘 설치하고 connect to database 까지 성공적으로 마쳤습니다.
그러나 data를 넣으려는 insert 구문에서 오류가 발생하였습니다.

오류의 내용은 아래와 같습니다.

Insert: ERROR [42000] [ma-3.1.19][10.11.2-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘DEFAULT VALUES’ at line 1

무슨이유 일까요?

2

Hi @Ilgu_Yong ,
Could you please share your screen short
regards,

3

@Ilgu_Yong

Can you please show what insert you have used

Cheers

5

image
image2016×1512 1.01 MB

korea language, 연결 = connect
simple flow, but i can use insert

6

image
image2016×1512 1010 KB

UiPath version: 23.10
UiPath.database.activityes : 1.7.1
i was tried 1.5.0 ~1.7.1 version but it was not working

7

I checked several similar symptoms and saw that some were successful by changing Database activities to version 1.4. But that doesn’t seem to be the answer.

8

@Ilgu_Yong

Inset actitvity will work only when given excel has the column type and data type exactly matchign with the db

cheers

9

of course. It’s the exact same Excel form. This is not a problem. Thank you for leaving a reply!

10

@Ilgu_Yong

is the datatype also same?

can you try with a simple table with only one column and text type in datatable

cheers