Error: Could not find or load main class org.neo4j.etl.rdbms.Support #75

benmadin · 2020-10-27T13:57:33Z

Hi,

Using:
Neo4j Desktop Version: 1.3.10
Neo4j Instance: 4.1.3-enterprise

running on Mac OSX Catalina

I have uninstalled and reinstalled but keep getting the error message above when I try to connect to a postgresql instance.

I'm not adequately java savvy to even know where that class should be, sorry, or how to replace it?

cheers

Ben

conker84 · 2020-10-27T15:01:16Z

can you share a screenshot of the error?

J-Krush · 2020-10-27T18:49:52Z

I am getting the same error.

Using:

Neo4j Desktop Version: 1.3.9
Neo4j Instance: 4.0.4-enterprise

Screenshot below:

benmadin · 2020-10-28T01:18:25Z

I am getting the same error.

Using:

Neo4j Desktop Version: 1.3.9

Neo4j Instance: 4.0.4-enterprise

Screenshot below:

It won't help (I suspect) for me to post another screenshot, but I did find:

[2020-10-28 09:12:30.022] [info] Executing '/Users/benmadin/Library/Application Support/Neo4j Desktop/Application/distributions/java/zulu8.48.0.53-ca-jdk8.0.265/bin/java, -cp, /Users/benmadin/Library/Application Support/Neo4j Desktop/Application/graphApps/_global/neo4j-etl-ui-1/dist/neo4j-etl.jar, org.neo4j.etl.util.FileUtils, getimportfolder'
[2020-10-28 09:12:30.328] [info] Process [3702] exit with code '0', signal 'null'
[2020-10-28 09:12:50.160] [info] [1] Online check request: https://dist.neo4j.org/neo4j-desktop/win/latest.yml
[2020-10-28 09:12:51.456] [info] [1] Online check response: 200 version: 1.3.10
file
[2020-10-28 09:12:55.948] [info] Executing '/Users/benmadin/Library/Application Support/Neo4j Desktop/Application/distributions/java/zulu8.48.0.53-ca-jdk8.0.265/bin/java, -cp, /Users/benmadin/Library/Application Support/Neo4j Desktop/Application/graphApps/_global/neo4j-etl-ui-1/eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpYXQiOjE2MDM4NDc1NDgsImV4cCI6MTYwMzkzMzk0OH0.65EFjpAfm3JiA53O4fWk21l9DWOaTxXOaQ8zwdGh5Bw/dist/neo4j-etl.jar, org.neo4j.etl.rdbms.Support, jdbc:postgresql://localhost:5433/uomsmd?ssl=false, benmadin, ********'
[2020-10-28 09:12:56.060] [info] Process [3727] exit with code '1', signal 'null'

mroiter-larus · 2020-10-28T13:35:16Z

@benmadin @J-Krush

Thanks for reporting this issue.
We have noticed that when downgrading to a previous version of Neo4j Desktop (1.3.4) this problem does not occur.
We are still investigating.
In the meantime, could you please downgrade to Neo4j Desktop 1.3.4? You can download it here

Thanks!

Mauro

J-Krush · 2020-10-28T14:47:18Z

Thanks a lot for the reply @mroiter-larus. I can confirm that the downgrade to Neo4j Desktop 1.3.4 works.

denis-shemenko · 2020-10-29T20:26:58Z

Greetings Great Graph People ^_^
Just another +1 here.
Same on Windows 10 Pro.
And same workaround with v.1.3.4 Neo4j Desktop works perfectly

Cheers,
Denis

agfagerbakk · 2020-11-02T16:48:02Z

It's the same for Ubuntu 20.04!

Anton

mroiter-larus · 2020-11-05T13:42:33Z

Hi @benmadin @J-Krush @agfagerbakk,

The attached package should solve this issue.
Could you please try it with the latest Neo4j Desktop release and let us know if everything works as expected?

Thanks in advance!

Mauro

neo4j-etl-ui-1.5.0-release.tar.gz

jonaswascheroh · 2020-11-17T08:28:30Z

I have just updated to the latest Desktop release 1.3.11 but I still get the same error.

Jonas

mroiter-larus · 2020-11-17T09:17:40Z

@jonaswascheroh We have not yet released the ETL tool fixed version. In the meantime, could you please install the ETL tool version i shared here?

Thanks,

Mauro

jonaswascheroh · 2020-11-17T10:46:56Z

@mroiter-larus Yes it worked.

Thanks!
Jonas

jonaswascheroh · 2020-11-17T11:21:25Z

@mroiter-larus Not sure if I should rather open a new issue but with the package you provided it seems that no relationships are created.

......
- Creating relationships of type AREA_SERVICE
- Creating relationships of type EMPLOYEE_SERVICES
- Data imported with errors. Below the list of errors.
- For exception NullPointerException we got the following errors:
- 
Process failed null

Do you have any idea what this means?

Jonas

conker84 · 2020-11-17T16:20:37Z

@jonaswascheroh can you open a new issue with the details of your dataset if it's possible?

ShunyangLi · 2020-11-21T05:46:54Z

Hi, I update the desk image and updated etl tools, but it still can not working/

mroiter-larus · 2020-11-23T08:11:23Z

@ShunyangLi Did you use the released version of the ETL tool or the self-builded temporary package provided here?

Thanks,

Mauro

masoudzayyani · 2020-11-30T19:15:43Z

Hi @benmadin @J-Krush @agfagerbakk,

The attached package should solve this issue.
Could you please try it with the latest Neo4j Desktop release and let us know if everything works as expected?

Thanks in advance!

Mauro

neo4j-etl-ui-1.5.0-release.tar.gz

Hi
I have the same error and downloaded this package but I don't know what should I do after downloading it?

benmadin · 2020-12-01T05:05:38Z

Hi there, thank you for your work on this. The process seemed to work much better (connection and mapping, no request for support library...until I pressed the IMPORT DATA button. This is the message I received trying direct import from SQL: COMMAND: java -cp "/Users/********/Library/Application Support/Neo4j Desktop/Application/graphApps/_global/neo4j-etl-ui-1-5-0-release/dist/neo4j-etl.jar" org.neo4j.etl.NeoIntegrationCli export --mapping-file "/var/folders/8c/ynlpm6352t34d3jqrssdzlhm0000gn/T/postgresql_uomsmd_mapping.json" --rdbms:password "" --rdbms:user "********" --rdbms:url "jdbc:postgresql://localhost:5432/uomsmd?ssl=false" --options-file "/var/folders/8c/ynlpm6352t34d3jqrssdzlhm0000gn/T/import-tool-options.json" --using "cypher:fromSQL" --unwind-batch-size 1000 --tx-batch-size 10000 --neo4j:url "bolt://localhost:7687" --neo4j:user "neo4j" --neo4j:password "****" - Illegal command (NullPointerException: null) And trying in batch mode: COMMAND: java -cp "/Users/********/Library/Application Support/Neo4j Desktop/Application/graphApps/_global/neo4j-etl-ui-1-5-0-release/dist/neo4j-etl.jar" org.neo4j.etl.NeoIntegrationCli export --mapping-file "/var/folders/8c/ynlpm6352t34d3jqrssdzlhm0000gn/T/postgresql_uomsmd_mapping.json" --rdbms:password "" --rdbms:user "********" --rdbms:url "jdbc:postgresql://localhost:5432/uomsmd?ssl=false" --csv-directory "/var/folders/8c/ynlpm6352t34d3jqrssdzlhm0000gn/T" --options-file "/var/folders/8c/ynlpm6352t34d3jqrssdzlhm0000gn/T/import-tool-options.json" --using "cypher:batch" --unwind-batch-size 1000 --tx-batch-size 10000 --neo4j:url "bolt://localhost:7687" --neo4j:user "neo4j" --neo4j:password "****" - Illegal command (NullPointerException: null) Somewhere in my rational mind, to have null null pointer exceptions would seem like a good thing :) cheers Ben

…

On Tue, 1 Dec 2020 at 03:16, masoud ***@***.***> wrote: Hi @benmadin <https://github.com/benmadin> @J-Krush <https://github.com/J-Krush> @agfagerbakk <https://github.com/agfagerbakk> , The attached package should solve this issue. Could you please try it with the latest Neo4j Desktop release and let us know if everything works as expected? Thanks in advance! Mauro neo4j-etl-ui-1.5.0-release.tar.gz <https://github.com/neo4j-contrib/neo4j-etl/files/5494702/neo4j-etl-ui-1.5.0-release.tar.gz> Hi I have the same error and downloaded this package but I don't know what should I do after downloading it? — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#75 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAWZIPAQULJPCQGQXZDA26LSSPVPBANCNFSM4TA3VGSA> .

-- [image: Ausvet Logo] <https://www.ausvet.com.au/> Dr Ben Madin BVMS MVPHMgmt PhD MANZCVS GAICD Managing Director Mobile: +61 448 887 220 <+61448887220> E-mail: ben@ausvet.com.au Website: www.ausvet.com.au Skype: benmadin Address: 5 Shuffrey Street Fremantle, WA 6160 Australia

mroiter-larus self-assigned this Oct 28, 2020

jexp closed this as completed Nov 25, 2020

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Error: Could not find or load main class org.neo4j.etl.rdbms.Support #75

Error: Could not find or load main class org.neo4j.etl.rdbms.Support #75

benmadin commented Oct 27, 2020

conker84 commented Oct 27, 2020

J-Krush commented Oct 27, 2020

benmadin commented Oct 28, 2020

mroiter-larus commented Oct 28, 2020

J-Krush commented Oct 28, 2020

denis-shemenko commented Oct 29, 2020 •

edited

Loading

agfagerbakk commented Nov 2, 2020

mroiter-larus commented Nov 5, 2020

jonaswascheroh commented Nov 17, 2020

mroiter-larus commented Nov 17, 2020

jonaswascheroh commented Nov 17, 2020

jonaswascheroh commented Nov 17, 2020

conker84 commented Nov 17, 2020 •

edited

Loading

ShunyangLi commented Nov 21, 2020

mroiter-larus commented Nov 23, 2020

masoudzayyani commented Nov 30, 2020

benmadin commented Dec 1, 2020 via email

Error: Could not find or load main class org.neo4j.etl.rdbms.Support #75

Error: Could not find or load main class org.neo4j.etl.rdbms.Support #75

Comments

benmadin commented Oct 27, 2020

conker84 commented Oct 27, 2020

J-Krush commented Oct 27, 2020

benmadin commented Oct 28, 2020

mroiter-larus commented Oct 28, 2020

J-Krush commented Oct 28, 2020

denis-shemenko commented Oct 29, 2020 • edited Loading

agfagerbakk commented Nov 2, 2020

mroiter-larus commented Nov 5, 2020

jonaswascheroh commented Nov 17, 2020

mroiter-larus commented Nov 17, 2020

jonaswascheroh commented Nov 17, 2020

jonaswascheroh commented Nov 17, 2020

conker84 commented Nov 17, 2020 • edited Loading

ShunyangLi commented Nov 21, 2020

mroiter-larus commented Nov 23, 2020

masoudzayyani commented Nov 30, 2020

benmadin commented Dec 1, 2020 via email

denis-shemenko commented Oct 29, 2020 •

edited

Loading

conker84 commented Nov 17, 2020 •

edited

Loading