cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Empty Neo4J after PostgreSQL importing

Importing PostgreSQL DB with ETL-Tool
After Skipping some not relevant for importing tables and saving the model initiate importing.
After importing is finished I got message "Import Successful".
BUT Neo4J after request looks totally empty.
I look in LOGS of importing process and find:

java.lang.NullPointerException
at org.neo4j.etl.sql.DatabaseClient$SqlQueryResults.next(DatabaseClient.java:303)
at org.neo4j.etl.sql.exportcsv.io.CsvFileWriter.lambda$writeAsyncExportFile$0(CsvFileWriter.java:46)
at java.util.concurrent.CompletableFuture.uniHandle(CompletableFuture.java:836)
at java.util.concurrent.CompletableFuture$UniHandle.tryFire(CompletableFuture.java:811)
at java.util.concurrent.CompletableFuture$Completion.exec(CompletableFuture.java:457)
at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289)
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056)
at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692)
at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157)

If importing is successful - where is my data?
If it's not successful - why I got the message "Import is successful"

Please advise my next steps?

Thank you!

Regards,
Pavlo

3 REPLIES 3

MuddyBootsCode
Graph Steward

Welcome to the community Pavlo. Do you have an example of the data set you're trying to import and the Cypher statements you're using to do the import? That might help a bit to get an idea of what's going on.

Dear Michael, thanks for warm words.

Regarding your question. I can't share a DB access it contains private data.
I did not use Cypher I use ETL Tool Importing application available in Neo4J Desktop.
In few words, I add it as a source for importing in "Neo4J ETL Tool 1.4.2".
ETL tools connect and show me a relationship between nodes correctly.
Then on the final stage, I see picture (in attachment)
I have no idea what to do next and what exactly is wrong...

MuddyBootsCode
Graph Steward

It's hard to help without some understanding of the underlying data structure. It might be that it's incorrectly setting something for your nodes and not actually creating them. If you could provide a sanitized version of what you're importing and what you expect the graph to look like that would help.