cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure `apoc.path.subgraphNodes`: Caused by: org.neo4j.graphdb.NotFoundException: Node[35399801] not connected to this relationship[117302253]

when i run this query

  1. MATCH (n:Gluser {GLUSR_USR_ID:'6601433'}) CALL apoc.path.subgraphNodes(n, {maxLevel:-1,relationshipFilter:'HAS_MOBILE|HAS_PHONE|HAS_GST|HAS_CIN|HAS_PAN|HAS_EMAIL|HAS_BANK_AC|HAS_IMEI',bfs:true, filterStartNode:false, limit:200000, optional:false}) YIELD node match (node:Gluser) where node.GLUSR_DISABLE_ERRMSG_VALUE in ['Fraud complaint','Payment protection Non-compliance','Multiple bs conflict','Conflict temporary disable'] and node.GLUSR_USR_APPROV = 'D' and node <> n with node,n limit 10 match p = shortestPath((n)-[:HAS_EMAIL|:HAS_MOBILE|:HAS_PHONE|:HAS_CIN|:HAS_GST|:HAS_PAN|:HAS_BANK_AC|:HAS_IMEI*]-(node)) return node.GLUSR_USR_ID,Nodes(p) as coll order by size(coll) skip 0 limit 10

this query is giving error "Neo.ClientError.Procedure.ProcedureCallFailed: Failed to invoke procedure apoc.path.subgraphNodes: Caused by: org.neo4j.graphdb.NotFoundException: Node[35399801] not connected to this relationship[117302253] "

and when i run this query in two parts it run it runs

MATCH (n:Gluser {GLUSR_USR_ID:'6601433'}) CALL apoc.path.subgraphNodes(n, {maxLevel:-1,relationshipFilter:'HAS_MOBILE|HAS_PHONE|HAS_GST|HAS_CIN|HAS_PAN|HAS_EMAIL|HAS_BANK_AC|HAS_IMEI',bfs:true, filterStartNode:false, limit:200000, optional:false}) YIELD node match (node:Gluser) where node.GLUSR_DISABLE_ERRMSG_VALUE in ['Fraud complaint','Payment protection Non-compliance','Multiple bs conflict','Conflict temporary disable'] and node.GLUSR_USR_APPROV = 'D' and node <> n return node.GLUSR_USR_ID,n.GLUSR_USR_ID limit 10

match (n:Gluser),(node:Gluser) where node.GLUSR_USR_ID in ["69726522","43002469","55850060","51934302","34116241","65855170","53473582","2960020","56408371","14903972"] and n.GLUSR_USR_ID = "6601433"
match p = shortestPath((n)-[:HAS_EMAIL|:HAS_MOBILE|:HAS_PHONE|:HAS_CIN|:HAS_GST|:HAS_PAN|:HAS_BANK_AC|:HAS_IMEI*]-(node)) return node.GLUSR_USR_ID,Nodes(p) as coll order by size(coll) skip 0 limit 10

this give proper result then why complete query its not running together

neo4j version 3.5.12 community

0 REPLIES 0
Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

All the sessions of the conference are now available online