search

rufuspollock-okfn / reconcile-csv

A simple OpenRefine reconciliation service that runs on top of a CSV file
BSD 2-Clause "Simplified" License
117 stars 28 forks source link

Error running Version 0.1.2 on Windows #44

Open llewmihs opened 1 year ago

llewmihs commented 1 year ago

I'm running OpenRefine Version 3.8-SNAPSHOT [4d7571d], and Reconciler Version 0.1.2 downloaded from (http://okfnlabs.org/reconcile-csv/). When linking the reconciler to OpenRefine, I am receiving the following error:

Guess Types query failed error : java.io.IOException: HTTP error 500 : Server Error for URL /reconcile as a pop up window.

The output in my shell is as follows:


Point refine to http://localhost:8000/ as reconciliation service
2023-05-24 14:03:53.470:INFO:oejs.Server:jetty-7.x.y-SNAPSHOT
2023-05-24 14:03:53.789:INFO:oejs.AbstractConnector:Started [SelectChannelConnector@0.0.0.0:8000](mailto:SelectChannelConnector@0.0.0.0:8000)
2023-05-24 14:04:15.869:WARN:oejs.AbstractHttpConnection:/reconcile
java.util.concurrent.ExecutionException: java.lang.NullPointerException
        at java.util.concurrent.FutureTask.report(Unknown Source)
        at java.util.concurrent.FutureTask.get(Unknown Source)
        at clojure.core$deref_future.invoke(core.clj:2108)
        at clojure.core$future_call$reify__6267.deref(core.clj:6308)
        at clojure.core$deref.invoke(core.clj:2128)
        at clojure.core$map$fn__4207.invoke(core.clj:2487)
        at clojure.lang.LazySeq.sval(LazySeq.java:42)
        at clojure.lang.LazySeq.seq(LazySeq.java:67)
        at clojure.lang.RT.seq(RT.java:484)
        at clojure.core$seq.invoke(core.clj:133)
        at clojure.core$zipmap.invoke(core.clj:2713)
        at reconcile_csv.core$reconcile_params.invoke(core.clj:130)
        at reconcile_csv.core$reconcile.invoke(core.clj:140)
        at reconcile_csv.core$fn__2664.invoke(core.clj:225)
        at compojure.core$make_route$fn__534.invoke(core.clj:94)
        at compojure.core$if_route$fn__522.invoke(core.clj:40)
        at compojure.core$if_method$fn__515.invoke(core.clj:25)
        at compojure.core$routing$fn__540.invoke(core.clj:107)
        at clojure.core$some.invoke(core.clj:2443)
        at compojure.core$routing.doInvoke(core.clj:107)
        at clojure.lang.RestFn.applyTo(RestFn.java:139)
        at clojure.core$apply.invoke(core.clj:619)
        at compojure.core$routes$fn__544.invoke(core.clj:112)
        at ring.middleware.keyword_params$wrap_keyword_params$fn__1341.invoke(keyword_params.clj:32)
        at ring.middleware.nested_params$wrap_nested_params$fn__1383.invoke(nested_params.clj:70)
        at ring.middleware.params$wrap_params$fn__205.invoke(params.clj:58)
        at ring.adapter.jetty$proxy_handler$fn__81.invoke(jetty.clj:18)
        at ring.adapter.jetty.proxy$org.eclipse.jetty.server.handler.AbstractHandler$0.handle(Unknown Source)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
        at org.eclipse.jetty.server.Server.handle(Server.java:363)
        at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483)
        at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:931)
        at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:992)
        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
        at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
        at java.lang.Thread.run(Unknown Source)
Caused by:
java.lang.NullPointerException
        at fuzzy_string.core$bigrams.invoke(core.clj:8)
        at clojure.lang.AFn.applyToHelper(AFn.java:161)
        at clojure.lang.AFn.applyTo(AFn.java:151)
        at clojure.core$apply.invoke(core.clj:617)
        at clojure.core$memoize$fn__5049.doInvoke(core.clj:5735)
        at clojure.lang.RestFn.invoke(RestFn.java:408)
        at fuzzy_string.core$dice.invoke(core.clj:20)
        at reconcile_csv.core$score$fuzzy_match__2621.invoke(core.clj:76)
        at clojure.core$map$fn__4207.invoke(core.clj:2487)
        at clojure.lang.LazySeq.sval(LazySeq.java:42)
        at clojure.lang.LazySeq.seq(LazySeq.java:60)
        at clojure.lang.RT.seq(RT.java:484)
        at clojure.core$seq.invoke(core.clj:133)
        at clojure.core.protocols$seq_reduce.invoke(protocols.clj:26)
        at clojure.core.protocols$fn__6026.invoke(protocols.clj:53)
        at clojure.core.protocols$fn__5979$G__5974__5992.invoke(protocols.clj:13)
        at clojure.core$reduce.invoke(core.clj:6175)
        at reconcile_csv.core$score.invoke(core.clj:78)
        at clojure.lang.AFn.applyToHelper(AFn.java:163)
        at clojure.lang.AFn.applyTo(AFn.java:151)
        at clojure.core$apply.invoke(core.clj:619)
        at clojure.core$partial$fn__4190.doInvoke(core.clj:2396)
        at clojure.lang.RestFn.invoke(RestFn.java:408)
        at clojure.core$map$fn__4207.invoke(core.clj:2487)
        at clojure.lang.LazySeq.sval(LazySeq.java:42)
        at clojure.lang.LazySeq.seq(LazySeq.java:60)
        at clojure.lang.RT.seq(RT.java:484)
        at clojure.core$seq.invoke(core.clj:133)
        at clojure.core$sort.invoke(core.clj:2752)
        at clojure.core$sort_by.invoke(core.clj:2769)
        at clojure.core$sort_by.invoke(core.clj:2767)
        at reconcile_csv.core$scores.invoke(core.clj:111)
        at reconcile_csv.core$reconcile_param.invoke(core.clj:123)
        at clojure.core$pmap$fn__6275$fn__6276.invoke(core.clj:6354)
        at clojure.core$binding_conveyor_fn$fn__4107.invoke(core.clj:1836)
        at clojure.lang.AFn.call(AFn.java:18)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)
2023-05-24 14:04:27.777:WARN:oejs.AbstractHttpConnection:/reconcile
java.util.concurrent.ExecutionException: java.lang.NullPointerException
        at java.util.concurrent.FutureTask.report(Unknown Source)
        at java.util.concurrent.FutureTask.get(Unknown Source)
        at clojure.core$deref_future.invoke(core.clj:2108)
        at clojure.core$future_call$reify__6267.deref(core.clj:6308)
        at clojure.core$deref.invoke(core.clj:2128)
        at clojure.core$map$fn__4207.invoke(core.clj:2487)
        at clojure.lang.LazySeq.sval(LazySeq.java:42)
        at clojure.lang.LazySeq.seq(LazySeq.java:67)
        at clojure.lang.RT.seq(RT.java:484)
        at clojure.core$seq.invoke(core.clj:133)
        at clojure.core$zipmap.invoke(core.clj:2713)
        at reconcile_csv.core$reconcile_params.invoke(core.clj:130)
        at reconcile_csv.core$reconcile.invoke(core.clj:140)
        at reconcile_csv.core$fn__2664.invoke(core.clj:225)
        at compojure.core$make_route$fn__534.invoke(core.clj:94)
        at compojure.core$if_route$fn__522.invoke(core.clj:40)
        at compojure.core$if_method$fn__515.invoke(core.clj:25)
        at compojure.core$routing$fn__540.invoke(core.clj:107)
        at clojure.core$some.invoke(core.clj:2443)
        at compojure.core$routing.doInvoke(core.clj:107)
        at clojure.lang.RestFn.applyTo(RestFn.java:139)
        at clojure.core$apply.invoke(core.clj:619)
        at compojure.core$routes$fn__544.invoke(core.clj:112)
        at ring.middleware.keyword_params$wrap_keyword_params$fn__1341.invoke(keyword_params.clj:32)
        at ring.middleware.nested_params$wrap_nested_params$fn__1383.invoke(nested_params.clj:70)
        at ring.middleware.params$wrap_params$fn__205.invoke(params.clj:58)
        at ring.adapter.jetty$proxy_handler$fn__81.invoke(jetty.clj:18)
        at ring.adapter.jetty.proxy$org.eclipse.jetty.server.handler.AbstractHandler$0.handle(Unknown Source)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
        at org.eclipse.jetty.server.Server.handle(Server.java:363)
        at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:483)
        at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:931)
        at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:992)
        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:240)
        at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
        at java.lang.Thread.run(Unknown Source)
Caused by:
java.lang.NullPointerException
        at fuzzy_string.core$bigrams.invoke(core.clj:8)
        at clojure.lang.AFn.applyToHelper(AFn.java:161)
        at clojure.lang.AFn.applyTo(AFn.java:151)
        at clojure.core$apply.invoke(core.clj:617)
        at clojure.core$memoize$fn__5049.doInvoke(core.clj:5735)
        at clojure.lang.RestFn.invoke(RestFn.java:408)
        at fuzzy_string.core$dice.invoke(core.clj:20)
        at reconcile_csv.core$score$fuzzy_match__2621.invoke(core.clj:76)
        at clojure.core$map$fn__4207.invoke(core.clj:2487)
        at clojure.lang.LazySeq.sval(LazySeq.java:42)
        at clojure.lang.LazySeq.seq(LazySeq.java:60)
        at clojure.lang.RT.seq(RT.java:484)
        at clojure.core$seq.invoke(core.clj:133)
        at clojure.core.protocols$seq_reduce.invoke(protocols.clj:26)
        at clojure.core.protocols$fn__6026.invoke(protocols.clj:53)
        at clojure.core.protocols$fn__5979$G__5974__5992.invoke(protocols.clj:13)
        at clojure.core$reduce.invoke(core.clj:6175)
        at reconcile_csv.core$score.invoke(core.clj:78)
        at clojure.lang.AFn.applyToHelper(AFn.java:163)
        at clojure.lang.AFn.applyTo(AFn.java:151)
        at clojure.core$apply.invoke(core.clj:619)
        at clojure.core$partial$fn__4190.doInvoke(core.clj:2396)
        at clojure.lang.RestFn.invoke(RestFn.java:408)
        at clojure.core$map$fn__4207.invoke(core.clj:2487)
        at clojure.lang.LazySeq.sval(LazySeq.java:42)
        at clojure.lang.LazySeq.seq(LazySeq.java:60)
        at clojure.lang.RT.seq(RT.java:484)
        at clojure.core$seq.invoke(core.clj:133)
        at clojure.core$sort.invoke(core.clj:2752)
        at clojure.core$sort_by.invoke(core.clj:2769)
        at clojure.core$sort_by.invoke(core.clj:2767)
        at reconcile_csv.core$scores.invoke(core.clj:111)
        at reconcile_csv.core$reconcile_param.invoke(core.clj:123)
        at clojure.core$pmap$fn__6275$fn__6276.invoke(core.clj:6354)
        at clojure.core$binding_conveyor_fn$fn__4107.invoke(core.clj:1836)
        at clojure.lang.AFn.call(AFn.java:18)
        at java.util.concurrent.FutureTask.run(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at java.lang.Thread.run(Unknown Source)```

I have tried running the SNAPSHOT version from the GutHub repo (v0.1.0), and this works, however it doesn't allow me to use the search function.

Any thoughts or support welcomed, please ask if you need further clarification. 

Thanks
tfmorris commented 4 months ago

This service has been unsupported for almost a decade now, so you'd be better off choosing a different one. This could be caused by #5 / #6, but I haven't looked closely.