Failed to invoke procedure `apoc.load.csv`: Caused by: java.io.IOException: Cannot open file test.csv for reading

user_5910344 0
Viewed 2157

I am using Neo4j 3.4.7 and this is simple query i tried to run:

 CALL apoc.load.csv('test.csv') yield lineNo, map , list
 RETURN *;

after getting error I set following apoc related rules in conf file:

 apoc.import.file.enabled=true
 apoc.import.file.use_neo4j_config=true
 dbms.security.allow_csv_import_from_file_urls=true

but still i get above error, any help or hint?

neo4j-apoc neo4j
2 Answers

I was just working on the same apoc.load.csv procedure in the Neo4j 3.4.7 desktop environment. I received the exact same error. I was using the same config rules that @shafig posted. I changed the file source in the config to enable the absolute file path. apoc.import.file.use_neo4j_config=false

After I reran the procedure with the full path, it executed correctly. It appears that using the import directory does not work correctly.
Brett

user_49059030

This error is caused by one of 3 conditions

  • The given file does not exist
  • The given file is not a file (like a directory)
  • The program does not have permission to read the file (OS constraint)

I'm guessing the first one is probably the problem. I recommend you use the absolute file path so that execution context doesn't matter. (It is probably looking in the directory that the neo4j start files are or the apoc jar location, or god knows where really when OS behavior is involved.) If you use the absolute path though, it won't matter what the "current directory" from APOC's view is. (Just in case, I will also mention that the file you are reading must actually be on the same computer as Neo4j)

If that isn't it, than either another program has a write lock on the file (close any programs that have the file open to release any locks they may have placed), or read restrictions are placed on the file (Contact your system administrator to fix file permission issues. I highly doubt user read permissions is the problem, but is possible)

user_68938660
Related