apoc.load.csv fail within CALL apoc.periodic.iterate

[Peter_Lian]

The following cypher do not work 

####

CALL apoc.periodic.iterate('CALL apoc.load.csv("peter(5000times).csv") YIELD hello AS row RETURN row',

'CREATE(peter:Peter{name:hello.name})',{batchSize:10000, iterateList:true, parallel:true}) 

####

which showed the error 

Failed to invoke procedure `apoc.periodic.iterate`: Caused by: org.neo4j.internal.kernel.api.exceptions.ProcedureException: There is no procedure with the name `apoc.load.csv` registered for this database instance. Please ensure you've spelled the procedure name correctly and that the procedure is properly deployed.

How can I fit this problem? The following is the configuration setting in neo4j.conf

dbms.security.procedures.unrestricted=my.extensions.example,my.procedures.*,apoc.*

Thanks.

[dana_canzano]

@Peter_Lian 

Version of Neo4j ?

What is in plugins/   ?

[glilienfield]

Just a note on your query once you and @dana_canzano resolve your issue, the procedure does not return a ‘hello’ value.  You want yield ‘map’ instead. 

CALL apoc.periodic.iterate('CALL apoc.load.csv("peter(5000times).csv") YIELD map RETURN map',

'CREATE(peter:Peter{name:map.name})',{batchSize:10000, iterateList:true, parallel:true}) 

[Peter_Lian]

Ok~ Thanks you!

[Peter_Lian]

@dana_canzano 

Version : 5.2 (enterprise)

[dana_canzano]

@Peter_Lian 

could you attach you logs\debug.log

[Peter_Lian]

@dana_canzano 

Do you means the following?

If do, it don't show any log after running 

####

CALL apoc.periodic.iterate('CALL apoc.load.csv("peter(5000times).csv") YIELD row RETURN row',

'CREATE(peter:Peter{name:hello.name})',{batchSize:10000, iterateList:true, parallel:true}) 

####