一样的table配置,入库本地数据库无报错,入库服务器出现以下问题报错
p25, Dir.: Input, Type: adInteger, Size: 0, Value: "None", 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 "F:\ShadowBot\shadowbot-5.9.26\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(a) Driver][mysqld-5.7.33-36]No database selected', None, 0, -2147467259), None)
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "F:\ShadowBot\shadowbot-5.9.26\python\lib\runpy.py", line 193, in _run_module_as_main
"__main__", mod_spec)
File "F:\ShadowBot\shadowbot-5.9.26\python\lib\runpy.py", line 85, in _run_code
exec(code, run_globals)
File "F:\ShadowBot\shadowbot-5.9.26\python\lib\site-packages\xbot_interpreter.py", line 67, in <module>
main()
File "F:\ShadowBot\shadowbot-5.9.26\python\lib\site-packages\xbot_interpreter.py", line 45, in main
try:
File "C:\Users\kevin\AppData\Local\ShadowBot\users\67853918712160256\apps\a2c67bfe-dad2-44f6-a925-65d16c3b8f45\xbot_robot\process34.py", line 68, in main
xbot_visual.database.batch_insert(connect_way="database", database=database, conn_str=None, sql="insert into bz_red_creativereport", data=database_red, _block=("子流程3", 57, "数据库批量插入数据"))
File "<string>", line 87, in wrapper
File "<string>", line 82, in wrapper
File "<string>", line 65, in batch_insert
File "<string>", line 63, 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(a) Driver][mysqld-5.7.33-36]No database selected', None, 0, -2147467259), None)
Command:
insert into bz_red_creativereport values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
Parameters:
[Name: p0, Dir.: Input, Type: adBSTR, Size: 10, Value: "2023/03/18", Precision: 0, NumericScale: 0
Name: p1, Dir.: Input, Type: adBSTR, Size: 91, Value: "http://ci.xiaohongshu.com/01028k01kqmhgngul3v010n2wwl00ct35a?imageView2/2/w/1080/format/jpg", Precision: 0, NumericScale: 0
Name: p2, Dir.: Input, Type: adBSTR, Size: 13, Value: "TIU_啊来_220820", Precision: 0, NumericScale: 0
Name: p3, Dir.: Input, Type: adBSTR, Size: 3, Value: "TIU", Precision: 0, NumericScale: 0
Name: p4, Dir.: Input, Type: adBSTR, Size: 2, Value: "啊来", Precision: 0, NumericScale: 0
Name: p5, Dir.: Input, Type: adDouble, Size: 0, Value: "28126269.0", Precision: 0, NumericScale: 0
Name: p6, Dir.: Input, Type: adBSTR, Size: 24, Value: "63004af0000000001b01acaa", Precision: 0, NumericScale: 0
Name: p7, Dir.: Input, Type: adBSTR, Size: 16, Value: "TIU_行业-美妆个护_啊来_2", Precision: 0, NumericScale: 0
Name: p8, Dir.: Input, Type: adBSTR, Size: 7, Value: "行业-美妆个护", Precision: 0, NumericScale: 0
Name: p9, Dir.: Input, Type: adDouble, Size: 0, Value: "8125858.0", Precision: 0, NumericScale: 0
Name: p10, Dir.: Input, Type: adBSTR, Size: 20, Value: "0116_粉底液_TIU_啊来_手动_2", Precision: 0, NumericScale: 0
Name: p11, Dir.: Input, Type: adBSTR, Size: 2, Value: "啊来", Precision: 0, NumericScale: 0
Name: p12, Dir.: Input, Type: adDouble, Size: 0, Value: "6558627.0", Precision: 0, NumericScale: 0
Name: p13, Dir.: Input, Type: adBSTR, Size: 5, Value: "自定义创意", Precision: 0, NumericScale: 0
Name: p14, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p15, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p16, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p17, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p18, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p19, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p20, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p21, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p22, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p23, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p24, Dir.: Input, Type: adDouble, Size: 0, Value: "0.0", Precision: 0, NumericScale: 0
Name: p25, Dir.: Input, Type: adInteger, Size: 0, Value: "None", Precision: 0, NumericScale: 0]

