insert 中文异常

同步时插入中文发生异常

数据库，表，编码均为 utf8，请问是什么原因导致？ 另外 ，如何判断是在哪个步骤出现的问题？canal 读取binlog？还是在 node 插入时发生的异常？

nid:2 为 slave node

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 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker$2.doInTransaction(DbLoadAction.java:621) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.doCall(DbLoadAction.java:613) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.call(DbLoadAction.java:541) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doTwoPhase(DbLoadAction.java:458) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doLoad(DbLoadAction.java:275) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.load(DbLoadAction.java:161) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$FastClassByCGLIB$$d932a4cb.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$EnhancerByCGLIB$$80fd23c2.load() at com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:198) at com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:189) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBD\xEF\xBF\xBD...' for column 'org_6_group' at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2081) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2066) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587) ... 21 more • PairId: 1 , TableId: 2 , EventType : I , Time : 1467614672000 - Consistency : , Mode : ---Pks EventColumn[index=0,columnType=-5,columnName=id,columnValue=224934,isNull=false,isKey=true,isUpdate=true] ---oldPks ---Columns EventColumn[index=1,columnType=12,columnName=org_6_group,columnValue=����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=2,columnType=12,columnName=org_6_group_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=3,columnType=12,columnName=org_6_group_system_code,columnValue=011,isNull=false,isKey=false,isUpdate=true] EventColumn[index=4,columnType=12,columnName=org_6_area,columnValue=�Ϻ�����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=5,columnType=12,columnName=org_6_area_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=6,columnType=12,columnName=org_6_area_system_code,columnValue=011003,isNull=false,isKey=false,isUpdate=true] EventColumn[index=7,columnType=12,columnName=org_6_company,columnValue=���Ϲ�˾,isNull=false,isKey=false,isUpdate=true] EventColumn[index=8,columnType=12,columnName=org_6_company_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=9,columnType=12,columnName=org_6_company_system_code,columnValue=011003008,isNull=false,isKey=false,isUpdate=true] EventColumn[index=10,columnType=12,columnName=org_6_city,columnValue=����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=11,columnType=12,columnName=org_6_city_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=12,columnType=12,columnName=org_6_city_system_code,columnValue=011003008002,isNull=false,isKey=false,isUpdate=true] EventColumn[index=13,columnType=12,columnName=org_6_dept,columnValue=������ɽMIXTOWN,isNull=false,isKey=false,isUpdate=true] EventColumn[index=14,columnType=12,columnName=org_6_dept_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=15,columnType=12,columnName=org_6_dept_system_code,columnValue=011003008002005,isNull=false,isKey=false,isUpdate=true] EventColumn[index=16,columnType=12,columnName=org_6_stage,columnValue=������ɽMIXTOWN����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=17,columnType=12,columnName=org_6_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=18,columnType=12,columnName=org_6_stage_system_code,columnValue=011003008002005003,isNull=false,isKey=false,isUpdate=true] EventColumn[index=19,columnType=12,columnName=org_5_group,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=20,columnType=12,columnName=org_5_group_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=21,columnType=12,columnName=org_5_group_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=22,columnType=12,columnName=org_5_company,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=23,columnType=12,columnName=org_5_company_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=24,columnType=12,columnName=org_5_company_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=25,columnType=12,columnName=org_5_city,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=26,columnType=12,columnName=org_5_city_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=27,columnType=12,columnName=org_5_city_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=28,columnType=12,columnName=org_5_dept,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=29,columnType=12,columnName=org_5_dept_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=30,columnType=12,columnName=org_5_dept_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=31,columnType=12,columnName=org_5_stage,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=32,columnType=12,columnName=org_5_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=33,columnType=12,columnName=org_5_stage_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=34,columnType=5,columnName=data_source,columnValue=1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=35,columnType=12,columnName=paper_no,columnValue=,isNull=true,isKey=false,isUpdate=true] EventColumn[index=36,columnType=5,columnName=finished,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=37,columnType=12,columnName=d_owner_type_four,columnValue=׼ҵ��,isNull=false,isKey=false,isUpdate=true] EventColumn[index=38,columnType=12,columnName=d_owner_type_four_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=39,columnType=12,columnName=d_owner_type_four_system_code,columnValue=001001,isNull=false,isKey=false,isUpdate=true] EventColumn[index=40,columnType=12,columnName=d_house_type,columnValue=�߲�,isNull=false,isKey=false,isUpdate=true] EventColumn[index=41,columnType=12,columnName=d_house_type_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=42,columnType=12,columnName=d_house_type_system_code,columnValue=003001,isNull=false,isKey=false,isUpdate=true] EventColumn[index=43,columnType=12,columnName=d_decoration_type,columnValue=װ�޷�,isNull=false,isKey=false,isUpdate=true] EventColumn[index=44,columnType=12,columnName=d_decoration_type_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=45,columnType=12,columnName=d_decoration_type_system_code,columnValue=004002,isNull=false,isKey=false,isUpdate=true] EventColumn[index=46,columnType=12,columnName=d_company_type,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=47,columnType=12,columnName=d_company_type_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=48,columnType=12,columnName=d_company_type_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=49,columnType=12,columnName=d_seal_up,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=50,columnType=12,columnName=d_seal_up_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=51,columnType=12,columnName=d_seal_up_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=52,columnType=12,columnName=d_zone_type,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=53,columnType=12,columnName=d_zone_type_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=54,columnType=12,columnName=d_zone_type_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=55,columnType=12,columnName=d_prd_category,columnValue=װ�޷�,isNull=false,isKey=false,isUpdate=true] EventColumn[index=56,columnType=12,columnName=d_prd_category_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=57,columnType=12,columnName=d_prd_category_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=58,columnType=12,columnName=d_decoration_category,columnValue=C,isNull=false,isKey=false,isUpdate=true] EventColumn[index=59,columnType=12,columnName=d_decoration_category_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=60,columnType=12,columnName=d_decoration_category_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=61,columnType=12,columnName=d_name,columnValue=���Ļ�,isNull=false,isKey=false,isUpdate=true] EventColumn[index=62,columnType=12,columnName=d_name_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=63,columnType=12,columnName=d_name_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=64,columnType=12,columnName=d_mobile,columnValue=15026590220,isNull=false,isKey=false,isUpdate=true] EventColumn[index=65,columnType=12,columnName=d_mobile_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=66,columnType=12,columnName=d_mobile_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=67,columnType=12,columnName=d_form_group,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=68,columnType=12,columnName=d_form_group_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=69,columnType=12,columnName=d_form_group_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=70,columnType=12,columnName=d_form_stage,columnValue=����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=71,columnType=12,columnName=d_form_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=72,columnType=12,columnName=d_form_stage_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=73,columnType=12,columnName=d_building,columnValue=78��,isNull=false,isKey=false,isUpdate=true] EventColumn[index=74,columnType=12,columnName=d_building_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=75,columnType=12,columnName=d_building_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=76,columnType=12,columnName=d_unit_no,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=77,columnType=12,columnName=d_unit_no_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=78,columnType=12,columnName=d_unit_no_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=79,columnType=12,columnName=d_house_no,columnValue=1604,isNull=false,isKey=false,isUpdate=true] EventColumn[index=80,columnType=12,columnName=d_house_no_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=81,columnType=12,columnName=d_house_no_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=82,columnType=12,columnName=d_comment_one,columnValue=��,isNull=false,isKey=false,isUpdate=true] EventColumn[index=83,columnType=12,columnName=d_comment_one_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=84,columnType=12,columnName=d_comment_one_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=85,columnType=12,columnName=d_comment_two,columnValue=��ɽ���������԰-����-78��-1604,isNull=false,isKey=false,isUpdate=true] EventColumn[index=86,columnType=12,columnName=d_comment_two_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=87,columnType=12,columnName=d_comment_two_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=88,columnType=12,columnName=d_fg_unique_no,columnValue=0c43f081-a977-40a6-b52c-723332e10d59,isNull=false,isKey=false,isUpdate=true] EventColumn[index=89,columnType=12,columnName=d_fg_unique_no_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=90,columnType=12,columnName=d_fg_unique_no_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=91,columnType=12,columnName=d_sign_datetime,columnValue=2016-04-29,isNull=false,isKey=false,isUpdate=true] EventColumn[index=92,columnType=12,columnName=d_sign_datetime_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=93,columnType=12,columnName=d_sign_datetime_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=94,columnType=12,columnName=d_contract_datetime,columnValue=2017-12-31,isNull=false,isKey=false,isUpdate=true] EventColumn[index=95,columnType=12,columnName=d_contract_datetime_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=96,columnType=12,columnName=d_contract_datetime_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=97,columnType=12,columnName=d_deliver_datetime,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=98,columnType=12,columnName=d_deliver_datetime_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=99,columnType=12,columnName=d_deliver_datetime_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=100,columnType=12,columnName=d_owner_type_seven_plus,columnValue=׼ҵ��1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=101,columnType=12,columnName=d_owner_type_seven_plus_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=102,columnType=12,columnName=d_owner_type_seven_plus_system_code,columnValue=045001,isNull=false,isKey=false,isUpdate=true] EventColumn[index=103,columnType=12,columnName=d_exam_stage,columnValue=2016-05,isNull=false,isKey=false,isUpdate=true] EventColumn[index=104,columnType=12,columnName=d_exam_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=105,columnType=12,columnName=d_exam_stage_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=106,columnType=12,columnName=encrypt,columnValue=2E6F38SDV6JFLOCB98XW,isNull=false,isKey=false,isUpdate=true] EventColumn[index=107,columnType=5,columnName=A1,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=108,columnType=5,columnName=A3,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=109,columnType=5,columnName=A4,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=110,columnType=5,columnName=A5,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=111,columnType=5,columnName=A6,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=112,columnType=5,columnName=A7,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=113,columnType=5,columnName=A8,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=114,columnType=5,columnName=A9,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=115,columnType=5,columnName=A10,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=116,columnType=5,columnName=A11,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=117,columnType=5,columnName=A12,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=118,columnType=5,columnName=A2,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=119,columnType=5,columnName=A13,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=120,columnType=5,columnName=D1,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=121,columnType=5,columnName=E0,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=122,columnType=5,columnName=E1_1,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=123,columnType=5,columnName=E1_2,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=124,columnType=5,columnName=E1_3,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=125,columnType=5,columnName=E3_1,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=126,columnType=5,columnName=E3_2,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=127,columnType=5,columnName=E3_3,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=128,columnType=5,columnName=E3_4,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=129,columnType=5,columnName=E3_5,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=130,columnType=5,columnName=E3_6,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=131,columnType=5,columnName=E3_7,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=132,columnType=5,columnName=E3_8,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=133,columnType=93,columnName=createtime,columnValue=2016-06-04 19:15:34,isNull=false,isKey=false,isUpdate=true] EventColumn[index=134,columnType=5,columnName=P1,columnValue=-1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=135,columnType=-1,columnName=A1a,columnValue=,isNull=true,isKey=false,isUpdate=true] EventColumn[index=136,columnType=12,columnName=d_house_business,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=137,columnType=12,columnName=d_house_business_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=138,columnType=12,columnName=d_house_business_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=139,columnType=12,columnName=d_house_sensitive,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=140,columnType=12,columnName=d_house_sensitive_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=141,columnType=12,columnName=d_house_sensitive_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=142,columnType=12,columnName=d_house_sensitive_text,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=143,columnType=12,columnName=d_house_sensitive_text_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=144,columnType=12,columnName=d_house_sensitive_text_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=145,columnType=12,columnName=d_comment_three,columnValue=��ɽ���������԰,isNull=false,isKey=false,isUpdate=true] EventColumn[index=146,columnType=12,columnName=d_comment_three_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=147,columnType=12,columnName=d_comment_three_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=148,columnType=12,columnName=d_comment_four,columnValue=����סլ-�߲�-�߲���ɽ���������԰-����-78��-160478��1604����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=149,columnType=12,columnName=d_comment_four_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=150,columnType=12,columnName=d_comment_four_system_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=151,columnType=12,columnName=excel_source_date,columnValue=2016-05-30,isNull=false,isKey=false,isUpdate=true] EventColumn[index=152,columnType=12,columnName=excel_source_file_name,columnValue=3.1 ǩԼҵ��-�±���.xls_tmpl.xlsx,isNull=false,isKey=false,isUpdate=true] EventColumn[index=153,columnType=4,columnName=excel_source_file_line_no,columnValue=2851,isNull=false,isKey=false,isUpdate=true] ---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) Caused 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 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker$2.doInTransaction(DbLoadAction.java:621) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.doCall(DbLoadAction.java:613) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.call(DbLoadAction.java:541) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doTwoPhase(DbLoadAction.java:458) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doLoad(DbLoadAction.java:275) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.load(DbLoadAction.java:161) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$FastClassByCGLIB$$d932a4cb.invoke() at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:618) at com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$$EnhancerByCGLIB$$80fd23c2.load() at com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:198) at com.alibaba.otter.node.etl.load.loader.db.DataBatchLoader$2.call(DataBatchLoader.java:189) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: Incorrect string value: '\xEF\xBF\xBD\xEF\xBF\xBD...' for column 'org_6_group' at row 1 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3835) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3771) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2535) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1911) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2145) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2081) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2066) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:818) at org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:587) ... 21 more • PairId: 1 , TableId: 2 , EventType : I , Time : 1467614672000 - Consistency : , Mode : ---Pks EventColumn[index=0,columnType=-5,columnName=id,columnValue=224934,isNull=false,isKey=true,isUpdate=true] ---oldPks ---Columns EventColumn[index=1,columnType=12,columnName=org_6_group,columnValue=����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=2,columnType=12,columnName=org_6_group_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=3,columnType=12,columnName=org_6_group_system_code,columnValue=011,isNull=false,isKey=false,isUpdate=true] EventColumn[index=4,columnType=12,columnName=org_6_area,columnValue=�Ϻ�����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=5,columnType=12,columnName=org_6_area_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=6,columnType=12,columnName=org_6_area_system_code,columnValue=011003,isNull=false,isKey=false,isUpdate=true] EventColumn[index=7,columnType=12,columnName=org_6_company,columnValue=���Ϲ�˾,isNull=false,isKey=false,isUpdate=true] EventColumn[index=8,columnType=12,columnName=org_6_company_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=9,columnType=12,columnName=org_6_company_system_code,columnValue=011003008,isNull=false,isKey=false,isUpdate=true] EventColumn[index=10,columnType=12,columnName=org_6_city,columnValue=����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=11,columnType=12,columnName=org_6_city_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=12,columnType=12,columnName=org_6_city_system_code,columnValue=011003008002,isNull=false,isKey=false,isUpdate=true] EventColumn[index=13,columnType=12,columnName=org_6_dept,columnValue=������ɽMIXTOWN,isNull=false,isKey=false,isUpdate=true] EventColumn[index=14,columnType=12,columnName=org_6_dept_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=15,columnType=12,columnName=org_6_dept_system_code,columnValue=011003008002005,isNull=false,isKey=false,isUpdate=true] EventColumn[index=16,columnType=12,columnName=org_6_stage,columnValue=������ɽMIXTOWN����,isNull=false,isKey=false,isUpdate=true] EventColumn[index=17,columnType=12,columnName=org_6_stage_custom_code,columnValue=,isNull=false,isKey=false,isUpdate=true] EventColumn[index=18,columnType=12,columnName=org_6_stage_system_code,columnValue=011003008002005003,isNull=false,isKey=false,isUpdate=true] EventColumn[index=19,columnType=12,columnName=org_5_group,columnValue=,isNull=false,isKey=false,isUpdate=true] EventCol

原提问者GitHub用户 fg-meizhi