Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
vga91 opened this issue Aug 31, 2022 · 0 comments

Comments

@vga91
Copy link

vga91 commented Aug 31, 2022

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)
@vga91 vga91 changed the title Bulk import fails on windows due to InvalidPathException Bulk import fails using Neo4j Desktop on Windows due to InvalidPathException Aug 31, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant