search

neo4j-contrib / neo4j-etl

Data import from relational databases to Neo4j.
https://neo4j.com/developer/neo4j-etl/
Other
215 stars 46 forks source link

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

Closed benmadin closed 3 years ago

benmadin commented 3 years ago

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 commented 3 years ago

can you share a screenshot of the error?

J-Krush commented 3 years ago

I am getting the same error.

Using:

Screenshot below:

Screen Shot 2020-10-27 at 2 48 09 PM
benmadin commented 3 years ago

I am getting the same error.

Using:

  • Neo4j Desktop Version: 1.3.9
  • Neo4j Instance: 4.0.4-enterprise

Screenshot below:

Screen Shot 2020-10-27 at 2 48 09 PM

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 commented 3 years ago

@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 commented 3 years ago

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

denis-shemenko commented 3 years ago

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 commented 3 years ago

It's the same for Ubuntu 20.04!

Anton

mroiter-larus commented 3 years ago

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 commented 3 years ago

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

Jonas

mroiter-larus commented 3 years ago

@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 commented 3 years ago

@mroiter-larus Yes it worked.

Thanks! Jonas

jonaswascheroh commented 3 years ago

@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 commented 3 years ago

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

ShunyangLi commented 3 years ago

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

mroiter-larus commented 3 years ago

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

Thanks,

Mauro

masoudzayyani commented 3 years ago

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 commented 3 years ago

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 "****"

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 "****"

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 notifications@github.com 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 https://github.com/neo4j-contrib/neo4j-etl/issues/75#issuecomment-735986310, 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