org.neo4j.graphdb.QueryExecutionException: Can't coerce NO_VALUE to String

[ThanigaiarasuA]

Hello,

Good day.

I'm getting one inconsistent issue after the 10th time execution. The error is "org.neo4j.graphdb.QueryExecutionException: Can't coerce NO_VALUE to String"...

My query is like this, "optional match (:abc{ xyz:res})-[r]->(dpt:lmn) with res, collect({ re:r, MLV:depPt.MCLV}) as DL

optional match (:abc)-[r]->(dpt:lmn{ xyz:res }) with res, DL, collect(r) as RDL"

FYI,

It's a mid-query, I got an error log in this area only. Whenever, if I use the delete cache query then it'll work fine but after 10 times of execution again get the same issue. And I have prepended CYPHER expressionEngine=INTERPRETED to the query as well, even though I got the same issue after the 10th time execution. Version details :

Any other way is there to fix it via config or something?

Thanks in advance

-Thanigai

[Lojjs]

@ThanigaiarasuA I assume the above is not the full query, as it is not semantically correct (I get Variable res not defined when running it locally). Would you be able to send us the full query so we can reproduce and investigate the bug further?

Best regards Louise, Neo4j Cypher team

[alexfoxgill]

@ThanigaiarasuA we believe this issue may have been fixed in later patch versions of 4.4, please could you try upgrading (at the time of writing the latest is 4.4.25). if not, please provide the full query and a stack trace from the debug log so that we can try to reproduce the error on our side,