文件型数据源中数据集复制到MySql数据源失败

0 投票
文件型数据源中数据集复制到MySql数据源时失败

[13:31:35] 新建矢量数据集失败
[13:31:35] Field 'SmCreateTime' doesn't have a default value

log:

2019-08-20 13:25:43 [error] Fail Exec strSQL=Select SmUser, SmVersion, SmWorkspaceName from xinaogis.SmWorkspace error=Table 'xinaogis.smworkspace' doesn't exist, ThreadID: 15864, Timespan(ms): 322094, ResourceID: 4294967196, SourceCode: D:\UGO7CTrunk\01_SourceCode\Src\EngineMySQL\UGDataSourceMySQL.cpp(987)
2019-08-20 13:28:33 [error] Field 'SmCreateTime' doesn't have a default value, ThreadID: 9804, Timespan(ms): 170563, ResourceID: 4294967196, SourceCode: D:\UGO7CTrunk\01_SourceCode\Src\EngineMySQL\UGDatasetVectorMySQL.cpp(746)
2019-08-20 13:28:33 [error] 新建矢量数据集失败, ThreadID: 9804, Timespan(ms): 15, ResourceID: ELc038, SourceCode: D:\UGO7CTrunk\01_SourceCode\Src\EngineMySQL\UGDatasetVectorMySQL.cpp(759)
2019-08-20 13:28:34 [error] Field 'SmCreateTime' doesn't have a default value, ThreadID: 9804, Timespan(ms): 235, ResourceID: 4294967196, SourceCode: D:\UGO7CTrunk\01_SourceCode\Src\EngineMySQL\UGDatasetVectorMySQL.cpp(746)
8月 20, 2019 分类:  129次浏览 | 用户: qiurui 才疏学浅 (11 分)

1个回答

0 投票
您好,您这边检查一下数据源数据集以及工作空间命名中是否有点符号,有的话需要去掉点符号,同时检查属性表中是否有字段没有默认的缺省值,有的话需要在属性中赋予缺省值
8月 20, 2019 用户: 林立勇 才高八斗 (933 分)
文件型数据源中数据集复制到MySql数据源失败
...