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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by fg-meizhi
, 1 year ago
: 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
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 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)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.