Problem With exporting data from Briefcase

1. What is the problem? Be very detailed.
While exporting data from briefcase i am getting following error in briefcase log and empty CSV and briefcase stops at 99%.
2020-06-01 11:27:05,553 [ForkJoinPool-3-worker-1] ERROR o.o.briefcase.reused.job.JobsRunner - Error running Job
java.io.UncheckedIOException: java.nio.charset.MalformedInputException: Input length = 1
at java.io.BufferedReader$1.hasNext(Unknown Source)
at java.util.Iterator.forEachRemaining(Unknown Source)
at java.util.Spliterators$IteratorSpliterator.forEachRemaining(Unknown Source)
at java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(Unknown Source)
at java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.util.stream.ReferencePipeline.collect(Unknown Source)
at org.opendatakit.briefcase.export.CsvFieldMappers.aggregatedAuditFile(CsvFieldMappers.java:325)
at org.opendatakit.briefcase.export.CsvFieldMappers.lambda$null$2(CsvFieldMappers.java:74)
at java.util.Optional.map(Unknown Source)
at org.opendatakit.briefcase.export.CsvFieldMappers.lambda$static$3(CsvFieldMappers.java:74)
at org.opendatakit.briefcase.export.CsvFieldMapper.lambda$compose$0(CsvFieldMapper.java:66)
at org.opendatakit.briefcase.export.CsvFieldMapper.lambda$decorateOutput$1(CsvFieldMapper.java:76)
at org.opendatakit.briefcase.export.SplitSelectMultiples.lambda$decorate$1(SplitSelectMultiples.java:30)
at org.opendatakit.briefcase.export.CsvFieldMappers.lambda$nonRepeatableGroup$19(CsvFieldMappers.java:344)
at java.util.stream.ReferencePipeline$7$1.accept(Unknown Source)
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(Unknown Source)
at java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(Unknown Source)
at java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.util.stream.ReferencePipeline.collect(Unknown Source)
at org.opendatakit.briefcase.export.SplitSelectMultiples.lambda$decorate$1(SplitSelectMultiples.java:30)
at org.opendatakit.briefcase.export.CsvSubmissionMappers.lambda$null$1(CsvSubmissionMappers.java:55)
at java.util.stream.ReferencePipeline$7$1.accept(Unknown Source)
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(Unknown Source)
at java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(Unknown Source)
at java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.util.stream.ReferencePipeline.collect(Unknown Source)
at org.opendatakit.briefcase.export.CsvSubmissionMappers.lambda$main$2(CsvSubmissionMappers.java:62)
at org.opendatakit.briefcase.export.ExportToCsv.lambda$null$3(ExportToCsv.java:109)
at java.util.stream.ReferencePipeline$3$1.accept(Unknown Source)
at java.util.stream.ReferencePipeline$3$1.accept(Unknown Source)
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(Unknown Source)
at java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.util.stream.AbstractPipeline.wrapAndCopyInto(Unknown Source)
at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(Unknown Source)
at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(Unknown Source)
at java.util.stream.AbstractPipeline.evaluate(Unknown Source)
at java.util.stream.ReferencePipeline.forEach(Unknown Source)
at java.util.stream.ReferencePipeline$7$1.accept(Unknown Source)
at java.util.stream.ReferencePipeline$11$1.accept(Unknown Source)
at java.util.stream.ReferencePipeline$2$1.accept(Unknown Source)
at java.util.stream.ReferencePipeline$3$1.accept(Unknown Source)
at java.util.stream.ReferencePipeline$2$1.accept(Unknown Source)
at java.util.stream.ReferencePipeline$3$1.accept(Unknown Source)
at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(Unknown Source)
at java.util.stream.AbstractPipeline.copyInto(Unknown Source)
at java.util.stream.ForEachOps$ForEachTask.compute(Unknown Source)
at java.util.concurrent.CountedCompleter.exec(Unknown Source)
at java.util.concurrent.ForkJoinTask.doExec(Unknown Source)
at java.util.concurrent.ForkJoinPool$WorkQueue.execLocalTasks(Unknown Source)
at java.util.concurrent.ForkJoinPool$WorkQueue.runTask(Unknown Source)
at java.util.concurrent.ForkJoinPool.runWorker(Unknown Source)
at java.util.concurrent.ForkJoinWorkerThread.run(Unknown Source)
Caused by: java.nio.charset.MalformedInputException: Input length = 1
at java.nio.charset.CoderResult.throwException(Unknown Source)
at sun.nio.cs.StreamDecoder.implRead(Unknown Source)
at sun.nio.cs.StreamDecoder.read(Unknown Source)
at java.io.InputStreamReader.read(Unknown Source)
at java.io.BufferedReader.fill(Unknown Source)
at java.io.BufferedReader.readLine(Unknown Source)
at java.io.BufferedReader.readLine(Unknown Source)
... 58 common frames omitted

2. What app or server are you using and on what device and operating system? Include version numbers.
using briefcase 17.x

3. What you have you tried to fix the problem?
The problem occur in only one survey form. other survey forms from same aggregate and briefcase version work fine. I tried by re-downloading but doesn't work.

using briefcase version 11.2, successfully able to export it.

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

5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.

Hi @umesh
could you attache the form that causes the problem?

Thank your for your interest. Actually the form was working well some time before. I used to download and export it from briefcase while survey is ongoing. Now survey is finished and i downloaded all the instance and then the problem arise. I think there is one instance that causing problem while exporting. The above error in log appears when exports reaches about 50%. If we could figure out which instance causing problem and removing it from briefcase manually may solve the problem.

Currently i dont have access to xlsx form due to covid-19 lock down But i have xml form which i attached with it.Haripur_HH_Survey_v1.xml (391.2 KB)

First of all could you try the latest ODK Briefcase version? It's v1.17.4 and you said that you are using v1.11.2.

Good day!

I was able to run the collect, however how could i remove the version like Collect v1.26?
thank you

what do you mean? I asked you to try the newest version of briefcase not ODK Collect.

Yes, i used briefcase v1.17.4 to download data from the cloud and tried to export it and i got the above mention problem. Then tried to export with v1.11.2 and it export well. but the export is missing the feature that offer v1.17.x like remove group name, separated multiple answer.

1 Like

There must be something wrong in one of your audit files attached to that form. Could you maybe share all saved instances of that form as well?