APOC - apoc.path.expandConfig - Procedure Not found

Neo4j Graph Platform Cypher
1

Hi Team,

I have apoc plugins - apoc-3.5.0.1-all.jar in neo4j DB. But when i run below Cypher query getting below error

match(n {path:'/PROJECTS/DATA/SERIAL/MORT/PUB_MORT_SVCG/ARCH/CAPDW_FW_LPS_MONTHLY_2520'})
with (n)
call apoc.path.expandConfig(n,{relationshipFilter: "TO",
labelFilter: "",
uniqueness: "",
minLevel:1, maxLevel:5,
filterStartNode:false}) yield path as path
return path
Limit 100;

Neo.ClientError.Procedure.ProcedureNotFound: There is no procedure with the name apoc.path.expandConfig registered for this database instance. Please ensure you've spelled the procedure name correctly and that the procedure is properly deployed.

2

I've not used expandConfig, but it can be replaced for your query ?

MATCH p=(n)-[*..5]-() WHERE n.path='/PROJECTS/DATA/SERIAL/MORT/PUB_MORT_SVCG/ARCH/CAPDW_FW_LPS_MONTHLY_2520'
RETURN p LIMIT 100
3

This is working fine.. I need to skip any nodes.. need to use apoc expand config in label filter. So that will have leverage to skip nodes in between.

But if apoc.path.expandConfig is missing means - I missed something during neo4j installation?

4

The jar should be in the plugins folder. Where did you download the jar from, and what version of Neo4j are you using with this?

5

I've tried with MovieGraph data and apoc.path.expandConfig works..
Neo4j Desktop 1.1.15 + Neo4j 3.5.2 + APOC 3.5.01

MATCH (n:Person) WHERE n.name='Tom Hanks'
WITH n
CALL apoc.path.expandConfig(n, {relationshipFilter: "ACTED_IN", labelFilter: "", uniqueness: "", minLevel: 1, maxLevel: 5, filterStartNode: false}) yield path
RETURN path
LIMIT 3

Screenshot%20from%202019-03-19%2000-18-35
Screenshot from 2019-03-19 00-18-35.png1553×804 90.1 KB

6

I have apoc jar file in plugins.. I am running using docker by below commands

sudo docker run -d
--publish=7474:7474
--publish=7473:7473
--publish=7687:7687
--volume=/mnt/nvme1n1/neo4j/neo4j/logs:/logs
--volume=/mnt/nvme1n1/neo4j/neo4j/data:/data
--volume=/mnt/nvme1n1/neo4j/neo4j/conf:/conf
--volume=/mnt/nvme1n1/neo4j/neo4j/plugins:/plugins
neo4j:3.5

7

Like this i need to add anything in neo4j.conf

dbms.security.procedures.unrestricted=apoc.trigger.,apoc.meta.

Can you please check your neo4j.conf and let me know? it will be very helpful

Thanks,
Nithin.

8

yea .. I have inside apoc jar file inside plugins folder. Neo4j 3.5

9

My config is like this. It may helps.

dbms.security.procedures.unrestricted=apoc.*
10

It didn't help after adding in config file :expressionless:

11

I have noticed jar file doesn't have full rights.. Once i gave full rights.. issue resolved

Thanks,
Nithin.

2 Likes