# Illegal character in query (While pulling with Briefcase)

**URL:** <https://forum.getodk.org/t/illegal-character-in-query-while-pulling-with-briefcase/21098>\
**Category:** Support\
**Tags:** odk-briefcase\
**Created:** [July 26, 2019, 9:28pm UTC](https://forum.getodk.org/t/illegal-character-in-query-while-pulling-with-briefcase/21098 "2019-07-26T21:28:02Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![PaoloC68](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/paoloc68/32/12477_2.png) [@PaoloC68](https://forum.getodk.org/u/PaoloC68)\
**Post date:** [July 26, 2019, 9:28pm UTC](https://forum.getodk.org/t/illegal-character-in-query-while-pulling-with-briefcase/21098/1 "2019-07-26T21:28:02Z")

</div>

**1. What is the problem? Be very detailed.**  
The problem is that I cannot pull all submissions using Briefcase because of the attachments file names

**2. What app or server are you using and on what device and operating system?.**  
I am using ODK-Briefcase-v1.16.1 with kobocat (kobotoolbox/kobocat:449-chown-media)

**3. What you have you tried to fix the problem?**

I don't know what to do to make so that urls are ulrenconded

**4. What steps can we take to reproduce the problem?**

Simply have that one submission has spaced text attachments.

\*\*5. Anything else we should know or have? \*\*

This one example of the log message:  
`ERROR o.o.b.o.PullFormFromAggregate - Error pulling a form org.opendatakit.briefcase.reused.BriefcaseException: java.net.URISyntaxException: Illegal character in query at index 164: https:/kc.mydomain.com/attachment/original?media_file=shane/attachments/1635d38622564f8aa6c84b24aeca956a/576f1d8f-3896-40a2-bdb0-023a8fa69d74/WhatsApp Image 2019-06-28 at 11.00.27-10_12_3.jpeg`

> **Rest of the log**
>
> `2019-07-26 17:46:14,980 [ForkJoinPool-1-worker-1] ERROR o.o.b.o.PullFormFromAggregate - Error pulling a form org.opendatakit.briefcase.reused.BriefcaseException: java.net.URISyntaxException: Illegal character in query at index 164: https:/kc.mydomain.com/attachment/original?media_file=shane/attachments/1635d38622564f8aa6c84b24aeca956a/576f1d8f-3896-40a2-bdb0-023a8fa69d74/WhatsApp Image 2019-06-28 at 11.00.27-10_12_3.jpeg at org.opendatakit.briefcase.reused.http.Request.asUri(Request.java:86) at org.opendatakit.briefcase.reused.http.CommonsHttp.getCommonsRequest(CommonsHttp.java:142) at org.opendatakit.briefcase.reused.http.CommonsHttp.uncheckedExecute(CommonsHttp.java:101) at org.opendatakit.briefcase.reused.http.CommonsHttp.execute(CommonsHttp.java:86) at org.opendatakit.briefcase.pull.aggregate.PullFromAggregate.downloadSubmissionAttachment(PullFromAggregate.java:298) at org.opendatakit.briefcase.pull.aggregate.PullFromAggregate.lambda$pull$8(PullFromAggregate.java:145) at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:291) at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:731) at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289) at java.util.concurrent.ForkJoinTask.doInvoke(ForkJoinTask.java:401) at java.util.concurrent.ForkJoinTask.invoke(ForkJoinTask.java:734) at java.util.stream.ForEachOps$ForEachOp.evaluateParallel(ForEachOps.java:160) at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateParallel(ForEachOps.java:174) at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:233) at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:583) at org.opendatakit.briefcase.pull.aggregate.PullFromAggregate.lambda$pull$9(PullFromAggregate.java:144) at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184) at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175) at java.util.stream.ReferencePipeline$11$1.accept(ReferencePipeline.java:373) at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382) at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481) at java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:291) at java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:731) at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289) at java.util.concurrent.ForkJoinTask.doInvoke(ForkJoinTask.java:401) at java.util.concurrent.ForkJoinTask.invoke(ForkJoinTask.java:734) at java.util.stream.ForEachOps$ForEachOp.evaluateParallel(ForEachOps.java:160) at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateParallel(ForEachOps.java:174) at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:233) at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418) at org.opendatakit.briefcase.pull.aggregate.PullFromAggregate.lambda$pull$10(PullFromAggregate.java:138) at org.opendatakit.briefcase.util.DatabaseUtils.withDb(DatabaseUtils.java:84) at org.opendatakit.briefcase.pull.aggregate.PullFromAggregate.lambda$pull$11(PullFromAggregate.java:124) at org.opendatakit.briefcase.reused.job.Job.lambda$thenAccept$8(Job.java:134) at org.opendatakit.briefcase.reused.job.JobsRunner.lambda$launchAsync$1(JobsRunner.java:65) at java.util.concurrent.ForkJoinTask$AdaptedRunnableAction.exec(ForkJoinTask.java:1386) at java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:289) at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(ForkJoinPool.java:1056) at java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1692) at java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:157) Caused by: java.net.URISyntaxException: Illegal character in query at index 164: https:/kc.mydomain.com/attachment/original?media_file=shane/attachments/1635d38622564f8aa6c84b24aeca956a/576f1d8f-3896-40a2-bdb0-023a8fa69d74/WhatsApp Image 2019-06-28 at 11.00.27-10_12_3.jpeg at java.net.URI$Parser.fail(URI.java:2848) at java.net.URI$Parser.checkChars(URI.java:3021) at java.net.URI$Parser.parseHierarchical(URI.java:3111) at java.net.URI$Parser.parse(URI.java:3053) at java.net.URI.<init>(URI.java:588) at java.net.URL.toURI(URL.java:946) at org.opendatakit.briefcase.reused.http.Request.asUri(Request.java:84) ... 46 common frames omitted`

---

<div class="post-metadata">

**Author:** ![ggalmazor](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ggalmazor/32/2702_2.png) [@ggalmazor](https://forum.getodk.org/u/ggalmazor)\
**Post date:** [August 1, 2019, 8:09am UTC](https://forum.getodk.org/t/illegal-character-in-query-while-pulling-with-briefcase/21098/2 "2019-08-01T08:09:13Z")

</div>

Welcome to the ODK forum, @PaoloC68! We're glad you're here. When you get a chance, please [introduce yourself on this forum thread](https://forum.getodk.org/t/-/6671). I'd also encourage you to add a real picture as your avatar because it helps build community!

This is a documented problem with Kobo. We filed an issue at [https://github.com/kobotoolbox/kpi/issues/1863](https://github.com/kobotoolbox/kpi/issues/1863) and it looks like it was merged on March but you're experiencing the same problem.
