I was able to create a connection to my existing POSTGRESQL database and map the desired tables, but the IMPORT DATA step fails, and the log only shows:
I don't see anything relevant in any of the log files (neo4j.log, debug.log, etc). In fact, none of the log files appear to be written to as a result of clicking on the "IMPORT DATA" button. All I see are periodic additions to the query.log file seemingly unrelated to this operation. Therefore, I am assuming the failure is in the ETL tool before it connects to the database at all.
This is my first time trying neo4j and it's difficult to evaluate when I can't load my data. Any tips would be appreciated!
MacOS Catalina Version 10.15.7
Neo4j Desktop - 1.3.11
Neo4j ETL Tool version 1.5.1
Neo4j Version: 4.1.3 - enterprise (LOCAL)
My guess is there is a bug with neo4j-etl.jar, where an unexpected NULL is returned (which is why the error is unhelpful....) That obviously needs to get fixed.
I would also try to run this as a command line in a terminal app and get a long (and messy) stack crawl of the error. It's going to be very hard to debug without more info...
That is trying running something this (you may have to tweak some of the parameters to get it to work):
Also do this to find out what version of java you are running: java -version
In the meantime, have you tried exporting to CSV and then importing? I found the Cypher code is pretty good for importing since you can do a lot with fields as you are building your nodes and/or relationships.
See:
If you do this, it really helps to set the import directory:
Neo4j Desktop -> click on three dots -> Manage -> Settings
Change: dbms.directories.import=import
to dbms.directories.import=ABSOLUTE_PATH_NAME
Thanks for the help. It turned out to be simpler (and dumber) - I was running it on a relatively new laptop which apparently I had never installed JDK on. When I ran the import from the command line instead of from the Desktop app, it gave me a much more helpful response...