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

GitHub | fg-meizhi | 5 months ago
  1. 0

    insert 中文异常

    GitHub | 5 months ago | fg-meizhi
    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
  2. 0

    数据同步如何关闭on duplicate key update语法

    GitHub | 3 months ago | zjunbao
    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 mark.mark_user(`channelId` , `userId` , `icon` , `lastModify` , `c_status` , `owner` , `id`) values (? , ? , ? , ? , ? , ? , ?) on duplicate key update `channelId`=values(`channelId`) , `userId`=values(`userId`) , `icon`=values(`icon`) , `lastModify`=values(`lastModify`) , `c_status`=values(`c_status`) , `owner`=values(`owner`) , `id`=values(`id`)]; SQL state [HY000]; error code [4506]; [9d2bc5a7a401000-2][10.44.182.20:3306][mark]ERR-CODE: [TDDL-4506][ERR_MODIFY_SHARD_COLUMN] Column 'userId' is a sharding key of table 'mark_user', which is forbidden to be modified. More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4506]; nested exception is java.sql.SQLException: [9d2bc5a7a401000-2][10.44.182.20:3306][mark]ERR-CODE: [TDDL-4506][ERR_MODIFY_SHARD_COLUMN] Column 'userId' is a sharding key of table 'mark_user', which is forbidden to be modified. More: [http://middleware.alibaba-inc.com/faq/faqByFaqCode.html?faqCode=TDDL-4506]
  3. 0

    mysql5.6日期字段无法同步

    GitHub | 3 years ago | scriptguy
    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.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [update tb set `create_time` = ? , `update_time` = ? where ]; Data truncation: Incorrect datetime value: '1383277380000' for column 'create_time' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1383277380000' for column 'create_time' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    mysql5.6日期字段无法同步

    GitHub | 3 years ago | scriptguy
    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.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [update tb set `create_time` = ? , `update_time` = ? where ]; Data truncation: Incorrect datetime value: '1383277380000' for column 'create_time' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1383277380000' for column 'create_time' at row 1
  6. 0

    日期时间报错

    GitHub | 3 years ago | niuliwei
    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.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [insert into scms_0801.sc_fsm_entity_state(`CREATE_BY` , `CREATE_TIME` , `UPDATE_BY` , `UPDATE_TIME` , `ENTITY` , `ENTITY_ID` , `STATE_ID` , `ID`) values (? , ? , ? , ? , ? , ? , ? , ?) on duplicate key update `ID`=values(`ID`) , `CREATE_BY`=values(`CREATE_BY`) , `CREATE_TIME`=values(`CREATE_TIME`) , `UPDATE_BY`=values(`UPDATE_BY`) , `UPDATE_TIME`=values(`UPDATE_TIME`) , `ENTITY`=values(`ENTITY`) , `ENTITY_ID`=values(`ENTITY_ID`) , `STATE_ID`=values(`STATE_ID`)]; Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '1392678061000' for column 'CREATE_TIME' at row 1

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. Spring Framework
      JdbcTemplate.update
      1. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
      2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
      3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
      4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)
      5. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)
      5 frames
    3. etl module for otter
      DbLoadAction$DbLoadWorker$2.doInTransaction
      1. com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker$2.doInTransaction(DbLoadAction.java:621)
      1 frame
    4. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)
      1 frame
    5. etl module for otter
      DbLoadAction.load
      1. com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.doCall(DbLoadAction.java:613)
      2. com.alibaba.otter.node.etl.load.loader.db.DbLoadAction$DbLoadWorker.call(DbLoadAction.java:541)
      3. com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doTwoPhase(DbLoadAction.java:458)
      4. com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.doLoad(DbLoadAction.java:275)
      5. com.alibaba.otter.node.etl.load.loader.db.DbLoadAction.load(DbLoadAction.java:161)
      5 frames