Unable to add apoc-xls-dependencies-4.3.0.12.jar

Neo4j Graph Platform Procedures & APOC
1

Dear people,

using windows 10,
neo4j desktop 1.5.8

I'm trying to use
apoc.export.xls.query (or else).
I downloaded from here https://neo4j.com/labs/apoc/4.3/overview/apoc.export/apoc.export.xls.query/ either files the apocxls.jar or the poi.jar . Put them in the same plugin directory as the apoc5plus.jar file .

1 - the DB won't load if the apoc xls file is present in the directory
2 - the DB loads with the poi . jar present in the directory, but the apoc.export.xls.query procedure doesn't show up when calling SHOW Procedures .

I can mention that any time I edited the neo4j.conf file, the DB won't start, I believe for the same reasons.

Here's the log when trying to start the db with apoc xls jar in the plugin directory.
https://ufile.io/eed8sqxl

Apart from that apoc.export.csv.query works fine .

so two questions :

  • why does the neo4j.conf file modification stop the db to start
  • why does putting a jar file in the plugin directory stop the db to start ?

greets
O

2

The neo4j.conf file is validated during startup, so erroneous entries will cause the startup process to start.

The version of apoc is verified to match the version of neo4j at startup, so a combination of incompatible versions will cause the startup process to stop.

Not sure is either or both are the cause of your issues. Have you reviewed the logs?

3

hello glenn, thanks a lot :

here's the log, not sure what other log i could share :

[2023-07-07 09:33:28.595] [info] Retrieving status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]
[2023-07-07 09:33:28.606] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: false
[2023-07-07 09:33:28.636] [info] Checking ports
[2023-07-07 09:33:28.781] [info] Starting Neo4j
[2023-07-07 09:33:28.782] [info] Starting DBMS [database-62ca955e-4895-47d8-a5f4-22de2eeb20b4] 'v5.3.0'
[2023-07-07 09:33:28.808] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: true
[2023-07-07 09:33:28.813] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7687 }
[2023-07-07 09:33:28.814] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7474 }
[2023-07-07 09:33:28.818] [info] Neo4j @ 7687 is down. connect ECONNREFUSED 127.0.0.1:7687
[2023-07-07 09:33:28.819] [info] Neo4j @ 7474 is down. connect ECONNREFUSED 127.0.0.1:7474
[2023-07-07 09:33:29.841] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: true
[2023-07-07 09:33:29.845] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7687 }
[2023-07-07 09:33:29.846] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7474 }
[2023-07-07 09:33:29.849] [info] Neo4j @ 7687 is down. connect ECONNREFUSED 127.0.0.1:7687
[2023-07-07 09:33:29.850] [info] Neo4j @ 7474 is down. connect ECONNREFUSED 127.0.0.1:7474
[2023-07-07 09:33:30.866] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: true
[2023-07-07 09:33:30.869] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7687 }
[2023-07-07 09:33:30.870] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7474 }
[2023-07-07 09:33:30.873] [info] Neo4j @ 7687 is down. connect ECONNREFUSED 127.0.0.1:7687
[2023-07-07 09:33:30.874] [info] Neo4j @ 7474 is down. connect ECONNREFUSED 127.0.0.1:7474
[2023-07-07 09:33:31.890] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: true
[2023-07-07 09:33:31.895] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7687 }
[2023-07-07 09:33:31.896] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7474 }
[2023-07-07 09:33:31.899] [info] Neo4j @ 7687 is down. connect ECONNREFUSED 127.0.0.1:7687
[2023-07-07 09:33:31.899] [info] Neo4j @ 7474 is down. connect ECONNREFUSED 127.0.0.1:7474
[2023-07-07 09:33:32.916] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: true
[2023-07-07 09:33:32.918] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7687 }
[2023-07-07 09:33:32.919] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7474 }
[2023-07-07 09:33:32.922] [info] Neo4j @ 7687 is down. connect ECONNREFUSED 127.0.0.1:7687
[2023-07-07 09:33:32.923] [info] Neo4j @ 7474 is down. connect ECONNREFUSED 127.0.0.1:7474
[2023-07-07 09:33:33.942] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: true
[2023-07-07 09:33:33.945] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7687 }
[2023-07-07 09:33:33.946] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7474 }
[2023-07-07 09:33:33.948] [info] Neo4j @ 7687 is down. connect ECONNREFUSED 127.0.0.1:7687
[2023-07-07 09:33:33.949] [info] Neo4j @ 7474 is down. connect ECONNREFUSED 127.0.0.1:7474
[2023-07-07 09:33:35.027] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: true
[2023-07-07 09:33:35.030] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7687 }
[2023-07-07 09:33:35.031] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7474 }
[2023-07-07 09:33:35.034] [info] Neo4j @ 7687 is down. connect ECONNREFUSED 127.0.0.1:7687
[2023-07-07 09:33:35.035] [info] Neo4j @ 7474 is down. connect ECONNREFUSED 127.0.0.1:7474
[2023-07-07 09:33:36.070] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: true
[2023-07-07 09:33:36.076] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7687 }
[2023-07-07 09:33:36.077] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7474 }
[2023-07-07 09:33:36.082] [info] Neo4j @ 7687 is down. connect ECONNREFUSED 127.0.0.1:7687
[2023-07-07 09:33:36.083] [info] Neo4j @ 7474 is down. connect ECONNREFUSED 127.0.0.1:7474
[2023-07-07 09:33:37.101] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: true
[2023-07-07 09:33:37.107] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7687 }
[2023-07-07 09:33:37.108] [info] Check if neo4j is available on { host: '127.0.0.1', path: '/', port: 7474 }
[2023-07-07 09:33:37.110] [info] Neo4j @ 7687 is down. connect ECONNREFUSED 127.0.0.1:7687
[2023-07-07 09:33:37.111] [info] Neo4j @ 7474 is down. connect ECONNREFUSED 127.0.0.1:7474
[2023-07-07 09:33:38.133] [info] Retrieved status for DBMS[database-62ca955e-4895-47d8-a5f4-22de2eeb20b4]: false

note : when no xls jar file is located into the plugin directory everything works fine.

About the neo4j.conf, I don't know about erroneous entries. That could be the case, but whenI tried it (several times), I'm just adding at the end, the mentionned entries

here the documentation about the xls jar :
These dependencies are included in apoc-xls-dependencies-4.4.0.19.jar, which can be downloaded from the releases page. Once that file is downloaded, it should be placed in the plugins directory and the Neo4j Server restarted.

here the apoc.conf : apoc.export.file.enabled=true

(note : adding the line to the neo4j.conf file made the db to crash, so I had to create the apoc.conf filE.)

greets

4

which version of Neo4j are you using, as the apoc version has to be compatible. I believe the rule is that the first two version digits have to be the same. I believe this was implemented somewhere in version 4 release train.

I would suggest the debug.log and the neo4j.log.