# Empty Neo4J after PostgreSQL importing

**URL:** <https://community.neo4j.com/t/empty-neo4j-after-postgresql-importing/14535>\
**Category:** ETL-Tool\
**Tags:** postgres, import\
**Created:** [February 10, 2020, 8:03am UTC](https://community.neo4j.com/t/empty-neo4j-after-postgresql-importing/14535 "2020-02-10T08:03:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![pavlo](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/pavlo/32/9054_2.png) [@pavlo](https://community.neo4j.com/u/pavlo)\
**Post date:** [February 10, 2020, 8:03am UTC](https://community.neo4j.com/t/empty-neo4j-after-postgresql-importing/14535/1 "2020-02-10T08:03:36Z")

</div>

## 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

---

<div class="post-metadata">

**Author:** ![MuddyBootsCode](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/muddybootscode/32/10330_2.png) [@MuddyBootsCode](https://community.neo4j.com/u/MuddyBootsCode)\
**Post date:** [February 10, 2020, 10:57am UTC](https://community.neo4j.com/t/empty-neo4j-after-postgresql-importing/14535/2 "2020-02-10T10:57:32Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![pavlo](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/pavlo/32/9054_2.png) [@pavlo](https://community.neo4j.com/u/pavlo)\
**Post date:** [February 10, 2020, 11:18am UTC](https://community.neo4j.com/t/empty-neo4j-after-postgresql-importing/14535/3 "2020-02-10T11:18:36Z")

</div>

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...

 ![Screenshot 2020-02-10 at 09.55.28](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/2X/4/4bcd85f305533721ac5b5eeda22ad0ae59c40526.png) ![Screenshot 2020-02-10 at 13.15.09](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/2X/5/5c271d06c533e483266d62e228f0c3901202c144.png)

---

<div class="post-metadata">

**Author:** ![MuddyBootsCode](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/muddybootscode/32/10330_2.png) [@MuddyBootsCode](https://community.neo4j.com/u/MuddyBootsCode)\
**Post date:** [February 12, 2020, 10:18am UTC](https://community.neo4j.com/t/empty-neo4j-after-postgresql-importing/14535/4 "2020-02-12T10:18:55Z")

</div>

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.