cannot coerce NULL to LocalDate
head 2020-09-30_sds011_sensor_622.csv
:
sensor_id;sensor_type;location;lat;lon;timestamp;P1;durP1;ratioP1;P2;durP2;ratioP2
622;SDS011;25927;51.03122679;13.73194456;2020-09-30T00:01:44;21.57;;;18.43;;
622;SDS011;25927;51.03122679;13.73194456;2020-09-30T00:04:10;22.80;;;19.27;;
622;SDS011;25927;51.03122679;13.73194456;2020-09-30T00:06:36;21.33;;;19.10;;
622;SDS011;25927;51.03122679;13.73194456;2020-09-30T00:09:02;19.30;;;17.17;;
622;SDS011;25927;51.03122679;13.73194456;2020-09-30T00:11:28;19.30;;;16.80;;
622;SDS011;25927;51.03122679;13.73194456;2020-09-30T00:13:54;17.67;;;15.87;;
622;SDS011;25927;51.03122679;13.73194456;2020-09-30T00:16:20;19.83;;;17.17;;
622;SDS011;25927;51.03122679;13.73194456;2020-09-30T00:18:45;20.30;;;16.13;;
622;SDS011;25927;51.03122679;13.73194456;2020-09-30T00:21:11;19.33;;;16.90;;
SEVERE: sensor https://archive.sensor.community/2020-09-30/2020-09-30_sds011_sensor_622.csv not uploaded because: Cannot coerce NULL to LocalDate
org.neo4j.driver.exceptions.value.Uncoercible: Cannot coerce NULL to LocalDate
at org.neo4j.driver.internal.value.ValueAdapter.asLocalDate(ValueAdapter.java:317)
at sensor2graph.Sensor.request_to_registry(Sensor.java:71)
at sensor2graph.Sensor.register_new_pid(Sensor.java:55)
at sensor2graph.Sensor.process(Sensor.java:41)
at sensor2graph.DayUploader.lambda$make_uploading_task$0(DayUploader.java:47)
at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:271)
at java.base/java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:177)
at java.base/java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:195)
at java.base/java.util.stream.Streams$StreamBuilderImpl.forEachRemaining(Streams.java:411)
at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
at java.base/java.util.stream.ReferencePipeline$7$1.accept(ReferencePipeline.java:274)
at java.base/java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1625)
at java.base/java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:484)
at java.base/java.util.stream.ForEachOps$ForEachTask.compute(ForEachOps.java:290)
at java.base/java.util.concurrent.CountedCompleter.exec(CountedCompleter.java:746)
at java.base/java.util.concurrent.ForkJoinTask.doExec(ForkJoinTask.java:290)
at java.base/java.util.concurrent.ForkJoinPool$WorkQueue.topLevelExec(ForkJoinPool.java:1016)
at java.base/java.util.concurrent.ForkJoinPool.scan(ForkJoinPool.java:1665)
at java.base/java.util.concurrent.ForkJoinPool.runWorker(ForkJoinPool.java:1598)
at java.base/java.util.concurrent.ForkJoinWorkerThread.run(ForkJoinWorkerThread.java:183)
needs to be investigated