Neo.ClientError.Procedure.ProcedureNotFound (again)

Details of my setup:
|Version|5.25.1|
|Edition|enterprise|
|Status|Active|
|IP address|localhost|

ran below code: (Just FYI: I ran this code previously a few days ago-worked fine then and now not)

// Creating INTERACTS_WITH Edge between Session nodes and Novel Nodes
CALL apoc.periodic.iterate(
'LOAD CSV WITH HEADERS FROM "file:///webnovel.csv" AS row RETURN row',
'MATCH (session:Session {SessionId: toInteger(row.SessionId)})
MATCH (novel:Novel {ItemId: toInteger(row.ItemId)})
CREATE (session)-[r:INTERACTS_WITH]->(novel)
SET r.TimeStr = row.TimeStr,
r.Expose = toInteger(row.Expose),
r.Click = toInteger(row.Click),
r.Intro = toInteger(row.Intro),
r.Read = toInteger(row.Read),
r.RealRead = toInteger(row.RealRead),
r.Collect = toInteger(row.Collect),
r.ReadDuration = toFloat(row.ReadDuration)',
{batchSize: 1000, iterateList: true}
);

got following error:

I checked the community and followed their instructions and noticed that in the settings of my Neo4j Browser already got:

checked apoc.help

I restarted my Neo4j Browser and even reinstalled it -- am not sure why this is happening :frowning:

You don't want the second setting in the file (dbms.security.procedures.allowlist), as I believe it is stating only apoc procedures beginning with apoc.coll and apoc.load are allowed, thus disallowing apoc.periodic. I tried with and without the line enabled and I got your behavior. I suggest commenting out the line, or modifying it to meet your needs.

1 Like

Dear Gary

Thank you so much for your solution. The query is running now :slight_smile:
I initially allowed the second setting in the file as I was following the instructions on the Neo4j site: Neo4j Desktop - Neo4j Graph Data Science

:crying_cat_face:

1 Like