I am using a simple cypher to pull data in my DBMS. Initially, when I query the data I get results. A short while later, I can no longer retrieve the same data. I get the message “no changes, no records.” Has anyone else experienced this? How do I remedy this?
The cypher doesn’t return anything unless I create a new DBMS. I’ve done that a few times, but at some point the data stops returning again. Here is another Cypher that I was running successfully at first. When I began adding and removing the collected variables in the WITH statement, that’s when the data stopped returning.
MATCH (p1:PARTNERSHIP {id:'830349287'})-[p:IP]-(p2:PARTNERSHIP)
MATCH (c1:PARTNERSHIP {id:'830349287'})-[c:CP]-(c2:CORPORATION)
WITH head(collect([p2,c2])) AS nodes
CALL apoc.refactor.mergeNodes(nodes, {properties: "combine", mergeRels:true}) YIELD node
RETURN *