ETL Tool(v1.3.2)_has blank screen with latest Neo4j Desktop(v1.1.14)

[michaeljquinn]

Latest ETL tool (v1.3.2) which fixed the blank screen on selection of non built in driver (issue - https://github.com/neo4j-contrib/neo4j-etl/issues/35) was fixed and verified by me against the previous version of Neo4j desktop

On upgrading to latest desktop (V1.1.14), on launching of ETL tool, i get an activity screen(spinning icon, grey screen) and on completion (developer tools does not indicate any error), there is a blank screen

[jexp]

If you need to you can downgrade desktop to 1.1.13 by using the download link and changing the version back.

from here: https://neo4j.com/download-center/

Still investigating what the issue is.

[michaeljquinn]

thanks. all good, can verify that under Desktop 1.1.13 all works fine with ETL 1.3.2

[jexp]

I also just pushed out 1.3.3 with a workaround for this Desktop bug

[jexp]

Thanks again for reporting Michael

[michaeljquinn]

wow, super responsive, thanks heaps jexp

[jexp]

Unfortunately it turned out there is a 2nd issue, related to the security settings. Desktop has much tighter security now but now way for apps to express their needs so you'd have to set it manually. To make it work.

[bbmac-ds]

I still get the blank screen. I have tried everything. Does it have something to do with the JVM?

[conker84]

Hi @bbmac-ds can you please share the Neo4j Desktop Version? I just tried with the last one and it works properly

[bbmac-ds]

I have the latest version of desktop as of today. I think it is a jvm issue.

Get Outlook for Androidhttps://aka.ms/ghei36

---

From: Andrea Santurbano @.> Sent: Wednesday, March 24, 2021 11:34:11 AM To: neo4j-contrib/neo4j-etl @.> Cc: Bruce MacArthur @.>; Mention @.> Subject: Re: [neo4j-contrib/neo4j-etl] ETL Tool(v1.3.2)_has blank screen with latest Neo4j Desktop(v1.1.14) (#40)

Hi @bbmac-dshttps://github.com/bbmac-ds can you please share the Neo4j Desktop Version? I just tried with the last one and it works properly

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/neo4j-contrib/neo4j-etl/issues/40#issuecomment-806022778, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AJAAAPBZQATS6D7W7JTQ3FTTFIPBHANCNFSM4GT7ULIA.

[jexp]

but the jvm is bundled with desktop there is no variance across installations.

Best would be to share the desktop logs (accessible from the help menu)

[bbmac-ds]

but the jvm is bundled with desktop there is no variance across installations.

Best would be to share the desktop logs (accessible from the help menu)

log.log query.log security.log debug.log neo4j.log

[conker84]

Can you please be sure that the part in blue is checked as the image above? In order to reach it you have to click to the highlighted buttons in this sequence: red, yellow, blue

Thank you

[bbmac-ds]

This is how I have it configured.

[bbmac-ds]

I noticed I have 'Allow access to activation keys' and I unchecked it. (Checked it a bit ago to see if it made a difference). I tried launching the ETL tool after I unchecked that box and it loaded but said I need to start a db

[conker84]

so it's working now?

[bbmac-ds]

I started a local db and tried to launch the etl tool again. It thought for a bit longer than normal and then I got the blank UI

[conker84]

click on Developer > Developer Tools from the ETL blank ui? A chrome console should we shown please share tab console messages

[bbmac-ds]

There don't seem to be any console messages.

[conker84]

That's really odd can you try with just remove and reinstall the etl tool?

[mtrobocraft]

Hi. I am facing the same issue. Has anyone found a solution? My current verision of Neo4j is 1.5.9

[vga91]

@mtrobocraft Tried to replicate it on both OSX and Windows 10 (using Neo4j Desktop 1.5.9), and it works correctly :/

Can you try enabling development mode and see if any errors are logged?

The steps are:

1. Check that the "Enable development mode" checkbox is flagged.

   

2. After opening the ETL UI, click on "App Developer tools"

   

3. Once the Developer Tools is open, go to the "Console" tab:

   

[mtrobocraft]

Thank you @vga91 As requested, these are the console messages I get:

[vga91]

@mtrobocraft I'm not sure if it works, but theoretically in the folder C:\Users\Giuseppe\.Neo4jDesktop\distributions\java you should have a zulu17.44.53-ca-jdk17.0.8.1 folder and a zulu17.44.53-ca-jdk17.0.8.1-win_x64.zip archive.

You could try to:

• remove the zulu17.44.53-ca-jdk17.0.8.1 folder,
• extract the zulu17.44.53-ca-jdk17.0.8.1-win_x64.zip
• rename it to zulu17.44.53-ca-jdk17.0.8.1.

Or, if it doesn't work, can you try downloading a put it manually from here: https://www.azul.com/downloads/?package=jdk#zulu ?

[mtrobocraft]

It seems that unzipping the zulu package worked, but now there is an issue with java certs.

After deleting the _JAVA_OPTIONS from the system Variables the ETL tool seems to be working. I will continue testing if this solution does not affect other programs, but for now it seems to work. Thanks @vga91

[Amraki]

@mtrobocraft I'm not sure if it works, but theoretically in the folder C:\Users\Giuseppe\.Neo4jDesktop\distributions\java you should have a zulu17.44.53-ca-jdk17.0.8.1 folder and a zulu17.44.53-ca-jdk17.0.8.1-win_x64.zip archive.

You could try to:

• remove the zulu17.44.53-ca-jdk17.0.8.1 folder,
• extract the zulu17.44.53-ca-jdk17.0.8.1-win_x64.zip
• rename it to zulu17.44.53-ca-jdk17.0.8.1.

Or, if it doesn't work, can you try downloading a put it manually from here: https://www.azul.com/downloads/?package=jdk#zulu ?

Unzipping and replacing the folder fixed the problem for me. Thanks, @vga91!