{
"rows": [
{
"point_code": "A1",
"point_type": "1"
},
{
"point_code": "A2",
"point_type": "1"
},
{
"point_code": "A3",
"point_type": "1"
}
]
}curl --location --request POST 'http://127.0.0.1:8011/api/schBasePoint/updatePointType' \
--header 'Authorization: eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJsb2dpblR5cGUiOiJsb2dpbiIsImxvZ2luSWQiOiIxIiwicm5TdHIiOiJrQkhHS1BTWjR0QXppWXNqeGdlTkRIYjdHaXR3clBISCIsImxvZ2luSW5mbyI6IntcImlkXCI6XCIxXCIsXCJwZXJtaXNzaW9uc1wiOltcImFkbWluXCIsXCJnZW5Db2RlOmxpc3RcIixcImdlbkNvZGU6YWRkXCIsXCJnZW5Db2RlOmRlbFwiLFwiZ2VuQ29kZTplZGl0XCIsXCJ1c2VyOmxpc3RcIixcInRpbWluZzpsaXN0XCIsXCJyb2xlczpsaXN0XCIsXCJkZXB0Omxpc3RcIixcImRpY3Q6bGlzdFwiLFwic3RvcmFnZTpsaXN0XCIsXCJzdG9yYWdlOmFkZFwiLFwic3RvcmFnZTplZGl0XCIsXCJzdG9yYWdlOmRlbFwiLFwidXNlcjphZGRcIixcInVzZXI6ZWRpdFwiLFwidXNlcjpkZWxcIixcInJvbGVzOmFkZFwiLFwicm9sZXM6ZWRpdFwiLFwibWVudTpsaXN0XCIsXCJyb2xlczpkZWxcIixcIm1lbnU6YWRkXCIsXCJtZW51OmVkaXRcIixcIm1lbnU6ZGVsXCIsXCJkZXB0OmFkZFwiLFwiZGVwdDplZGl0XCIsXCJkZXB0OmRlbFwiLFwiZGljdDphZGRcIixcImRpY3Q6ZWRpdFwiLFwiZGljdDpkZWxcIixcInRpbWluZzphZGRcIixcInRpbWluZzplZGl0XCIsXCJ0aW1pbmc6ZGVsXCIsXCJtb25pdG9yOmxpc3RcIl0sXCJwcmVzb25OYW1lXCI6XCLnrqHnkIblkZhcIixcInVzZXJcIjp7XCJhdmF0YXJfbmFtZVwiOlwiYXZhdGFyLTIwMjAwODA2MDMyMjU5MTYxLnBuZ1wiLFwiYXZhdGFyX3BhdGhcIjpcIi9Vc2Vycy9qaWUvRG9jdW1lbnRzL3dvcmsvbWUvYWRtaW4vZWxhZG1pbi9-L2F2YXRhci9hdmF0YXItMjAyMDA4MDYwMzIyNTkxNjEucG5nXCIsXCJjcmVhdGVfbmFtZVwiOlwiXCIsXCJjcmVhdGVfdGltZVwiOlwiMjAyMi0xMi0wMSAwMDowMDowMFwiLFwiZW1haWxcIjpcIjIwMTUwNzgwMkBxcS5jb21cIixcImdlbmRlclwiOlwiMVwiLFwiaXNfYWRtaW5cIjp0cnVlLFwiaXNfdXNlZFwiOnRydWUsXCJwYXNzd29yZFwiOlwiZjUyMDIwZGNhNzY1ZmQzOTQzZWQ0MGE2MTVkYzJjNWNcIixcInBlcnNvbl9uYW1lXCI6XCLnrqHnkIblkZhcIixcInBob25lXCI6XCIxODMxMjM2NTg5NlwiLFwicHdkX3Jlc2V0X3VzZXJfaWRcIjowLFwidXBkYXRlX2lkXCI6XCIxXCIsXCJ1cGRhdGVfbmFtZVwiOlwiYWRtaW5cIixcInVwZGF0ZV90aW1lXCI6MTcyNDE0MzY3MDAwMCxcInVzZXJfaWRcIjpcIjFcIixcInVzZXJuYW1lXCI6XCJhZG1pblwifSxcInVzZXJuYW1lXCI6XCJhZG1pblwifSJ9.ap63IuGnKaCjk8BPkpprIKMsWBwUte_czBYcXl1zbD0' \
--header 'Content-Type: application/json' \
--data-raw '{
"rows": [
{
"point_code": "A1",
"point_type": "1"
},
{
"point_code": "A2",
"point_type": "1"
},
{
"point_code": "A3",
"point_type": "1"
}
]
}'{
"status": 400,
"timestamp": "2025-08-06 11:07:51",
"message": "\r\n### Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'point_type' at row 1\r\n### The error may exist in org/nl/wms/sch_manage/service/dao/mapper/SchBasePointMapper.java (best guess)\r\n### The error may involve org.nl.wms.sch_manage.service.dao.mapper.SchBasePointMapper.updateById-Inline\r\n### The error occurred while setting parameters\r\n### SQL: UPDATE sch_base_point SET point_name=?, region_code=?, region_name=?, point_type=?, point_status=?, can_vehicle_type=?, vehicle_max_qty=?, vehicle_type=?, vehicle_qty=?, block_num=?, row_num=?, col_num=?, layer_num=?, in_order_seq=?, out_order_seq=?, in_empty_seq=?, out_empty_seq=?, parent_point_code=?, is_has_workder=?, workshop_code=?, is_auto=?, is_used=?, create_id=?, create_name=?, create_time=?, update_id=?, update_name=?, update_time=? WHERE point_code=?\r\n### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'point_type' at row 1\n; Data truncation: Data too long for column 'point_type' at row 1; nested exception is com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'point_type' at row 1"
}