{"action":"created","issue":{"url":"https://api.github.com/repos/alibaba/otter/issues/165","repository_url":"https://api.github.com/repos/alibaba/otter","labels_url":"https://api.github.com/repos/alibaba/otter/issues/165/labels{/name}","comments_url":"https://api.github.com/repos/alibaba/otter/issues/165/comments","events_url":"https://api.github.com/repos/alibaba/otter/issues/165/events","html_url":"https://github.com/alibaba/otter/issues/165","id":163787852,"number":165,"title":"insert 中文异常","user":{"login":"fg-meizhi","id":11486319,"avatar_url":"https://avatars.githubusercontent.com/u/11486319?v=3","gravatar_id":"","url":"https://api.github.com/users/fg-meizhi","html_url":"https://github.com/fg-meizhi","followers_url":"https://api.github.com/users/fg-meizhi/followers","following_url":"https://api.github.com/users/fg-meizhi/following{/other_user}","gists_url":"https://api.github.com/users/fg-meizhi/gists{/gist_id}","starred_url":"https://api.github.com/users/fg-meizhi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fg-meizhi/subscriptions","organizations_url":"https://api.github.com/users/fg-meizhi/orgs","repos_url":"https://api.github.com/users/fg-meizhi/repos","events_url":"https://api.github.com/users/fg-meizhi/events{/privacy}","received_events_url":"https://api.github.com/users/fg-meizhi/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-07-05T07:30:57Z","updated_at":"2016-07-05T08:17:56Z","closed_at":"2016-07-05T08:16:08Z","body":"@agapple 你好，同步时插入中文发生异常\r\n\r\n数据库，表，编码均为 utf8，请问是什么原因导致？\r\n另外 ，如何判断是在哪个步骤出现的问题？canal 读取binlog？还是在 node 插入时发生的异常？\r\n![2016-07-05 at 14 42](https://cloud.githubusercontent.com/assets/11486319/16576989/28384bdc-42c5-11e6-9c3e-a6c339eb6ba5.png)\r\n![2016-07-05 at 14 44](https://cloud.githubusercontent.com/assets/11486319/16576991/2db6938e-42c5-11e6-8e7f-3848c687bc73.png)\r\n![2016-07-05 at 15 29](https://cloud.githubusercontent.com/assets/11486319/16577010/412bc204-42c5-11e6-984c-6ca669903cf0.png)\r\n\r\nnid:2 为 slave node\r\n\r\n> pid:1 nid:2 exception:setl:com.alibaba.otter.node.etl.load.exception.LoadException: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into wl.zata_data_55(`org_6_group` , `org_6_group_custom_code` , `org_6_group_system_code` , `org_6_area` , `org_6_area_custom_code` , `org_6_area_system_code` , `org_6_company` , `org_6_company_custom_code` , `org_6_company_system_code` , `org_6_city` , `org_6_city_custom_code` , `org_6_city_system_code` , `org_6_dept` , `org_6_dept_custom_code` , `org_6_dept_system_code` , `org_6_stage` , `org_6_stage_custom_code` , `org_6_stage_system_code` , `org_5_group` , `org_5_group_custom_code` , `org_5_group_system_code` , `org_5_company` , `org_5_company_custom_code` , `org_5_company_system_code` , `org_5_city` , `org_5_city_custom_code` , `org_5_city_system_code` , `org_5_dept` , `org_5_dept_custom_code` , `org_5_dept_system_code` , `org_5_stage` , `org_5_stage_custom_code` , `org_5_stage_system_code` , `data_source` , `paper_no` , `finished` , `d_owner_type_four` , `d_owner_type_four_custom_code` , `d_owner_type_four_system_code` , `d_house_type` , `d_house_type_custom_code` , `d_house_type_system_code` , `d_decoration_type` , `d_decoration_type_custom_code` , `d_decoration_type_system_code` , `d_company_type` , `d_company_type_custom_code` , `d_company_type_system_code` , `d_seal_up` , `d_seal_up_custom_code` , `d_seal_up_system_code` , `d_zone_type` , `d_zone_type_custom_code` , `d_zone_type_system_code` , `d_prd_category` , `d_prd_category_custom_code` , `d_prd_category_system_code` , `d_decoration_category` , `d_decoration_category_custom_code` , `d_decoration_category_system_code` , `d_name` , `d_name_custom_code` , `d_name_system_code` , `d_mobile` , `d_mobile_custom_code` , `d_mobile_system_code` , `d_form_group` , `d_form_group_custom_code` , `d_form_group_system_code` , `d_form_stage` , `d_form_stage_custom_code` , `d_form_stage_system_code` , `d_building` , `d_building_custom_code` , `d_building_system_code` , `d_unit_no` , `d_unit_no_custom_code` , `d_unit_no_system_code` , `d_house_no` , `d_house_no_custom_code` , `d_house_no_system_code` , `d_comment_one` , `d_comment_one_custom_code` , `d_comment_one_system_code` , `d_comment_two` , `d_comment_two_custom_code` , `d_comment_two_system_code` , `d_fg_unique_no` , `d_fg_unique_no_custom_code` , `d_fg_unique_no_system_code` , `d_sign_datetime` , `d_sign_datetime_custom_code` , `d_sign_datetime_system_code` , `d_contract_datetime` , `d_contract_datetime_custom_code` , `d_contract_datetime_system_code` , `d_deliver_datetime` , `d_deliver_datetime_custom_code` , `d_deliver_datetime_system_code` , `d_owner_type_seven_plus` , `d_owner_type_seven_plus_custom_code` , `d_owner_type_seven_plus_system_code` , `d_exam_stage` , `d_exam_stage_custom_code` , `d_exam_stage_system_code` , `encrypt` , `A1` , `A3` , `A4` , `A5` , `A6` , `A7` , `A8` , `A9` , `A10` , `A11` , `A12` , `A2` , `A13` , `D1` , `E0` , `E1_1` , `E1_2` , `E1_3` , `E3_1` , `E3_2` , `E3_3` , `E3_4` , `E3_5` , `E3_6` , `E3_7` , `E3_8` , `createtime` , `P1` , `A1a` , `d_house_business` , `d_house_business_custom_code` , `d_house_business_system_code` , `d_house_sensitive` , `d_house_sensitive_custom_code` , `d_house_sensitive_system_code` , `d_house_sensitive_text` , `d_house_sensitive_text_custom_code` , `d_house_sensitive_text_system_code` , `d_comment_three` , `d_comment_three_custom_code` , `d_comment_three_system_code` , `d_comment_four` , `d_comment_four_custom_code` , `d_comment_four_system_code` , `excel_source_date` , `excel_source_file_name` , `excel_source_file_line_no` , `id`) values (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update `org_6_group`=values(`org_6_group`) , `org_6_group_custom_code`=values(`org_6_group_custom_code`) , `org_6_group_system_code`=values(`org_6_group_system_code`) , `org_6_area`=values(`org_6_area`) , `org_6_area_custom_code`=values(`org_6_area_custom_code`) , `org_6_area_system_code`=values(`org_6_area_system_code`) , `org_6_company`=values(`org_6_company`) , `org_6_company_custom_code`=values(`org_6_company_custom_code`) , `org_6_company_system_code`=values(`org_6_company_system_code`) , `org_6_city`=values(`org_6_city`) , `org_6_city_custom_code`=values(`org_6_city_custom_code`) , `org_6_city_system_code`=values(`org_6_city_system_code`) , `org_6_dept`=values(`org_6_dept`) , `org_6_dept_custom_code`=values(`org_6_dept_custom_code`) , `org_6_dept_system_code`=values(`org_6_dept_system_code`) , `org_6_stage`=values(`org_6_stage`) , `org_6_stage_custom_code`=values(`org_6_stage_custom_code`) , `org_6_stage_system_code`=values(`org_6_stage_system_code`) , `org_5_group`=values(`org_5_group`) , `org_5_group_custom_code`=values(`org_5_group_custom_code`) , `org_5_group_system_code`=values(`org_5_group_system_code`) , `org_5_company`=values(`org_5_company`) , `org_5_company_custom_code`=values(`org_5_company_custom_code`) , `org_5_company_system_code`=values(`org_5_company_system_code`) , `org_5_city`=values(`org_5_city`) , `org_5_city_custom_code`=values(`org_5_city_custom_code`) , `org_5_city_system_code`=values(`org_5_city_system_code`) , `org_5_dept`=values(`org_5_dept`) , `org_5_dept_custom_code`=values(`org_5_dept_custom_code`) , `org_5_dept_system_code`=values(`org_5_dept_system_code`) , `org_5_stage`=values(`org_5_stage`) , `org_5_stage_custom_code`=values(`org_5_stage_custom_code`) , `org_5_stage_system_code`=values(`org_5_stage_system_code`) , `data_source`=values(`data_source`) , `paper_no`=values(`paper_no`) , `finished`=values(`finished`) , `d_owner_type_four`=values(`d_owner_type_four`) , `d_owner_type_four_custom_code`=values(`d_owner_type_four_custom_code`) , `d_owner_type_four_system_code`=values(`d_owner_type_four_system_code`) , `d_house_type`=values(`d_house_type`) , `d_house_type_custom_code`=values(`d_house_type_custom_code`) , `d_house_type_system_code`=values(`d_house_type_system_code`) , `d_decoration_type`=values(`d_decoration_type`) , `d_decoration_type_custom_code`=values(`d_decoration_type_custom_code`) , `d_decoration_type_system_code`=values(`d_decoration_type_system_code`) , `d_company_type`=values(`d_company_type`) , `d_company_type_custom_code`=values(`d_company_type_custom_code`) , `d_company_type_system_code`=values(`d_company_type_system_code`) , `d_seal_up`=values(`d_seal_up`) , `d_seal_up_custom_code`=values(`d_seal_up_custom_code`) , `d_seal_up_system_code`=values(`d_seal_up_system_code`) , `d_zone_type`=values(`d_zone_type`) , `d_zone_type_custom_code`=values(`d_zone_type_custom_code`) , `d_zone_type_system_code`=values(`d_zone_type_system_code`) , `d_prd_category`=values(`d_prd_category`) , `d_prd_category_custom_code`=values(`d_prd_category_custom_code`) , `d_prd_category_system_code`=values(`d_prd_category_system_code`) , `d_decoration_category`=values(`d_decoration_category`) , `d_decoration_category_custom_code`=values(`d_decoration_category_custom_code`) , `d_decoration_category_system_code`=values(`d_decoration_category_system_code`) , `d_name`=values(`d_name`) , `d_name_custom_code`=values(`d_name_custom_code`) , `d_name_system_code`=values(`d_name_system_code`) , `d_mobile`=values(`d_mobile`) , `d_mobile_custom_code`=values(`d_mobile_custom_code`) , `d_mobile_system_code`=values(`d_mobile_system_code`) , `d_form_group`=values(`d_form_group`) , `d_form_group_custom_code`=values(`d_form_group_custom_code`) , `d_form_group_system_code`=values(`d_form_group_system_code`) , `d_form_stage`=values(`d_form_stage`) , `d_form_stage_custom_code`=values(`d_form_stage_custom_code`) , `d_form_stage_system_code`=values(`d_form_stage_system_code`) , `d_building`=values(`d_building`) , `d_building_custom_code`=values(`d_building_custom_code`) , `d_building_system_code`=values(`d_building_system_code`) , `d_unit_no`=values(`d_unit_no`) , `d_unit_no_custom_code`=values(`d_unit_no_custom_code`) , `d_unit_no_system_code`=values(`d_unit_no_system_code`) , `d_house_no`=values(`d_house_no`) , `d_house_no_custom_code`=values(`d_house_no_custom_code`) , `d_house_no_system_code`=values(`d_house_no_system_code`) , `d_comment_one`=values(`d_comment_one`) , `d_comment_one_custom_code`=values(`d_comment_one_custom_code`) , `d_comment_one_system_code`=values(`d_comment_one_system_code`) , `d_comment_two`=values(`d_comment_two`) , `d_comment_two_custom_code`=values(`d_comment_two_custom_code`) , `d_comment_two_system_code`=values(`d_comment_two_system_code`) , `d_fg_unique_no`=values(`d_fg_unique_no`) , `d_fg_unique_no_custom_code`=values(`d_fg_unique_no_custom_code`) , `d_fg_unique_no_system_code`=values(`d_fg_unique_no_system_code`) , `d_sign_datetime`=values(`d_sign_datetime`) , `d_sign_datetime_custom_code`=values(`d_sign_datetime_custom_code`) , `d_sign_datetime_system_code`=values(`d_sign_datetime_system_code`) , `d_contract_datetime`=values(`d_contract_datetime`) , `d_contract_datetime_custom_code`=values(`d_contract_datetime_custom_code`) , `d_contract_datetime_system_code`=values(`d_contract_datetime_system_code`) , `d_deliver_datetime`=values(`d_deliver_datetime`) , `d_deliver_datetime_custom_code`=values(`d_deliver_datetime_custom_code`) , `d_deliver_datetime_system_code`=values(`d_deliver_datetime_system_code`) , `d_owner_type_seven_plus`=values(`d_owner_type_seven_plus`) , `d_owner_type_seven_plus_custom_code`=values(`d_owner_type_seven_plus_custom_code`) , `d_owner_type_seven_plus_system_code`=values(`d_owner_type_seven_plus_system_code`) , `d_exam_stage`=values(`d_exam_stage`) , `d_exam_stage_custom_code`=values(`d_exam_stage_custom_code`) , `d_exam_stage_system_code`=values(`d_exam_stage_system_code`) , `encrypt`=values(`encrypt`) , `A1`=values(`A1`) , `A3`=values(`A3`) , `A4`=values(`A4`) , `A5`=values(`A5`) , `A6`=values(`A6`) , `A7`=values(`A7`) , `A8`=values(`A8`) , `A9`=values(`A9`) , `A10`=values(`A10`) , `A11`=values(`A11`) , `A12`=values(`A12`) , `A2`=values(`A2`) , `A13`=values(`A13`) , `D1`=values(`D1`) , `E0`=values(`E0`) , `E1_1`=values(`E1_1`) , `E1_2`=values(`E1_2`) , `E1_3`=values(`E1_3`) , `E3_1`=values(`E3_1`) , `E3_2`=values(`E3_2`) , `E3_3`=values(`E3_3`) , `E3_4`=values(`E3_4`) , `E3_5`=values(`E3_5`) , `E3_6`=values(`E3_6`) , `E3_7`=values(`E3_7`) , `E3_8`=values(`E3_8`) , `createtime`=values(`createtime`) , `P1`=values(`P1`) , `A1a`=values(`A1a`) , `d_house_business`=values(`d_house_business`) , `d_house_business_custom_code`=values(`d_house_business_custom_code`) , `d_house_business_system_code`=values(`d_house_business_system_code`) , `d_house_sensitive`=values(`d_house_sensitive`) , `d_house_sensitive_custom_code`=values(`d_house_sensitive_custom_code`) , `d_house_sensitive_system_code`=values(`d_house_sensitive_system_code`) , `d_house_sensitive_text`=values(`d_house_sensitive_text`) , `d_house_sensitive_text_custom_code`=values(`d_house_sensitive_text_custom_code`) , `d_house_sensitive_text_system_code`=values(`d_house_sensitive_text_system_code`) , `d_comment_three`=values(`d_comment_three`) , `d_comment_three_custom_code`=values(`d_comment_three_custom_code`) , `d_comment_three_system_code`=values(`d_comment_three_system_code`) , `d_comment_four`=values(`d_comment_four`) , `d_comment_four_custom_code`=values(`d_comment_four_custom_code`) , `d_comment_four_system_code`=values(`d_comment_four_system_code`) , `excel_source_date`=values(`excel_source_date`) , `excel_source_file_name`=values(`excel_source_file_name`) , `excel_source_file_line_no`=values(`excel_source_file_line_no`) , `id`=values(`id`)]; SQL state [HY000]; error code [1366]; Incorrect string value: '\\xEF\\xBF\\xBD\\xEF\\xBF\\xBD...' for column 'org_6_group' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\\xEF\\xBF\\xBD\\xEF\\xBF\\xBD...' for column 'org_6_group' at row 1\r\nat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)\r\nat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)\r\nat org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)\r\nat org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)\r\nat org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker$2.doInTransaction(DbLoadAction.java:621)\r\nat org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.doCall(DbLoadAction.java:613)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.call(DbLoadAction.java:541)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doTwoPhase(DbLoadAction.java:458)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doLoad(DbLoadAction.java:275)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.load(DbLoadAction.java:161)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$FastClassByCGLIB$$d932a4cb.invoke()\r\nat net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)\r\nat org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$EnhancerByCGLIB$$80fd23c2.load()\r\nat com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:198)\r\nat com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:189)\r\nat java.util.concurrent.FutureTask.run(FutureTask.java:266)\r\nat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\r\nat java.util.concurrent.FutureTask.run(FutureTask.java:266)\r\nat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\nat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\r\nat java.lang.Thread.run(Thread.java:745)\r\nCaused by: java.sql.SQLException: Incorrect string value: '\\xEF\\xBF\\xBD\\xEF\\xBF\\xBD...' for column 'org_6_group' at row 1\r\nat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)\r\nat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)\r\nat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)\r\nat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)\r\nat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)\r\nat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)\r\nat com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)\r\nat com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145)\r\nat com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2081)\r\nat com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2066)\r\nat org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\nat org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\nat org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)\r\nat org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)\r\nat org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)\r\n... 21 more\r\n:-----------------\r\n- PairId: 1 , TableId: 2 , EventType : I , Time : 1467614672000 \r\n- Consistency : , Mode : \r\n-----------------\r\n---Pks\r\nEventColumn[index=0,columnType=-5,columnName=id,columnValue=224934,isNull=false,isKey=true,isUpdate=true]\r\n---oldPks\r\n\r\n---Columns\r\nEventColumn[index=1,columnType=12,columnName=org_6_group,columnValue=����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=2,columnType=12,columnName=org_6_group_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=3,columnType=12,columnName=org_6_group_system_code,columnValue=011,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=4,columnType=12,columnName=org_6_area,columnValue=�Ϻ�����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=5,columnType=12,columnName=org_6_area_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=6,columnType=12,columnName=org_6_area_system_code,columnValue=011003,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=7,columnType=12,columnName=org_6_company,columnValue=���Ϲ�˾,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=8,columnType=12,columnName=org_6_company_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=9,columnType=12,columnName=org_6_company_system_code,columnValue=011003008,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=10,columnType=12,columnName=org_6_city,columnValue=����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=11,columnType=12,columnName=org_6_city_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=12,columnType=12,columnName=org_6_city_system_code,columnValue=011003008002,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=13,columnType=12,columnName=org_6_dept,columnValue=������ɽMIXTOWN,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=14,columnType=12,columnName=org_6_dept_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=15,columnType=12,columnName=org_6_dept_system_code,columnValue=011003008002005,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=16,columnType=12,columnName=org_6_stage,columnValue=������ɽMIXTOWN����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=17,columnType=12,columnName=org_6_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=18,columnType=12,columnName=org_6_stage_system_code,columnValue=011003008002005003,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=19,columnType=12,columnName=org_5_group,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=20,columnType=12,columnName=org_5_group_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=21,columnType=12,columnName=org_5_group_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=22,columnType=12,columnName=org_5_company,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=23,columnType=12,columnName=org_5_company_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=24,columnType=12,columnName=org_5_company_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=25,columnType=12,columnName=org_5_city,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=26,columnType=12,columnName=org_5_city_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=27,columnType=12,columnName=org_5_city_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=28,columnType=12,columnName=org_5_dept,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=29,columnType=12,columnName=org_5_dept_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=30,columnType=12,columnName=org_5_dept_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=31,columnType=12,columnName=org_5_stage,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=32,columnType=12,columnName=org_5_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=33,columnType=12,columnName=org_5_stage_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=34,columnType=5,columnName=data_source,columnValue=1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=35,columnType=12,columnName=paper_no,columnValue=,isNull=true,isKey=false,isUpdate=true]\r\nEventColumn[index=36,columnType=5,columnName=finished,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=37,columnType=12,columnName=d_owner_type_four,columnValue=׼ҵ��,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=38,columnType=12,columnName=d_owner_type_four_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=39,columnType=12,columnName=d_owner_type_four_system_code,columnValue=001001,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=40,columnType=12,columnName=d_house_type,columnValue=�߲�,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=41,columnType=12,columnName=d_house_type_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=42,columnType=12,columnName=d_house_type_system_code,columnValue=003001,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=43,columnType=12,columnName=d_decoration_type,columnValue=װ�޷�,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=44,columnType=12,columnName=d_decoration_type_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=45,columnType=12,columnName=d_decoration_type_system_code,columnValue=004002,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=46,columnType=12,columnName=d_company_type,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=47,columnType=12,columnName=d_company_type_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=48,columnType=12,columnName=d_company_type_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=49,columnType=12,columnName=d_seal_up,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=50,columnType=12,columnName=d_seal_up_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=51,columnType=12,columnName=d_seal_up_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=52,columnType=12,columnName=d_zone_type,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=53,columnType=12,columnName=d_zone_type_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=54,columnType=12,columnName=d_zone_type_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=55,columnType=12,columnName=d_prd_category,columnValue=װ�޷�,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=56,columnType=12,columnName=d_prd_category_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=57,columnType=12,columnName=d_prd_category_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=58,columnType=12,columnName=d_decoration_category,columnValue=C,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=59,columnType=12,columnName=d_decoration_category_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=60,columnType=12,columnName=d_decoration_category_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=61,columnType=12,columnName=d_name,columnValue=���Ļ�,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=62,columnType=12,columnName=d_name_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=63,columnType=12,columnName=d_name_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=64,columnType=12,columnName=d_mobile,columnValue=15026590220,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=65,columnType=12,columnName=d_mobile_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=66,columnType=12,columnName=d_mobile_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=67,columnType=12,columnName=d_form_group,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=68,columnType=12,columnName=d_form_group_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=69,columnType=12,columnName=d_form_group_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=70,columnType=12,columnName=d_form_stage,columnValue=����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=71,columnType=12,columnName=d_form_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=72,columnType=12,columnName=d_form_stage_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=73,columnType=12,columnName=d_building,columnValue=78��,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=74,columnType=12,columnName=d_building_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=75,columnType=12,columnName=d_building_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=76,columnType=12,columnName=d_unit_no,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=77,columnType=12,columnName=d_unit_no_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=78,columnType=12,columnName=d_unit_no_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=79,columnType=12,columnName=d_house_no,columnValue=1604,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=80,columnType=12,columnName=d_house_no_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=81,columnType=12,columnName=d_house_no_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=82,columnType=12,columnName=d_comment_one,columnValue=��,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=83,columnType=12,columnName=d_comment_one_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=84,columnType=12,columnName=d_comment_one_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=85,columnType=12,columnName=d_comment_two,columnValue=��ɽ���������԰-����-78��-1604,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=86,columnType=12,columnName=d_comment_two_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=87,columnType=12,columnName=d_comment_two_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=88,columnType=12,columnName=d_fg_unique_no,columnValue=0c43f081-a977-40a6-b52c-723332e10d59,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=89,columnType=12,columnName=d_fg_unique_no_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=90,columnType=12,columnName=d_fg_unique_no_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=91,columnType=12,columnName=d_sign_datetime,columnValue=2016-04-29,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=92,columnType=12,columnName=d_sign_datetime_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=93,columnType=12,columnName=d_sign_datetime_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=94,columnType=12,columnName=d_contract_datetime,columnValue=2017-12-31,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=95,columnType=12,columnName=d_contract_datetime_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=96,columnType=12,columnName=d_contract_datetime_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=97,columnType=12,columnName=d_deliver_datetime,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=98,columnType=12,columnName=d_deliver_datetime_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=99,columnType=12,columnName=d_deliver_datetime_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=100,columnType=12,columnName=d_owner_type_seven_plus,columnValue=׼ҵ��1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=101,columnType=12,columnName=d_owner_type_seven_plus_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=102,columnType=12,columnName=d_owner_type_seven_plus_system_code,columnValue=045001,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=103,columnType=12,columnName=d_exam_stage,columnValue=2016-05,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=104,columnType=12,columnName=d_exam_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=105,columnType=12,columnName=d_exam_stage_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=106,columnType=12,columnName=encrypt,columnValue=2E6F38SDV6JFLOCB98XW,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=107,columnType=5,columnName=A1,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=108,columnType=5,columnName=A3,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=109,columnType=5,columnName=A4,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=110,columnType=5,columnName=A5,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=111,columnType=5,columnName=A6,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=112,columnType=5,columnName=A7,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=113,columnType=5,columnName=A8,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=114,columnType=5,columnName=A9,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=115,columnType=5,columnName=A10,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=116,columnType=5,columnName=A11,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=117,columnType=5,columnName=A12,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=118,columnType=5,columnName=A2,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=119,columnType=5,columnName=A13,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=120,columnType=5,columnName=D1,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=121,columnType=5,columnName=E0,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=122,columnType=5,columnName=E1_1,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=123,columnType=5,columnName=E1_2,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=124,columnType=5,columnName=E1_3,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=125,columnType=5,columnName=E3_1,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=126,columnType=5,columnName=E3_2,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=127,columnType=5,columnName=E3_3,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=128,columnType=5,columnName=E3_4,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=129,columnType=5,columnName=E3_5,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=130,columnType=5,columnName=E3_6,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=131,columnType=5,columnName=E3_7,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=132,columnType=5,columnName=E3_8,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=133,columnType=93,columnName=createtime,columnValue=2016-06-04 19:15:34,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=134,columnType=5,columnName=P1,columnValue=-1,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=135,columnType=-1,columnName=A1a,columnValue=,isNull=true,isKey=false,isUpdate=true]\r\nEventColumn[index=136,columnType=12,columnName=d_house_business,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=137,columnType=12,columnName=d_house_business_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=138,columnType=12,columnName=d_house_business_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=139,columnType=12,columnName=d_house_sensitive,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=140,columnType=12,columnName=d_house_sensitive_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=141,columnType=12,columnName=d_house_sensitive_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=142,columnType=12,columnName=d_house_sensitive_text,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=143,columnType=12,columnName=d_house_sensitive_text_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=144,columnType=12,columnName=d_house_sensitive_text_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=145,columnType=12,columnName=d_comment_three,columnValue=��ɽ���������԰,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=146,columnType=12,columnName=d_comment_three_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=147,columnType=12,columnName=d_comment_three_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=148,columnType=12,columnName=d_comment_four,columnValue=����סլ-�߲�-�߲���ɽ���������԰-����-78��-160478��1604����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=149,columnType=12,columnName=d_comment_four_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=150,columnType=12,columnName=d_comment_four_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=151,columnType=12,columnName=excel_source_date,columnValue=2016-05-30,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=152,columnType=12,columnName=excel_source_file_name,columnValue=3.1 ǩԼҵ��-�±���.xls_tmpl.xlsx,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=153,columnType=4,columnName=excel_source_file_line_no,columnValue=2851,isNull=false,isKey=false,isUpdate=true]\r\n---Sql\r\ninsert into wl.zata_data_55(`org_6_group` , `org_6_group_custom_code` , `org_6_group_system_code` , `org_6_area` , `org_6_area_custom_code` , `org_6_area_system_code` , `org_6_company` , `org_6_company_custom_code` , `org_6_company_system_code` , `org_6_city` , `org_6_city_custom_code` , `org_6_city_system_code` , `org_6_dept` , `org_6_dept_custom_code` , `org_6_dept_system_code` , `org_6_stage` , `org_6_stage_custom_code` , `org_6_stage_system_code` , `org_5_group` , `org_5_group_custom_code` , `org_5_group_system_code` , `org_5_company` , `org_5_company_custom_code` , `org_5_company_system_code` , `org_5_city` , `org_5_city_custom_code` , `org_5_city_system_code` , `org_5_dept` , `org_5_dept_custom_code` , `org_5_dept_system_code` , `org_5_stage` , `org_5_stage_custom_code` , `org_5_stage_system_code` , `data_source` , `paper_no` , `finished` , `d_owner_type_four` , `d_owner_type_four_custom_code` , `d_owner_type_four_system_code` , `d_house_type` , `d_house_type_custom_code` , `d_house_type_system_code` , `d_decoration_type` , `d_decoration_type_custom_code` , `d_decoration_type_system_code` , `d_company_type` , `d_company_type_custom_code` , `d_company_type_system_code` , `d_seal_up` , `d_seal_up_custom_code` , `d_seal_up_system_code` , `d_zone_type` , `d_zone_type_custom_code` , `d_zone_type_system_code` , `d_prd_category` , `d_prd_category_custom_code` , `d_prd_category_system_code` , `d_decoration_category` , `d_decoration_category_custom_code` , `d_decoration_category_system_code` , `d_name` , `d_name_custom_code` , `d_name_system_code` , `d_mobile` , `d_mobile_custom_code` , `d_mobile_system_code` , `d_form_group` , `d_form_group_custom_code` , `d_form_group_system_code` , `d_form_stage` , `d_form_stage_custom_code` , `d_form_stage_system_code` , `d_building` , `d_building_custom_code` , `d_building_system_code` , `d_unit_no` , `d_unit_no_custom_code` , `d_unit_no_system_code` , `d_house_no` , `d_house_no_custom_code` , `d_house_no_system_code` , `d_comment_one` , `d_comment_one_custom_code` , `d_comment_one_system_code` , `d_comment_two` , `d_comment_two_custom_code` , `d_comment_two_system_code` , `d_fg_unique_no` , `d_fg_unique_no_custom_code` , `d_fg_unique_no_system_code` , `d_sign_datetime` , `d_sign_datetime_custom_code` , `d_sign_datetime_system_code` , `d_contract_datetime` , `d_contract_datetime_custom_code` , `d_contract_datetime_system_code` , `d_deliver_datetime` , `d_deliver_datetime_custom_code` , `d_deliver_datetime_system_code` , `d_owner_type_seven_plus` , `d_owner_type_seven_plus_custom_code` , `d_owner_type_seven_plus_system_code` , `d_exam_stage` , `d_exam_stage_custom_code` , `d_exam_stage_system_code` , `encrypt` , `A1` , `A3` , `A4` , `A5` , `A6` , `A7` , `A8` , `A9` , `A10` , `A11` , `A12` , `A2` , `A13` , `D1` , `E0` , `E1_1` , `E1_2` , `E1_3` , `E3_1` , `E3_2` , `E3_3` , `E3_4` , `E3_5` , `E3_6` , `E3_7` , `E3_8` , `createtime` , `P1` , `A1a` , `d_house_business` , `d_house_business_custom_code` , `d_house_business_system_code` , `d_house_sensitive` , `d_house_sensitive_custom_code` , `d_house_sensitive_system_code` , `d_house_sensitive_text` , `d_house_sensitive_text_custom_code` , `d_house_sensitive_text_system_code` , `d_comment_three` , `d_comment_three_custom_code` , `d_comment_three_system_code` , `d_comment_four` , `d_comment_four_custom_code` , `d_comment_four_system_code` , `excel_source_date` , `excel_source_file_name` , `excel_source_file_line_no` , `id`) values (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update `org_6_group`=values(`org_6_group`) , `org_6_group_custom_code`=values(`org_6_group_custom_code`) , `org_6_group_system_code`=values(`org_6_group_system_code`) , `org_6_area`=values(`org_6_area`) , `org_6_area_custom_code`=values(`org_6_area_custom_code`) , `org_6_area_system_code`=values(`org_6_area_system_code`) , `org_6_company`=values(`org_6_company`) , `org_6_company_custom_code`=values(`org_6_company_custom_code`) , `org_6_company_system_code`=values(`org_6_company_system_code`) , `org_6_city`=values(`org_6_city`) , `org_6_city_custom_code`=values(`org_6_city_custom_code`) , `org_6_city_system_code`=values(`org_6_city_system_code`) , `org_6_dept`=values(`org_6_dept`) , `org_6_dept_custom_code`=values(`org_6_dept_custom_code`) , `org_6_dept_system_code`=values(`org_6_dept_system_code`) , `org_6_stage`=values(`org_6_stage`) , `org_6_stage_custom_code`=values(`org_6_stage_custom_code`) , `org_6_stage_system_code`=values(`org_6_stage_system_code`) , `org_5_group`=values(`org_5_group`) , `org_5_group_custom_code`=values(`org_5_group_custom_code`) , `org_5_group_system_code`=values(`org_5_group_system_code`) , `org_5_company`=values(`org_5_company`) , `org_5_company_custom_code`=values(`org_5_company_custom_code`) , `org_5_company_system_code`=values(`org_5_company_system_code`) , `org_5_city`=values(`org_5_city`) , `org_5_city_custom_code`=values(`org_5_city_custom_code`) , `org_5_city_system_code`=values(`org_5_city_system_code`) , `org_5_dept`=values(`org_5_dept`) , `org_5_dept_custom_code`=values(`org_5_dept_custom_code`) , `org_5_dept_system_code`=values(`org_5_dept_system_code`) , `org_5_stage`=values(`org_5_stage`) , `org_5_stage_custom_code`=values(`org_5_stage_custom_code`) , `org_5_stage_system_code`=values(`org_5_stage_system_code`) , `data_source`=values(`data_source`) , `paper_no`=values(`paper_no`) , `finished`=values(`finished`) , `d_owner_type_four`=values(`d_owner_type_four`) , `d_owner_type_four_custom_code`=values(`d_owner_type_four_custom_code`) , `d_owner_type_four_system_code`=values(`d_owner_type_four_system_code`) , `d_house_type`=values(`d_house_type`) , `d_house_type_custom_code`=values(`d_house_type_custom_code`) , `d_house_type_system_code`=values(`d_house_type_system_code`) , `d_decoration_type`=values(`d_decoration_type`) , `d_decoration_type_custom_code`=values(`d_decoration_type_custom_code`) , `d_decoration_type_system_code`=values(`d_decoration_type_system_code`) , `d_company_type`=values(`d_company_type`) , `d_company_type_custom_code`=values(`d_company_type_custom_code`) , `d_company_type_system_code`=values(`d_company_type_system_code`) , `d_seal_up`=values(`d_seal_up`) , `d_seal_up_custom_code`=values(`d_seal_up_custom_code`) , `d_seal_up_system_code`=values(`d_seal_up_system_code`) , `d_zone_type`=values(`d_zone_type`) , `d_zone_type_custom_code`=values(`d_zone_type_custom_code`) , `d_zone_type_system_code`=values(`d_zone_type_system_code`) , `d_prd_category`=values(`d_prd_category`) , `d_prd_category_custom_code`=values(`d_prd_category_custom_code`) , `d_prd_category_system_code`=values(`d_prd_category_system_code`) , `d_decoration_category`=values(`d_decoration_category`) , `d_decoration_category_custom_code`=values(`d_decoration_category_custom_code`) , `d_decoration_category_system_code`=values(`d_decoration_category_system_code`) , `d_name`=values(`d_name`) , `d_name_custom_code`=values(`d_name_custom_code`) , `d_name_system_code`=values(`d_name_system_code`) , `d_mobile`=values(`d_mobile`) , `d_mobile_custom_code`=values(`d_mobile_custom_code`) , `d_mobile_system_code`=values(`d_mobile_system_code`) , `d_form_group`=values(`d_form_group`) , `d_form_group_custom_code`=values(`d_form_group_custom_code`) , `d_form_group_system_code`=values(`d_form_group_system_code`) , `d_form_stage`=values(`d_form_stage`) , `d_form_stage_custom_code`=values(`d_form_stage_custom_code`) , `d_form_stage_system_code`=values(`d_form_stage_system_code`) , `d_building`=values(`d_building`) , `d_building_custom_code`=values(`d_building_custom_code`) , `d_building_system_code`=values(`d_building_system_code`) , `d_unit_no`=values(`d_unit_no`) , `d_unit_no_custom_code`=values(`d_unit_no_custom_code`) , `d_unit_no_system_code`=values(`d_unit_no_system_code`) , `d_house_no`=values(`d_house_no`) , `d_house_no_custom_code`=values(`d_house_no_custom_code`) , `d_house_no_system_code`=values(`d_house_no_system_code`) , `d_comment_one`=values(`d_comment_one`) , `d_comment_one_custom_code`=values(`d_comment_one_custom_code`) , `d_comment_one_system_code`=values(`d_comment_one_system_code`) , `d_comment_two`=values(`d_comment_two`) , `d_comment_two_custom_code`=values(`d_comment_two_custom_code`) , `d_comment_two_system_code`=values(`d_comment_two_system_code`) , `d_fg_unique_no`=values(`d_fg_unique_no`) , `d_fg_unique_no_custom_code`=values(`d_fg_unique_no_custom_code`) , `d_fg_unique_no_system_code`=values(`d_fg_unique_no_system_code`) , `d_sign_datetime`=values(`d_sign_datetime`) , `d_sign_datetime_custom_code`=values(`d_sign_datetime_custom_code`) , `d_sign_datetime_system_code`=values(`d_sign_datetime_system_code`) , `d_contract_datetime`=values(`d_contract_datetime`) , `d_contract_datetime_custom_code`=values(`d_contract_datetime_custom_code`) , `d_contract_datetime_system_code`=values(`d_contract_datetime_system_code`) , `d_deliver_datetime`=values(`d_deliver_datetime`) , `d_deliver_datetime_custom_code`=values(`d_deliver_datetime_custom_code`) , `d_deliver_datetime_system_code`=values(`d_deliver_datetime_system_code`) , `d_owner_type_seven_plus`=values(`d_owner_type_seven_plus`) , `d_owner_type_seven_plus_custom_code`=values(`d_owner_type_seven_plus_custom_code`) , `d_owner_type_seven_plus_system_code`=values(`d_owner_type_seven_plus_system_code`) , `d_exam_stage`=values(`d_exam_stage`) , `d_exam_stage_custom_code`=values(`d_exam_stage_custom_code`) , `d_exam_stage_system_code`=values(`d_exam_stage_system_code`) , `encrypt`=values(`encrypt`) , `A1`=values(`A1`) , `A3`=values(`A3`) , `A4`=values(`A4`) , `A5`=values(`A5`) , `A6`=values(`A6`) , `A7`=values(`A7`) , `A8`=values(`A8`) , `A9`=values(`A9`) , `A10`=values(`A10`) , `A11`=values(`A11`) , `A12`=values(`A12`) , `A2`=values(`A2`) , `A13`=values(`A13`) , `D1`=values(`D1`) , `E0`=values(`E0`) , `E1_1`=values(`E1_1`) , `E1_2`=values(`E1_2`) , `E1_3`=values(`E1_3`) , `E3_1`=values(`E3_1`) , `E3_2`=values(`E3_2`) , `E3_3`=values(`E3_3`) , `E3_4`=values(`E3_4`) , `E3_5`=values(`E3_5`) , `E3_6`=values(`E3_6`) , `E3_7`=values(`E3_7`) , `E3_8`=values(`E3_8`) , `createtime`=values(`createtime`) , `P1`=values(`P1`) , `A1a`=values(`A1a`) , `d_house_business`=values(`d_house_business`) , `d_house_business_custom_code`=values(`d_house_business_custom_code`) , `d_house_business_system_code`=values(`d_house_business_system_code`) , `d_house_sensitive`=values(`d_house_sensitive`) , `d_house_sensitive_custom_code`=values(`d_house_sensitive_custom_code`) , `d_house_sensitive_system_code`=values(`d_house_sensitive_system_code`) , `d_house_sensitive_text`=values(`d_house_sensitive_text`) , `d_house_sensitive_text_custom_code`=values(`d_house_sensitive_text_custom_code`) , `d_house_sensitive_text_system_code`=values(`d_house_sensitive_text_system_code`) , `d_comment_three`=values(`d_comment_three`) , `d_comment_three_custom_code`=values(`d_comment_three_custom_code`) , `d_comment_three_system_code`=values(`d_comment_three_system_code`) , `d_comment_four`=values(`d_comment_four`) , `d_comment_four_custom_code`=values(`d_comment_four_custom_code`) , `d_comment_four_system_code`=values(`d_comment_four_system_code`) , `excel_source_date`=values(`excel_source_date`) , `excel_source_file_name`=values(`excel_source_file_name`) , `excel_source_file_line_no`=values(`excel_source_file_line_no`) , `id`=values(`id`)\r\n\r\nCaused by: java.util.concurrent.ExecutionException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: com.alibaba.otter.node.etl.load.exception.LoadException: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [insert into wl.zata_data_55(`org_6_group` , `org_6_group_custom_code` , `org_6_group_system_code` , `org_6_area` , `org_6_area_custom_code` , `org_6_area_system_code` , `org_6_company` , `org_6_company_custom_code` , `org_6_company_system_code` , `org_6_city` , `org_6_city_custom_code` , `org_6_city_system_code` , `org_6_dept` , `org_6_dept_custom_code` , `org_6_dept_system_code` , `org_6_stage` , `org_6_stage_custom_code` , `org_6_stage_system_code` , `org_5_group` , `org_5_group_custom_code` , `org_5_group_system_code` , `org_5_company` , `org_5_company_custom_code` , `org_5_company_system_code` , `org_5_city` , `org_5_city_custom_code` , `org_5_city_system_code` , `org_5_dept` , `org_5_dept_custom_code` , `org_5_dept_system_code` , `org_5_stage` , `org_5_stage_custom_code` , `org_5_stage_system_code` , `data_source` , `paper_no` , `finished` , `d_owner_type_four` , `d_owner_type_four_custom_code` , `d_owner_type_four_system_code` , `d_house_type` , `d_house_type_custom_code` , `d_house_type_system_code` , `d_decoration_type` , `d_decoration_type_custom_code` , `d_decoration_type_system_code` , `d_company_type` , `d_company_type_custom_code` , `d_company_type_system_code` , `d_seal_up` , `d_seal_up_custom_code` , `d_seal_up_system_code` , `d_zone_type` , `d_zone_type_custom_code` , `d_zone_type_system_code` , `d_prd_category` , `d_prd_category_custom_code` , `d_prd_category_system_code` , `d_decoration_category` , `d_decoration_category_custom_code` , `d_decoration_category_system_code` , `d_name` , `d_name_custom_code` , `d_name_system_code` , `d_mobile` , `d_mobile_custom_code` , `d_mobile_system_code` , `d_form_group` , `d_form_group_custom_code` , `d_form_group_system_code` , `d_form_stage` , `d_form_stage_custom_code` , `d_form_stage_system_code` , `d_building` , `d_building_custom_code` , `d_building_system_code` , `d_unit_no` , `d_unit_no_custom_code` , `d_unit_no_system_code` , `d_house_no` , `d_house_no_custom_code` , `d_house_no_system_code` , `d_comment_one` , `d_comment_one_custom_code` , `d_comment_one_system_code` , `d_comment_two` , `d_comment_two_custom_code` , `d_comment_two_system_code` , `d_fg_unique_no` , `d_fg_unique_no_custom_code` , `d_fg_unique_no_system_code` , `d_sign_datetime` , `d_sign_datetime_custom_code` , `d_sign_datetime_system_code` , `d_contract_datetime` , `d_contract_datetime_custom_code` , `d_contract_datetime_system_code` , `d_deliver_datetime` , `d_deliver_datetime_custom_code` , `d_deliver_datetime_system_code` , `d_owner_type_seven_plus` , `d_owner_type_seven_plus_custom_code` , `d_owner_type_seven_plus_system_code` , `d_exam_stage` , `d_exam_stage_custom_code` , `d_exam_stage_system_code` , `encrypt` , `A1` , `A3` , `A4` , `A5` , `A6` , `A7` , `A8` , `A9` , `A10` , `A11` , `A12` , `A2` , `A13` , `D1` , `E0` , `E1_1` , `E1_2` , `E1_3` , `E3_1` , `E3_2` , `E3_3` , `E3_4` , `E3_5` , `E3_6` , `E3_7` , `E3_8` , `createtime` , `P1` , `A1a` , `d_house_business` , `d_house_business_custom_code` , `d_house_business_system_code` , `d_house_sensitive` , `d_house_sensitive_custom_code` , `d_house_sensitive_system_code` , `d_house_sensitive_text` , `d_house_sensitive_text_custom_code` , `d_house_sensitive_text_system_code` , `d_comment_three` , `d_comment_three_custom_code` , `d_comment_three_system_code` , `d_comment_four` , `d_comment_four_custom_code` , `d_comment_four_system_code` , `excel_source_date` , `excel_source_file_name` , `excel_source_file_line_no` , `id`) values (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update `org_6_group`=values(`org_6_group`) , `org_6_group_custom_code`=values(`org_6_group_custom_code`) , `org_6_group_system_code`=values(`org_6_group_system_code`) , `org_6_area`=values(`org_6_area`) , `org_6_area_custom_code`=values(`org_6_area_custom_code`) , `org_6_area_system_code`=values(`org_6_area_system_code`) , `org_6_company`=values(`org_6_company`) , `org_6_company_custom_code`=values(`org_6_company_custom_code`) , `org_6_company_system_code`=values(`org_6_company_system_code`) , `org_6_city`=values(`org_6_city`) , `org_6_city_custom_code`=values(`org_6_city_custom_code`) , `org_6_city_system_code`=values(`org_6_city_system_code`) , `org_6_dept`=values(`org_6_dept`) , `org_6_dept_custom_code`=values(`org_6_dept_custom_code`) , `org_6_dept_system_code`=values(`org_6_dept_system_code`) , `org_6_stage`=values(`org_6_stage`) , `org_6_stage_custom_code`=values(`org_6_stage_custom_code`) , `org_6_stage_system_code`=values(`org_6_stage_system_code`) , `org_5_group`=values(`org_5_group`) , `org_5_group_custom_code`=values(`org_5_group_custom_code`) , `org_5_group_system_code`=values(`org_5_group_system_code`) , `org_5_company`=values(`org_5_company`) , `org_5_company_custom_code`=values(`org_5_company_custom_code`) , `org_5_company_system_code`=values(`org_5_company_system_code`) , `org_5_city`=values(`org_5_city`) , `org_5_city_custom_code`=values(`org_5_city_custom_code`) , `org_5_city_system_code`=values(`org_5_city_system_code`) , `org_5_dept`=values(`org_5_dept`) , `org_5_dept_custom_code`=values(`org_5_dept_custom_code`) , `org_5_dept_system_code`=values(`org_5_dept_system_code`) , `org_5_stage`=values(`org_5_stage`) , `org_5_stage_custom_code`=values(`org_5_stage_custom_code`) , `org_5_stage_system_code`=values(`org_5_stage_system_code`) , `data_source`=values(`data_source`) , `paper_no`=values(`paper_no`) , `finished`=values(`finished`) , `d_owner_type_four`=values(`d_owner_type_four`) , `d_owner_type_four_custom_code`=values(`d_owner_type_four_custom_code`) , `d_owner_type_four_system_code`=values(`d_owner_type_four_system_code`) , `d_house_type`=values(`d_house_type`) , `d_house_type_custom_code`=values(`d_house_type_custom_code`) , `d_house_type_system_code`=values(`d_house_type_system_code`) , `d_decoration_type`=values(`d_decoration_type`) , `d_decoration_type_custom_code`=values(`d_decoration_type_custom_code`) , `d_decoration_type_system_code`=values(`d_decoration_type_system_code`) , `d_company_type`=values(`d_company_type`) , `d_company_type_custom_code`=values(`d_company_type_custom_code`) , `d_company_type_system_code`=values(`d_company_type_system_code`) , `d_seal_up`=values(`d_seal_up`) , `d_seal_up_custom_code`=values(`d_seal_up_custom_code`) , `d_seal_up_system_code`=values(`d_seal_up_system_code`) , `d_zone_type`=values(`d_zone_type`) , `d_zone_type_custom_code`=values(`d_zone_type_custom_code`) , `d_zone_type_system_code`=values(`d_zone_type_system_code`) , `d_prd_category`=values(`d_prd_category`) , `d_prd_category_custom_code`=values(`d_prd_category_custom_code`) , `d_prd_category_system_code`=values(`d_prd_category_system_code`) , `d_decoration_category`=values(`d_decoration_category`) , `d_decoration_category_custom_code`=values(`d_decoration_category_custom_code`) , `d_decoration_category_system_code`=values(`d_decoration_category_system_code`) , `d_name`=values(`d_name`) , `d_name_custom_code`=values(`d_name_custom_code`) , `d_name_system_code`=values(`d_name_system_code`) , `d_mobile`=values(`d_mobile`) , `d_mobile_custom_code`=values(`d_mobile_custom_code`) , `d_mobile_system_code`=values(`d_mobile_system_code`) , `d_form_group`=values(`d_form_group`) , `d_form_group_custom_code`=values(`d_form_group_custom_code`) , `d_form_group_system_code`=values(`d_form_group_system_code`) , `d_form_stage`=values(`d_form_stage`) , `d_form_stage_custom_code`=values(`d_form_stage_custom_code`) , `d_form_stage_system_code`=values(`d_form_stage_system_code`) , `d_building`=values(`d_building`) , `d_building_custom_code`=values(`d_building_custom_code`) , `d_building_system_code`=values(`d_building_system_code`) , `d_unit_no`=values(`d_unit_no`) , `d_unit_no_custom_code`=values(`d_unit_no_custom_code`) , `d_unit_no_system_code`=values(`d_unit_no_system_code`) , `d_house_no`=values(`d_house_no`) , `d_house_no_custom_code`=values(`d_house_no_custom_code`) , `d_house_no_system_code`=values(`d_house_no_system_code`) , `d_comment_one`=values(`d_comment_one`) , `d_comment_one_custom_code`=values(`d_comment_one_custom_code`) , `d_comment_one_system_code`=values(`d_comment_one_system_code`) , `d_comment_two`=values(`d_comment_two`) , `d_comment_two_custom_code`=values(`d_comment_two_custom_code`) , `d_comment_two_system_code`=values(`d_comment_two_system_code`) , `d_fg_unique_no`=values(`d_fg_unique_no`) , `d_fg_unique_no_custom_code`=values(`d_fg_unique_no_custom_code`) , `d_fg_unique_no_system_code`=values(`d_fg_unique_no_system_code`) , `d_sign_datetime`=values(`d_sign_datetime`) , `d_sign_datetime_custom_code`=values(`d_sign_datetime_custom_code`) , `d_sign_datetime_system_code`=values(`d_sign_datetime_system_code`) , `d_contract_datetime`=values(`d_contract_datetime`) , `d_contract_datetime_custom_code`=values(`d_contract_datetime_custom_code`) , `d_contract_datetime_system_code`=values(`d_contract_datetime_system_code`) , `d_deliver_datetime`=values(`d_deliver_datetime`) , `d_deliver_datetime_custom_code`=values(`d_deliver_datetime_custom_code`) , `d_deliver_datetime_system_code`=values(`d_deliver_datetime_system_code`) , `d_owner_type_seven_plus`=values(`d_owner_type_seven_plus`) , `d_owner_type_seven_plus_custom_code`=values(`d_owner_type_seven_plus_custom_code`) , `d_owner_type_seven_plus_system_code`=values(`d_owner_type_seven_plus_system_code`) , `d_exam_stage`=values(`d_exam_stage`) , `d_exam_stage_custom_code`=values(`d_exam_stage_custom_code`) , `d_exam_stage_system_code`=values(`d_exam_stage_system_code`) , `encrypt`=values(`encrypt`) , `A1`=values(`A1`) , `A3`=values(`A3`) , `A4`=values(`A4`) , `A5`=values(`A5`) , `A6`=values(`A6`) , `A7`=values(`A7`) , `A8`=values(`A8`) , `A9`=values(`A9`) , `A10`=values(`A10`) , `A11`=values(`A11`) , `A12`=values(`A12`) , `A2`=values(`A2`) , `A13`=values(`A13`) , `D1`=values(`D1`) , `E0`=values(`E0`) , `E1_1`=values(`E1_1`) , `E1_2`=values(`E1_2`) , `E1_3`=values(`E1_3`) , `E3_1`=values(`E3_1`) , `E3_2`=values(`E3_2`) , `E3_3`=values(`E3_3`) , `E3_4`=values(`E3_4`) , `E3_5`=values(`E3_5`) , `E3_6`=values(`E3_6`) , `E3_7`=values(`E3_7`) , `E3_8`=values(`E3_8`) , `createtime`=values(`createtime`) , `P1`=values(`P1`) , `A1a`=values(`A1a`) , `d_house_business`=values(`d_house_business`) , `d_house_business_custom_code`=values(`d_house_business_custom_code`) , `d_house_business_system_code`=values(`d_house_business_system_code`) , `d_house_sensitive`=values(`d_house_sensitive`) , `d_house_sensitive_custom_code`=values(`d_house_sensitive_custom_code`) , `d_house_sensitive_system_code`=values(`d_house_sensitive_system_code`) , `d_house_sensitive_text`=values(`d_house_sensitive_text`) , `d_house_sensitive_text_custom_code`=values(`d_house_sensitive_text_custom_code`) , `d_house_sensitive_text_system_code`=values(`d_house_sensitive_text_system_code`) , `d_comment_three`=values(`d_comment_three`) , `d_comment_three_custom_code`=values(`d_comment_three_custom_code`) , `d_comment_three_system_code`=values(`d_comment_three_system_code`) , `d_comment_four`=values(`d_comment_four`) , `d_comment_four_custom_code`=values(`d_comment_four_custom_code`) , `d_comment_four_system_code`=values(`d_comment_four_system_code`) , `excel_source_date`=values(`excel_source_date`) , `excel_source_file_name`=values(`excel_source_file_name`) , `excel_source_file_line_no`=values(`excel_source_file_line_no`) , `id`=values(`id`)]; SQL state [HY000]; error code [1366]; Incorrect string value: '\\xEF\\xBF\\xBD\\xEF\\xBF\\xBD...' for column 'org_6_group' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\\xEF\\xBF\\xBD\\xEF\\xBF\\xBD...' for column 'org_6_group' at row 1\r\nat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)\r\nat org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)\r\nat org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)\r\nat org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)\r\nat org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker$2.doInTransaction(DbLoadAction.java:621)\r\nat org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.doCall(DbLoadAction.java:613)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.call(DbLoadAction.java:541)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doTwoPhase(DbLoadAction.java:458)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doLoad(DbLoadAction.java:275)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.load(DbLoadAction.java:161)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$FastClassByCGLIB$$d932a4cb.invoke()\r\nat net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)\r\nat org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618)\r\nat com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$EnhancerByCGLIB$$80fd23c2.load()\r\nat com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:198)\r\nat com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:189)\r\nat java.util.concurrent.FutureTask.run(FutureTask.java:266)\r\nat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\r\nat java.util.concurrent.FutureTask.run(FutureTask.java:266)\r\nat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\nat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)\r\nat java.lang.Thread.run(Thread.java:745)\r\nCaused by: java.sql.SQLException: Incorrect string value: '\\xEF\\xBF\\xBD\\xEF\\xBF\\xBD...' for column 'org_6_group' at row 1\r\nat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)\r\nat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835)\r\nat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771)\r\nat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)\r\nat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)\r\nat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535)\r\nat com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911)\r\nat com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145)\r\nat com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2081)\r\nat com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2066)\r\nat org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\nat org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)\r\nat org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818)\r\nat org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1)\r\nat org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587)\r\n... 21 more\r\n:-----------------\r\n- PairId: 1 , TableId: 2 , EventType : I , Time : 1467614672000 \r\n- Consistency : , Mode : \r\n-----------------\r\n---Pks\r\nEventColumn[index=0,columnType=-5,columnName=id,columnValue=224934,isNull=false,isKey=true,isUpdate=true]\r\n---oldPks\r\n---Columns\r\nEventColumn[index=1,columnType=12,columnName=org_6_group,columnValue=����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=2,columnType=12,columnName=org_6_group_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=3,columnType=12,columnName=org_6_group_system_code,columnValue=011,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=4,columnType=12,columnName=org_6_area,columnValue=�Ϻ�����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=5,columnType=12,columnName=org_6_area_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=6,columnType=12,columnName=org_6_area_system_code,columnValue=011003,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=7,columnType=12,columnName=org_6_company,columnValue=���Ϲ�˾,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=8,columnType=12,columnName=org_6_company_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=9,columnType=12,columnName=org_6_company_system_code,columnValue=011003008,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=10,columnType=12,columnName=org_6_city,columnValue=����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=11,columnType=12,columnName=org_6_city_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=12,columnType=12,columnName=org_6_city_system_code,columnValue=011003008002,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=13,columnType=12,columnName=org_6_dept,columnValue=������ɽMIXTOWN,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=14,columnType=12,columnName=org_6_dept_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=15,columnType=12,columnName=org_6_dept_system_code,columnValue=011003008002005,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=16,columnType=12,columnName=org_6_stage,columnValue=������ɽMIXTOWN����,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=17,columnType=12,columnName=org_6_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=18,columnType=12,columnName=org_6_stage_system_code,columnValue=011003008002005003,isNull=false,isKey=false,isUpdate=true]\r\nEventColumn[index=19,columnType=12,columnName=org_5_group,columnValue=,isNull=false,isKey=false,isUpdate=true]\r\nEventCol"},"comment":{"url":"https://api.github.com/repos/alibaba/otter/issues/comments/230415061","html_url":"https://github.com/alibaba/otter/issues/165#issuecomment-230415061","issue_url":"https://api.github.com/repos/alibaba/otter/issues/165","id":230415061,"user":{"login":"fg-meizhi","id":11486319,"avatar_url":"https://avatars.githubusercontent.com/u/11486319?v=3","gravatar_id":"","url":"https://api.github.com/users/fg-meizhi","html_url":"https://github.com/fg-meizhi","followers_url":"https://api.github.com/users/fg-meizhi/followers","following_url":"https://api.github.com/users/fg-meizhi/following{/other_user}","gists_url":"https://api.github.com/users/fg-meizhi/gists{/gist_id}","starred_url":"https://api.github.com/users/fg-meizhi/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fg-meizhi/subscriptions","organizations_url":"https://api.github.com/users/fg-meizhi/orgs","repos_url":"https://api.github.com/users/fg-meizhi/repos","events_url":"https://api.github.com/users/fg-meizhi/events{/privacy}","received_events_url":"https://api.github.com/users/fg-meizhi/received_events","type":"User","site_admin":false},"created_at":"2016-07-05T08:17:56Z","updated_at":"2016-07-05T08:17:56Z","body":"canal 和数据映射均已是 UTF-8，依然报错，问题没解决，先别关 issue 啊\r\n![Uploading image.png…]()\r\n![Uploading image.png…]()\r\n"}}
{"actor":{"display_login":"fg-meizhi"}}