Neo4j 5 LOAD CSV error. ExternalResourceFailed

Neo4j Graph Platform
,
1

I am trying to load csv from a remote url. The neo4j is running on windows server.

This seems to work in console mode when neo4j is started using neo4j.bat console. The LOAD CSV query runs fine.

QUERY: `LOAD CSV FROM 'https://data.neo4j.com/bands/artists.csv'

AS row return row`

The same stops working when run as a windows service

neo4j.bat start

The file is file:////<some external non local url>

Error screenshot

Changes in the config file:

dbms.security.allow_csv_import_from_file_urls=true

Note: I have already checked all log. There is nothing in the log.

2

BTW, the file url for load cvs is file:///. Note there are three forward slashes. You description is showing four in your code snippet.

NOTE: the screenshot link doesn't work.

3

Often times "works interactively, doesn't work as a service" can be down to permission problems on windows.

4

I was able to resolve the issue by logging on using the service which had the permission on log on tab in windows service properties.