What's the reason of "Copy data to target RDBMS failed" in Transfer the data to the MySQL database

[Zane Wang]

Starting...
Prepare information for data copy...
Prepare information for data copy done
Determine number of rows to copy....
Counting number of rows in tables...
wbcopytables.exe --count-only --passwords-from-stdin --odbc-source="DSN=MS Access Database" --table-file=c:\users\bwang\appdata\local\temp\tmposhc5x
01:02:35 [INF][ copytable]: --table "Hcp_Contactlist_DB"
01:02:35 [INF][ copytable]: Opening ODBC connection to [unknown] 'DSN=MS Access Database;PWD=XXX'
01:02:35 [INF][ copytable]: ODBC connection to 'DSN=MS Access Database;PWD=' opened

10410 total rows in 1 tables need to be copied:
- ."Hcp_Contactlist_DB": 10410
Determine number of rows to copy finished
Copy data to target RDBMS....

Migrating data...
wbcopytables.exe --odbc-source="DSN=MS Access Database" --target="root@127.0.0.1:3306" --progress --passwords-from-stdin --log-level=debug3 --thread-count=1 --source-rdbms-type=MsAccess --source-charset=gb2312 --table-file=c:\users\bwang\appdata\local\temp\tmpoheofq
Loading table information from file c:\users\bwang\appdata\local\temp\tmpoheofq

ERROR: `China Channel Database_CCSCC`.`Hcp_Contactlist_DB`:SQLExecDirect(SELECT "ID_IDC", "Tracker", "名单类型", "上期进货量", "本期进货量", "访问员", "合作等级", "本期情况分类", "本期情况说明", "上期情况分类", "上期情况说明", "品牌中文", "品牌英文", "渠道级别_IDC定义", "技术类型", "产品线", "渠道级别", "拿货渠道级别", "区域", "省份", "城市", "公司名称", "首要联系人", "联系人", "部门", "职务", "性别", "座机", "手机", "Email", "副营产品", "主营行业", "员工人数", "去年收入金额_全年", "是否同意", "注册人数", "合作伙伴注册人姓名", "C15Q3情况分类", "C15Q3情况说明", "C15Q2情况分类", "C15Q2情况说明", "C13Q4情况分类", "C13Q4情况说明", "C13Q3情况分类", "C13Q3情况说明", "C13Q2情况分类", "C13Q2情况说明", "C13Q1情况分类", "C13Q1情况说明", "公司主页", "地址", "邮编", "传真", "预约时间", "预约电话", "预约联系人" FROM "Hcp_Contactlist_DB"): 07002:117:[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect


ERROR: `China Channel Database_CCSCC`.`Hcp_Contactlist_DB`:Failed copying 10410 rows
FINISHED

01:02:35 [INF][ copytable]: Logger set to level 'debug3'. '0111111'

01:02:35 [INF][ copytable]: --table "Hcp_Contactlist_DB" `China Channel Database_CCSCC` `Hcp_Contactlist_DB` "ID_IDC", "Tracker", "名单类型", "上期进货量", "本期进货量", "访问员", "合作等级", "本期情况分类", "本期情况说明", "上期情况分类", "上期情况说明", "品牌中文", "品牌英文", "渠道级别_IDC定义", "技术类型", "产品线", "渠道级别", "拿货渠道级别", "区域", "省份", "城市", "公司名称", "首要联系人", "联系人", "部门", "职务", "性别", "座机", "手机", "Email", "副营产品", "主营行业", "员工人数", "去年收入金额_全年", "是否同意", "注册人数", "合作伙伴注册人姓名", "C15Q3情况分类", "C15Q3情况说明", "C15Q2情况分类", "C15Q2情况说明", "C13Q4情况分类", "C13Q4情况说明", "C13Q3情况分类", "C13Q3情况说明", "C13Q2情况分类", "C13Q2情况说明", "C13Q1情况分类", "C13Q1情况说明", "公司主页", "地址", "邮编", "传真", "预约时间", "预约电话", "预约联系人"

01:02:35 [INF][ copytable]: Connecting to MySQL server at 127.0.0.1:3306 with user root

01:02:35 [INF][ copytable]: Connection to MySQL opened

01:02:35 [DB1][ copytable]: Detected server version=5.7.12-log

01:02:35 [DB1][ copytable]: Detected max_allowed_packet=4194304

01:02:35 [INF][ copytable]: Setting charset for source data to gb2312

01:02:35 [DB1][ copytable]: Retrieving trigger list

01:02:35 [INF][ copytable]: Opening ODBC connection to [MsAccess] 'DSN=MS Access Database;PWD=XXX'

01:02:35 [INF][ copytable]: ODBC connection to 'DSN=MS Access Database;PWD=' opened

01:02:35 [INF][ copytable]: Connecting to MySQL server at 127.0.0.1:3306 with user root

01:02:35 [INF][ copytable]: Connection to MySQL opened

01:02:35 [DB1][ copytable]: Detected server version=5.7.12-log

01:02:35 [DB1][ copytable]: Detected max_allowed_packet=4194304

01:02:35 [INF][ copytable]: Setting charset for source data to gb2312

01:02:35 [DB1][ copytable]: Executing query: SELECT count(*) FROM ."Hcp_Contactlist_DB"

01:02:35 [DB1][ copytable]: Executing query: SELECT "ID_IDC", "Tracker", "名单类型", "上期进货量", "本期进货量", "访问员", "合作等级", "本期情况分类", "本期情况说明", "上期情况分类", "上期情况说明", "品牌中文", "品牌英文", "渠道级别_IDC定义", "技术类型", "产品线", "渠道级别", "拿货渠道级别", "区域", "省份", "城市", "公司名称", "首要联系人", "联系人", "部门", "职务", "性别", "座机", "手机", "Email", "副营产品", "主营行业", "员工人数", "去年收入金额_全年", "是否同意", "注册人数", "合作伙伴注册人姓名", "C15Q3情况分类", "C15Q3情况说明", "C15Q2情况分类", "C15Q2情况说明", "C13Q4情况分类", "C13Q4情况说明", "C13Q3情况分类", "C13Q3情况说明", "C13Q2情况分类", "C13Q2情况说明", "C13Q1情况分类", "C13Q1情况说明", "公司主页", "地址", "邮编", "传真", "预约时间", "预约电话", "预约联系人" FROM "Hcp_Contactlist_DB"

01:02:35 [INF][ copytable]: Re-enabling triggers for schema 'China Channel Database_CCSCC'

01:02:35 [DB1][ copytable]: Retrieving trigger definitions

01:02:35 [INF][ copytable]: No triggers found for 'China Channel Database_CCSCC'














Copy helper has finished

Data copy results:
- `China Channel Database_CCSCC`.`Hcp_Contactlist_DB` has FAILED (0 of 10410 rows copied)
0 tables of 1 were fully copied
Click [Retry] to retry copying remaining data from tables
Copy data to target RDBMS finished
Tasks finished with warnings and/or errors, view the logs for details
Finished performing tasks.