# SPARQL LOAD from a file gets 000012 error

**URL:** <https://community.stardog.com/t/sparql-load-from-a-file-gets-000012-error/3737>\
**Category:** Support\
**Created:** [May 13, 2022, 8:01pm UTC](https://community.stardog.com/t/sparql-load-from-a-file-gets-000012-error/3737 "2022-05-13T20:01:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![arwesterinen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/arwesterinen/32/40_2.png) [@arwesterinen](https://community.stardog.com/u/arwesterinen)\
**Post date:** [May 13, 2022, 8:01pm UTC](https://community.stardog.com/t/sparql-load-from-a-file-gets-000012-error/3737/1 "2022-05-13T20:01:26Z")

</div>

When I try to do a LOAD, e.g.:  
`LOAD <file:///Users/andreaw/Documents/tests/manifest.ttl> INTO GRAPH <tests>`

It fails. The stack trace implies that it is always using the HTTP client, but the file reference is a valid authority (and Stardog acknowledges this).

Is this a bug or am I misunderstanding something?

Andrea

---

<div class="post-metadata">

**Author:** ![arwesterinen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/arwesterinen/32/40_2.png) [@arwesterinen](https://community.stardog.com/u/arwesterinen)\
**Post date:** [May 13, 2022, 8:04pm UTC](https://community.stardog.com/t/sparql-load-from-a-file-gets-000012-error/3737/2 "2022-05-13T20:04:29Z")

</div>

The stack trace is:  
The detailed stack trace for the error is:  
com.complexible.stardog.cli.CliException: com.complexible.stardog.plan.eval.ExecutionException: /Users/andreaw/Documents/TFTtests/rdf-tests/sparql11/data-sparql11/property-path/manifest.ttl  
at com.complexible.stardog.cli.impl.ConnectionCommand.call(ConnectionCommand.java:87)  
at com.complexible.stardog.cli.CLIBase.execute(CLIBase.java:56)  
at com.complexible.stardog.cli.CLI.main(CLI.java:121)  
Caused by: com.complexible.stardog.protocols.http.client.BaseHttpClient$HttpClientException: com.complexible.stardog.plan.eval.ExecutionException: /Users/andreaw/Documents/TFTtests/rdf-tests/sparql11/data-sparql11/property-path/manifest.ttl  
at com.complexible.stardog.protocols.http.client.BaseHttpClient.errorCodeToException(BaseHttpClient.java:568)  
at com.complexible.stardog.protocols.http.client.BaseHttpClient.checkResponseCode(BaseHttpClient.java:525)  
at com.complexible.stardog.protocols.http.client.BaseHttpClient.execute(BaseHttpClient.java:387)  
at com.complexible.stardog.protocols.http.client.HttpClientImpl.update(HttpClientImpl.java:313)  
at com.complexible.stardog.protocols.http.client.HttpConnection.\_update(HttpConnection.java:228)  
at com.complexible.stardog.api.impl.AbstractConnection.executeUpdate(AbstractConnection.java:502)  
at com.complexible.stardog.api.impl.UpdateQueryImpl.execute(UpdateQueryImpl.java:42)  
at com.complexible.stardog.api.impl.UpdateQueryImpl.execute(UpdateQueryImpl.java:22)  
at com.complexible.stardog.cli.impl.QueryWithOutput.writeOutput(QueryWithOutput.java:149)  
at com.complexible.stardog.cli.impl.Query.execute(Query.java:90)  
at com.complexible.stardog.cli.impl.ConnectionCommand.execute(ConnectionCommand.java:95)  
at com.complexible.stardog.cli.impl.ConnectionCommand.call(ConnectionCommand.java:75)  
... 2 more  
Caused by: com.complexible.stardog.StardogException: com.complexible.stardog.plan.eval.ExecutionException: /Users/andreaw/Documents/TFTtests/rdf-tests/sparql11/data-sparql11/property-path/manifest.ttl  
at com.complexible.stardog.ErrorCodes.parseToThrowable(ErrorCodes.java:59)  
at com.complexible.stardog.protocols.http.client.BaseHttpClient.errorCodeToException(BaseHttpClient.java:553)  
... 13 more

---

<div class="post-metadata">

**Author:** ![zachary.whitley](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/zachary.whitley/32/94_2.png) [@zachary.whitley](https://community.stardog.com/u/zachary.whitley)\
**Post date:** [May 14, 2022, 1:34am UTC](https://community.stardog.com/t/sparql-load-from-a-file-gets-000012-error/3737/3 "2022-05-14T01:34:57Z")

</div>

The entire query is sent to the server and the file is dereferenced there so it’s looking for that file on the server and I’m guessing from the file path it’s on your client. If the server and client are running on the same machine it would need to be accessible by the user that the server is running as. You can try copying the file into /tmp and changing the owner and/or permissions.

The error doesn’t seem ideal but it’s from the cli so the real cause might be obscured. You’ll probably get a better idea of what the real cause is by looking at the server logs.

---

<div class="post-metadata">

**Author:** ![arwesterinen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/arwesterinen/32/40_2.png) [@arwesterinen](https://community.stardog.com/u/arwesterinen)\
**Post date:** [May 17, 2022, 3:44am UTC](https://community.stardog.com/t/sparql-load-from-a-file-gets-000012-error/3737/4 "2022-05-17T03:44:22Z")

</div>

I ended up modifying the code to LOAD files from an HTTPS address.

Thanks for the help.

Andrea
