2022-09-28 17:33:41,045 [XNIO-1 task-2] ERROR [c.s.s.f.intercepter.SaasGlobalExceptionHandler] SaasGlobalExceptionHandler.java:167 - 【系统异常】-通过POST方式请求接口地址：http://10.19.0.112/v3/saas/surveyObject/batchV3 时发生异常，trace-id：null，响应服务器：172.22.0.132，请求参数为：{“list”:[{“address”:“和平里东街11号航星园生活服务中心一层”,“lat”:39.950458,“lng”:116.42231100000001,“pointIndex”:5,“polygonRegion”:“”,“reportId”:6088,“shopName”:“朋克养生PUNK THERAPY”},{“address”:“和平里南街中国航天科工”,“lat”:39.954058,“lng”:116.420311,“pointIndex”:4,“polygonRegion”:“”,“reportId”:6088,“shopName”:“梯饮”}],“merchantId”:146,“projectName”:“北京市-北京市01-20220928”,“reportType”:2,“userId”:860,“userName”:“杨过”}，异常信息：com.collect.server.mapper.SurveyShopTaskMapper.insert (batch index #1) failed. Cause: java.sql.BatchUpdateException: Incorrect string value: ‘\xE6\x9D\xA8\xE8\xBF\x87’ for column ‘charge_person_name’ at row 1; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: ‘\xE6\x9D\xA8\xE8\xBF\x87’ for column ‘charge_person_name’ at row 1; nested exception is java.sql.BatchUpdateException: Incorrect string value: ‘\xE6\x9D\xA8\xE8\xBF\x87’ for column ‘charge_person_name’ at row 1，堆栈信息：org.springframework.jdbc.UncategorizedSQLException: com.collect.server.mapper.SurveyShopTaskMapper.insert (batch index #1) failed. Cause: java.sql.BatchUpdateException: Incorrect string value: ‘\xE6\x9D\xA8\xE8\xBF\x87’ for column ‘charge_person_name’ at row 1; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: ‘\xE6\x9D\xA8\xE8\xBF\x87’ for column ‘charge_person_name’ at row 1; nested exception is java.sql.BatchUpdateException: Incorrect string value: ‘\xE6\x9D\xA8\xE8\xBF\x87’ for column ‘charge_person_name’ at row 1 at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:89) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81) at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88) at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.executeBatch(ServiceImpl.java:232) at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.executeBatch(ServiceImpl.java:252)
本文使用 文章同步助手 同步
