项目

一般

简介

错误 #14349

由 齐贝 更新于 大约 2 年 之前

*接口路径：* /api/meos/EMS_SaaS_Web/Spring/MVC/entrance/unifier/saveProjectService
*问题描述：* 新增项目—重复提交系统直接异常

*步骤：*
<pre>
{

"user_id": "PERSAGYADMIN",
"pd": "e10adc3949ba59abbe56e057f20f883e",
"groupCode": "BR",
"qb001",
"puser": {

"userId": "PERSAGYADMIN",

"loginDevice": "PC",

"pd": "e10adc3949ba59abbe56e057f20f883e"

},

"projectId": "Pj1120981231",
"Pj11098789",
"projectLocalID": "1120981231",
"qbtest009",
"projectLocalName": "编辑项目名称TestlF7V58755",
"qb测试项目29",
"businessOpeningTime": "20220322",
"20211022",
"projectName": "编辑项目TestlF7V58755",
"",
"productLine": "",
"introduction": "",
"province": "110000",

"city": "110100",

"partition": "110102",
"110101",
"detailAddress": "",
"longitude": "14.25",
"116.42",
"latitude": "45",
"12",
"altitude": "",
"climateZone": "10",
"20",
"urbanDevpLev": "1120",
"detailAddress":"this is test address",
"1110",
"functionType": "BFT-01.20.00",
"310",
"groupManageZone": "BR",
"qb001",
"liveStatus": "0" "0",
"liveTime": "",
"totalArea": "",
"undergroundGarageArea": "",
"abovegroundArea": "",
"undergroundArea": "",
"coveredArea": "",
"airConditioningArea": "",
"publicArea": "",
"rentedArea": "",
"officeArea": "",
"commercialArea": "",
"diningArea": "",
"supermarketArea": "",
"pictures": []
}
</pre>

*期望：*
程序应处理重复请求

*实际：*
系统抛异常

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"}

返回