# Problem with Export cvs in S3 (apoc.export.csv.query)

**URL:** <https://community.neo4j.com/t/problem-with-export-cvs-in-s3-apoc-export-csv-query/37592>\
**Category:** Neo4j Graph Platform\
**Tags:** apoc, cypher, operations, export, import, plugin\
**Created:** [April 29, 2021, 2:25pm UTC](https://community.neo4j.com/t/problem-with-export-cvs-in-s3-apoc-export-csv-query/37592 "2021-04-29T14:25:53Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![antoniobruno80](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/antoniobruno80/32/9313_2.png) [@antoniobruno80](https://community.neo4j.com/u/antoniobruno80)\
**Post date:** [April 29, 2021, 2:25pm UTC](https://community.neo4j.com/t/problem-with-export-cvs-in-s3-apoc-export-csv-query/37592/1 "2021-04-29T14:25:54Z")

</div>

Hello,  
I'm trying to export to Amazon S3 as indicated in the documentation as follows:

CALL apoc.export.csv.query(  
"MATCH (a:Person) RETURN a.name",  
"s3://s3.eu-west-1.amazonaws.com/\<BUCKET\_NAME\>/example.csv?accessKey=\<MY\_ACCESS\_KEY\>&secretKey=\<MY\_SECRET\_KEY\>",  
{}  
)

I always get a error:

Neo.ClientError.Procedure.ProcedureCallFailed  
Failed to invoke procedure `apoc.export.csv.query`:  
Caused by: java.io.FileNotFoundException: s3:/s3-eu-west-1.amazonaws.com/\<BUCKET\_NAME\>/example.csv?accessKey=\<MY\_ACCESS\_KEY\>&secretKey=\<MY\_SECRET\_KEY\> (No such file or directory)

I get the same error both by running the export command from the Neo4j Web Browser client, and by running a post directly on the endpoint [http://ipserver:7474/db/data/transaction/commit](http://ipserver:7474/db/data/transaction/commit)

The configurations are:

- neo4j version: "Neo4j Kernel 3.2.6 enterprise",
- browser version: 3.0.10
- plugins:  
apoc-3.2.3.6-all.jar  
aws-java-sdk-core-1.11.250.jar  
aws-java-sdk-s3-1.11.250.jar  
httpclient-4.5.4.jar  
httpcore-4.4.8.jar  
joda-time-2.9.9.jar

In neo4j.conf there are these entries:  
dbms.active\_database=graph  
dbms.directories.plugins=plugins  
unsupported.dbms.executiontime\_limit.enabled=false  
dbms.allow\_format\_migration=true  
dbms.memory.heap.initial\_size=8g  
dbms.memory.heap.max\_size=8g  
dbms.memory.pagecache.size=5g  
dbms.connector.bolt.enabled=true  
dbms.connector.bolt.tls\_level=DISABLED  
dbms.connector.bolt.listen\_address=0.0.0.0:7687  
dbms.connector.http.enabled=true  
dbms.connector.http.listen\_address=0.0.0.0:7474  
dbms.connector.https.enabled=true  
dbms.directories.certificates and associated files  
dbms.logs.debug.rotation.size=1m  
dbms.logs.query.enabled=false  
dbms.logs.query.threshold=200s  
dbms.logs.query.rotation.size=1m  
dbms.logs.security.rotation.delay=300s  
ha.pull\_interval=10  
ha.heartbeat\_timeout=40s  
dbms.tx\_log.rotation.retention\_policy=false  
dbms.shell.enabled=true  
dbms.jvm.additional=-XX:+UseG1GC  
dbms.jvm.additional=-XX:-OmitStackTraceInFastThrow  
dbms.jvm.additional=-XX:+AlwaysPreTouch  
dbms.jvm.additional=-XX:+UnlockExperimentalVMOptions  
dbms.jvm.additional=-XX:+TrustFinalNonStaticFields  
dbms.jvm.additional=-XX:+DisableExplicitGC  
dbms.jvm.additional=-Djdk.tls.ephemeralDHKeySize=2048  
dbms.windows\_service\_name=neo4j  
dbms.jvm.additional=-Dunsupported.dbms.udc.source=tarball  
dbms.security.procedures.unrestricted=apoc._,algo._  
dbms.security.procedures.whitelist=apoc._,algo._  
dbms.security.allow\_csv\_import\_from\_file\_urls=true  
apoc.import.file.use\_neo4j\_config=false  
apoc.import.file.enabled=true  
apoc.export.file.enabled=true

Can you tell me what the problem could be?

Thank you  
Antonio Bruno

---

<div class="post-metadata">

**Author:** ![michael.hunger](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/michael.hunger/32/27377_2.png) [@michael.hunger](https://community.neo4j.com/u/michael.hunger)\
**Post date:** [April 29, 2021, 8:04pm UTC](https://community.neo4j.com/t/problem-with-export-cvs-in-s3-apoc-export-csv-query/37592/2 "2021-04-29T20:04:48Z")

</div>

Can you share your debug.log I would like to see if the URL handler for s3 files was installed correctly.

---

<div class="post-metadata">

**Author:** ![antoniobruno80](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/antoniobruno80/32/9313_2.png) [@antoniobruno80](https://community.neo4j.com/u/antoniobruno80)\
**Post date:** [April 29, 2021, 8:52pm UTC](https://community.neo4j.com/t/problem-with-export-cvs-in-s3-apoc-export-csv-query/37592/3 "2021-04-29T20:52:47Z")

</div>

Hello,  
there he is

[debug-log.txt](https://community.neo4j.com/uploads/short-url/1Id0PPu1zdktsyvyhpYMxkH2vp6.txt) (95.3 KB)

thank you  
Antonio Bruno

---

<div class="post-metadata">

**Author:** ![antoniobruno80](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/antoniobruno80/32/9313_2.png) [@antoniobruno80](https://community.neo4j.com/u/antoniobruno80)\
**Post date:** [April 30, 2021, 7:20am UTC](https://community.neo4j.com/t/problem-with-export-cvs-in-s3-apoc-export-csv-query/37592/4 "2021-04-30T07:20:44Z")

</div>

Actually in the log there are WARNs for some classes that are not loaded but I don't understand why?

...  
2021-04-29 20:33:45.669+0000 WARN [o.n.k.i.p.Procedures] Failed to load `com.amazonaws.services.s3.AmazonS3EncryptionClient` from plugin jar `/opt/neo4j/3.2.6/plugins/aws-java-sdk-s3-1.11.250.jar`: com/amazonaws/services/kms/AWSKMS  
2021-04-29 20:33:45.676+0000 WARN [o.n.k.i.p.Procedures] Failed to load `com.amazonaws.services.s3.AmazonS3EncryptionClientBuilder` from plugin jar `/opt/neo4j/3.2.6/plugins/aws-java-sdk-s3-1.11.250.jar`: com/amazonaws/services/kms/AWSKMS  
2021-04-29 20:33:45.678+0000 WARN [o.n.k.i.p.Procedures] Failed to load `com.amazonaws.services.s3.AmazonS3EncryptionClientParamsWrapper` from plugin jar `/opt/neo4j/3.2.6/plugins/aws-java-sdk-s3-1.11.250.jar`: com/amazonaws/services/kms/AWSKMS  
2021-04-29 20:33:45.679+0000 WARN [o.n.k.i.p.Procedures] Failed to load `com.amazonaws.services.s3.AmazonS3EncryptionClientParams` from plugin jar `/opt/neo4j/3.2.6/plugins/aws-java-sdk-s3-1.11.250.jar`: com/amazonaws/services/kms/AWSKMS  
2021-04-29 20:33:45.789+0000 WARN [o.n.k.i.p.Procedures] Failed to load `com.amazonaws.services.s3.internal.crypto.ContentCryptoMaterial` from plugin jar `/opt/neo4j/3.2.6/plugins/aws-java-sdk-s3-1.11.250.jar`: com/amazonaws/services/kms/AWSKMS  
...
