错误 #25129
报警记录—创建报警记录, title=创建报警记录, title=创建报警记录,系统为iot,state为3,treatState为1,treateMode为2响应报文提示插入失败
0%
描述
接口路径: /dmp-alarm/alarm/record/create?userId=c2e9e49079f24ef78da248d3bfc04bec&groupCode=apiauto&projectId=Pj6120000001
header:
header:{
"Content-Type":"application/json;charset=utf-8"
}
入参:
{
"itemCode": "1030",
"objId": "Eq6110000001001961bb84bb436d9c7a8bb78cc1de78",
"classCode": "WESSEE",
"category": "iot",
"state": 3,
"treatState": 1,
"treatMode": 2,
"name": "",
"triggerTime": 1681725774485,
"endTime": 1682330574485,
"supplement": {
}, "condition": { "rules": [ "故障状态为故障时产生报警" ] }, "endInfo": { "onlineStatus": 33 }, "triggerInfo": { "onlineStatus": 98 }
}
响应:
{
"respCode": "B0001",
"respMsg": "插入失败,检查数据是否正确或多次插入",
"result": "fail"
}
当前表达式获取结果为空!请检查json提取表达式id3%%$.data.id
期望值:success
实际值:fail
业务精准断言结果:【Fail】
替换后的sql:{"select id from dmp_alarm.alarm_record_202304 where group_code='apiauto' and project_id='Pj6120000001' and id='' and state=3 and treat_mode=2 and treat_state=1":"$.data.id"}
sql断言数据库查询结果:0
sql断言结果:【Fail】
预期结果:
success,插入成功,无异常提示
实际结果:
failure,插入失败,检查数据是否正确或多次插入