错误 #7940
全部关系总览--空调风管网等设置源端后，再启动计算报错
0%
描述
前置条件：
测试环境：http://192.168.64.14:8888
项目名称：【东坝万达广场】
步骤：
1.进入全部关系总览下
2.如：选择【空调送风】，设定设备源/末端，选择源端设备类：空调风口，并保存
3.点击【启动计算】--【立即计算】，等待结果
测试结果：
计算报错
Request URL: http://192.168.64.14:8888/api/datacenter/calc_special/sys-block?relationType=eq2eq_ACAirNetwork_1
request：
{"projectId":"Pj1101050029","relationType":"eq2eq_ACAirNetwork_1"}
response：
{"message":"\n### Error querying database. Cause: org.postgresql.util.PSQLException: 错误: 语法错误 在 \")\" 或附近的\n 位置：347\n### The error may exist in com/persagy/server/mappers/MepSystemMapper.java (best guess)\n### The error may involve com.persagy.server.mappers.MepSystemMapper.getEquipByBimId-Inline\n### The error occurred while setting parameters\n### SQL: SELECT id1 sourceId, block.project_id projectId, block.block_id blockId, block.type1 as sourceType, domain, mep_system_type mepSystemType, building_id buildingId FROM revit_calc.connected_block block INNER JOIN revit.equipment eq on eq.id = block.id1 WHERE (block.project_id = 'Pj1101050029') AND (mep_system_type in ('空调送风风管')) AND (bimid in ()) union SELECT id2 sourceId, block.project_id projectId, block.block_id blockId, block.type2 as sourceType, domain, mep_system_type mepSystemType, building_id buildingId FROM revit_calc.connected_block block INNER JOIN revit.equipment eq on eq.id = block.id2 WHERE (block.project_id = 'Pj1101050029') AND (mep_system_type in ('空调送风风管')) AND (bimid in ())\n### Cause: org.postgresql.util.PSQLException: 错误: 语法错误 在 \")\" 或附近的\n 位置：347\n; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: 错误: 语法错误 在 \")\" 或附近的\n 位置：347","result":"failure"}
预期结果：
应该计算成功
文件
