数据库批量插入数据报销怎么查看问题在哪
回答
收藏

数据库批量插入数据报销怎么查看问题在哪

H
Hiker
2023-10-19 22:33·浏览量:400
H
Hiker
发布于 2023-10-19 22:33400浏览

p17, Dir.: Input, Type: adBSTR, Size: 0, Value: "", Precision: 0, NumericScale: 0]

Traceback (most recent call last):

 File "<string>", line 726, in _execute_command

 File "<COMObject ADODB.Command>", line 3, in Execute

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.13.33\python\lib\site-packages\win32com\client\dynamic.py", line 287, in _ApplyTypes_

   result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType, argTypes) + args)

pywintypes.com_error: (-2147352567, '发生意外。', (0, 'Microsoft OLE DB Provider for ODBC Drivers', "[MySQL][ODBC 8.0(w) Driver][mysqld-8.0.33]Data too long for column '是否找到' at row 1", None, 0, -2147467259), None)


During handling of the above exception, another exception occurred:


Traceback (most recent call last):

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.13.33\python\lib\runpy.py", line 193, in _run_module_as_main

   "__main__", mod_spec)

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.13.33\python\lib\runpy.py", line 85, in _run_code

   exec(code, run_globals)

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.13.33\python\lib\site-packages\xbot_interpreter.py", line 94, in <module>

   main()

 File "C:\Program Files (x86)\ShadowBot\shadowbot-5.13.33\python\lib\site-packages\xbot_interpreter.py", line 53, in main

   try:

 File "C:\Users\Administrator\AppData\Local\ShadowBot\users\46bdab65-3afb-424e-a95e-d935266e8975\apps\6e52aa62-66de-46db-8f83-e0e4333288c1\xbot_robot\process4.py", line 13, in main

   xbot_visual.database.batch_insert(connect_way="database", database=database, conn_str=None, sql="insert into myon20231017", data=excel_data, _block=("子流程3", 5, "数据库批量插入数据"))

 File "<string>", line 89, in wrapper

 File "<string>", line 84, in wrapper

 File "<string>", line 64, in batch_insert

 File "<string>", line 45, in exec_many

 File "<string>", line 70, in exec_many

 File "<string>", line 932, in executemany

 File "<string>", line 919, in execute

 File "<string>", line 734, in _execute_command

 File "<string>", line 607, in _raiseCursorError

 File "<string>", line 57, in standardErrorHandler

xbot.adoapi.apibase.DatabaseError: (-2147352567, '发生意外。', (0, 'Microsoft OLE DB Provider for ODBC Drivers', "[MySQL][ODBC 8.0(w) Driver][mysqld-8.0.33]Data too long for column '是否找到' at row 1", None, 0, -2147467259), None)

Command:

insert into myon20231017 values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Parameters:

[Name: p16, Dir.: Input, Type: adBSTR, Size: 55, Value: "Brush", Precision: 0, NumericScale: 0

Name: p17, Dir.: Input, Type: adBSTR, Size: 0, Value: "", Precision: 0, NumericScale: 0]



收藏
全部回答1
最新
发布回答
回答