发布于 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]