错误 #14349
项目管理—新增项目—重复提交系统直接异常
0%
描述
接口路径: /api/meos/EMS_SaaS_Web/Spring/MVC/entrance/unifier/saveProjectService
问题描述: 新增项目—重复提交系统直接异常
步骤:
{
"groupCode": "BR",
"puser": {
"userId": "PERSAGYADMIN",
"loginDevice": "PC",
"pd": "e10adc3949ba59abbe56e057f20f883e"
},
"projectId": "Pj1120981231",
"projectLocalID": "1120981231",
"projectLocalName": "编辑项目名称TestlF7V58755",
"businessOpeningTime": "20220322",
"projectName": "编辑项目TestlF7V58755",
"province": "110000",
"city": "110100",
"partition": "110102",
"longitude": "14.25",
"latitude": "45",
"climateZone": "10",
"urbanDevpLev": "1120",
"detailAddress":"this is test address",
"functionType": "BFT-01.20.00",
"groupManageZone": "BR",
"liveStatus": "0"
}
期望:
程序应处理重复请求
实际:
系统抛异常
response:
{"content":[],"reason":"{\"message\":\"\n### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'Pj1120981231' for key 'PRIMARY'\n### The error may exist in class path resource [mapping/ProjectStateMapper.xml]\n### The error may involve com.persagy.dao.mapper.ProjectStateMapper.insert-Inline\n### The error occurred while setting parameters\n### SQL: insert into t_project (c_project_id, c_state, c_create_time, c_update_time,group_code) values (?, ?, ?, ?,?)\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'Pj1120981231' for key 'PRIMARY'\n; Duplicate entry 'Pj1120981231' for key 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry 'Pj1120981231' for key 'PRIMARY'\"}","result":"failure","version":"1.0"}