Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: '广东省'
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
at com.mysql.cj.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1355)
at com.mysql.cj.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2128)
at com.mysql.cj.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1264)
at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2846)
at com.alibaba.druid.filter.FilterAdapter.statement_executeUpdate(FilterAdapter.java:2509)
at com.alibaba.druid.filter.FilterEventAdapter.statement_executeUpdate(FilterEventAdapter.java:327)
at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2844)
at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeUpdate(StatementProxyImpl.java:235)
at com.alibaba.druid.pool.DruidPooledStatement.executeUpdate(DruidPooledStatement.java:324)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:510)
at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:507)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:375)
... 105 more
insert into tb_rpt_mgn(OC_NAME,OO_NAME,ORDER_SOURCE,CLIENT_NAME,ORDER_NUMBER,CLIENT_NUMBER,RECIPIENT_NAME,RECIPIENT_DETAILADDRESS,ORDER_SN,TRUCKING_NUMBER,`status`,SENDERS_ADD,RECIPIENT_ADD,XL,OPR_ORG,BASETIME,FYEAR,FMONTH,FQUARTER,FWEEK,FDAY,OPSTIME,OPSJS,OPSWJS) SELECT OC_NAME,OO_NAME,ORDER_SOURCE,CLIENTNAME,ORDER_NUMBER,CLIENT_NUMBER,RECIPIENT_NAME,RECIPIENT_DETAILADDRESS,ORDER_SN,TRUCKING_NUMBER,`STATUS`, SENDERS_DETAILADDRESS AS SENDERS_ADD,RECIPIENT_AREA AS RECIPIENT_ADD,XL,OPR_ORG, REQ_RECEIPT_TIME as BASETIME, DATE_FORMAT(REQ_RECEIPT_TIME,'%y') AS FYEAR, RIGHT(CONCAT('0',ltrim(DATE_FORMAT(REQ_RECEIPT_TIME,'%m'))),2) AS FMONTH, CONCAT('0',QUARTER(REQ_RECEIPT_TIME)) AS FQUARTER, WEEK(REQ_RECEIPT_TIME) AS FWEEK, RIGHT(CONCAT('0',ltrim(DATE_FORMAT(REQ_RECEIPT_TIME,'%d'))),2) AS FDAY, HD_TIME AS OPSTIME, case WHEN (IFNULL(HD_TIME,NOW())>REQ_RECEIPT_TIME) THEN 0 ELSE 1 END AS OPSJS, case WHEN (IFNULL(HD_TIME,NOW())<=REQ_RECEIPT_TIME) THEN 0 ELSE 1 END AS OPSWJS  FROM VW_RPT_MGN