Skip to content

Bulk import fails using Neo4j Desktop on Windows due to InvalidPathException #89

@vga91

Description

@vga91

When trying to import to windows 10, via Graph App UI, into a db STOPPED and with import mode: Bulk Import,
the following error is received:

COMMAND: java -cp "C:\Users\Giuseppe\.Neo4jDesktop\graphApps\_global\neo4j-etl-ui/dist/neo4j-etl.jar" org.neo4j.etl.NeoIntegrationCli export --mapping-file "C:\Users\Giuseppe\AppData\Local\Temp/mysql_Northwind_Northwind_mapping.json" --destination "C:\Users\Giuseppe\.Neo4jDesktop\relate-data\dbmss\dbms-80fb1422-3bcc-4658-b636-adbb0591bb54/data/databases/graph.db/" --import-tool "C:\Users\Giuseppe\.Neo4jDesktop\relate-data\dbmss\dbms-80fb1422-3bcc-4658-b636-adbb0591bb54/bin" --rdbms:password "prova" --rdbms:user "root" --rdbms:url "jdbc:mysql://localhost:3306/Northwind?autoReconnect=true&useSSL=false&useCursorFetch=true&allowPublicKeyRetrieval=true" --csv-directory "C:\Users\Giuseppe\AppData\Local\Temp" --options-file "C:\Users\Giuseppe\AppData\Local\Temp/import-tool-options.json" --using "bulk:neo4j-import" --neo4j:url "bolt://localhost:11006" --neo4j:user "neo4j" --neo4j:password "apoc" --force
- Reading options from file C:\Users\Giuseppe\AppData\Local\Temp\import-tool-options.json.
- Reading metadata mapping from file: C:\Users\Giuseppe\AppData\Local\Temp/mysql_Northwind_Northwind_mapping.json
- Running ETL on Neo4j 4.4.8 - ENTERPRISE
- Exporting from RDBMS to CSV...
- CSV directory: C:\Users\Giuseppe\AppData\Local\Temp\csv-013
- Writing CSV headers for node NODE_Northwind.SalesOrder_c0d433ca-554f-4403-9e6f-be46eb54c5d6
- Writing CSV headers for node NODE_Northwind.Category_025bac3d-18c9-410d-80b4-26fe9cbfb975
.....
....
Export time: 0.361 (s)
- Creating Neo4j store from CSV...
- Direct driver instance 173791568 created for server address localhost:11006
Unable to connect to Neo4j due to the following exception: Unable to connect to localhost:11006, ensure the database is running and that there is a working network connection to it.
- Importing data into Neo4j
- Command failed due to error (CommandFailedException: Command failed [Command: 'C:\Users\Giuseppe\.Neo4jDesktop\relate-data\dbmss\dbms-80fb1422-3bcc-4658-b636-adbb0591bb54\bin\neo4j-admin.bat @C:\Users\Giuseppe\AppData\Local\Temp\csv-013\neo4j-admin-import-params', CommandResult { ExitValue: 2, Stdout: '', Stderr: 'Invalid value for option '--report-file': cannot convert 'C:UsersGiuseppe.Neo4jDesktop
elate-datadbmssdbms-80fb1422-3bcc-4658-b636-adbb0591bb54importimport.report' to interface java.nio.file.Path (java.nio.file.InvalidPathException: Illegal char <
> at index 28: C:UsersGiuseppe.Neo4jDesktop
elate-datadbmssdbms-80fb1422-3bcc-4658-b636-adbb0591bb54importimport.report)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions