# JDBC Filter error when running as service **URL:** \ **Category:** Logstash\ **Created:** [March 19, 2019, 1:52pm UTC](https://discuss.elastic.co/t/jdbc-filter-error-when-running-as-service/172985 "2019-03-19T13:52:47Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![hubertn](https://avatars.discourse-cdn.com/v4/letter/h/c5a1d2/32.png) [@hubertn](https://discuss.elastic.co/u/hubertn)\ **Post date:** [March 19, 2019, 1:52pm UTC](https://discuss.elastic.co/t/jdbc-filter-error-when-running-as-service/172985/1 "2019-03-19T13:52:47Z")
We have a logstash's pipeline that use JDBC filter. When we ran the pipeline as service using: systemctl start our.service. We have the following error; but when we ran as command everything looks fine. Does anyone have the same issue or suggestion for the solution. Our version of logstash is 6.62 Elastic search 6.6.2 Mar 18 23:41:06 ells01 logstash: [2019-03-18T23:41:06,503][INFO][logstash.outputs.elasticsearch] New Elasticsearch output {:class=\>"LogStash::Outputs::ElasticSearch", :hosts=\>["[//elesdata01.otpp.com:9200](https://elesdata01.otpp.com:9200)", "[//elesdata02.otpp.com:9200](https://elesdata02.otpp.com:9200)", "[//elesdata03.otpp.com:9200](https://elesdata03.otpp.com:9200)", "[//elesdata04.otpp.com:9200](https://elesdata04.otpp.com:9200)", "[//elesdata05.otpp.com:9200](https://elesdata05.otpp.com:9200)"]} Mar 18 23:41:06 ells01 logstash: [2019-03-18T23:41:06,506][INFO][logstash.outputs.elasticsearch] Attempting to install template {:manage\_template=\>{"template"=\>"logstash-_", "version"=\>60001, "settings"=\>{"index.refresh\_interval"=\>"5s"}, "mappings"=\>{"default"=\>{"dynamic\_templates"=\>[{"message\_field"=\>{"path\_match"=\>"message", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false}}}, {"string\_fields"=\>{"match"=\>"_", "match\_mapping\_type"=\>"string", "mapping"=\>{"type"=\>"text", "norms"=\>false, "fields"=\>{"keyword"=\>{"type"=\>"keyword", "ignore\_above"=\>256}}}}}], "properties"=\>{"@timestamp"=\>{"type"=\>"date"}, "@version"=\>{"type"=\>"keyword"}, "geoip"=\>{"dynamic"=\>true, "properties"=\>{"ip"=\>{"type"=\>"ip"}, "location"=\>{"type"=\>"geo\_point"}, "latitude"=\>{"type"=\>"half\_float"}, "longitude"=\>{"type"=\>"half\_float"}}}}}}}} Mar 18 23:41:06 ells01 logstash: [2019-03-18T23:41:06,599][ERROR][logstash.pipeline] Error registering plugin {:pipeline\_id=\>"main", :plugin=\>"#LogStash::FilterDelegator:0x1615461a", :error=\>"", :thread=\>"#\"} Mar 18 23:41:06 ells01 logstash: [2019-03-18T23:41:06,762][ERROR][logstash.pipeline] Pipeline aborted due to error {:pipeline\_id=\>"main", :exception=\>java.lang.NullPointerException, :backtrace=\>["java.util.Hashtable.put(java/util/Hashtable.java:460)", "java.util.Properties.setProperty(java/util/Properties.java:166)", "java.lang.System.setProperty(java/lang/System.java:796)", "java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)", "org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:468)", "org.jruby.javasupport.JavaMethod.invokeStaticDirect(org/jruby/javasupport/JavaMethod.java:370)", "opt.apps.logstash.logstash.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.logstash\_minus\_filter\_minus\_jdbc\_static\_minus\_1\_dot\_0\_dot\_6.lib.logstash.filters.jdbc\_static.prepare\_data\_dir(/opt/apps/logstash/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-filter-jdbc\_static-1.0.6/lib/logstash/filters/jdbc\_static.rb:170)", "opt.apps.logstash.logstash.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.logstash\_minus\_filter\_minus\_jdbc\_static\_minus\_1\_dot\_0\_dot\_6.lib.logstash.filters.jdbc\_static.RUBY$method$prepare\_data\_dir$0$ **VARARGS** (opt/apps/logstash/logstash/vendor/bundle/jruby/$2\_dot\_3\_dot\_0/gems/logstash\_minus\_filter\_minus\_jdbc\_static\_minus\_1\_dot\_0\_dot\_6/lib/logstash/filters//opt/apps/logstash/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-filter-jdbc\_static-1.0.6/lib/logstash/filters/jdbc\_static.rb)", "opt.apps.logstash.logstash.vendor.bundle.jruby.$2\_dot\_3\_dot\_0.gems.logstash\_minus\_filter\_minus\_jdbc\_static\_minus\_1\_dot\_0\_dot\_6.lib.logstash.filters.jdbc\_static.register(/opt/apps/logstash/logstash/vendor/bundle/jruby/2.3.0/gems/logstash-filter-jdbc\_static-1.0.6/lib/logstash/filters/jdbc\_static.rb:145)", "org.jruby.RubyClass.finvoke(org/jruby/RubyClass.java:557)", "org.jruby.RubyBasicObject.callMethod(org/jruby/RubyBasicObject.java:354)", "org.logstash.config.ir.compiler.FilterDelegatorExt.doRegister(org/logstash/config/ir/compiler/FilterDelegatorExt.java:63)", "org.logstash.config.ir.compiler.AbstractFilterDelegatorExt.register(org/logstash/config/ir/compiler/AbstractFilterDelegatorExt.java:56)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.register\_plugin(/opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb:259)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.block in register\_plugins(/opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb:270)", "org.jruby.RubyArray.each(org/jruby/RubyArray.java:1734)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.register\_plugins(/opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb:270)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.RUBY$method$register\_plugins$0$ **VARARGS** (opt/apps/logstash/logstash/logstash\_minus\_core/lib/logstash//opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.maybe\_setup\_out\_plugins(/opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb:612)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.RUBY$method$maybe\_setup\_out\_plugins$0$ **VARARGS** (opt/apps/logstash/logstash/logstash\_minus\_core/lib/logstash//opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.start\_workers(/opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb:280)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.RUBY$method$start\_workers$0$ **VARARGS** (opt/apps/logstash/logstash/logstash\_minus\_core/lib/logstash//opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.run(/opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb:217)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.RUBY$method$run$0$ **VARARGS** (opt/apps/logstash/logstash/logstash\_minus\_core/lib/logstash//opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb)", "opt.apps.logstash.logstash.logstash\_minus\_core.lib.logstash.pipeline.block in start(/opt/apps/logstash/logstash/logstash-core/lib/logstash/pipeline.rb:176)", "org.jruby.RubyProc.call(org/jruby/RubyProc.java:289)", "org.jruby.RubyProc.call(org/jruby/RubyProc.java:246)", "java.lang.Thread.run(java/lang/Thread.java:748)"], :thread=\>"#\"} Mar 18 23:41:06 ells01 logstash: [2019-03-18T23:41:06,764][ERROR][logstash.agent] Failed to execute action {:id=\>:main, :action\_type=\>LogStash::ConvergeResult::FailedAction, :message=\>"Could not execute action: PipelineAction::Create, action\_result: false", :backtrace=\>nil} Mar 18 23:41:08 ells01 logstash: [2019-03-18T23:41:08,433][INFO][logstash.pipeline] Pipeline has terminated {:pipeline\_id=\>".monitoring-logstash", :thread=\>"#\"} Mar 18 23:41:08 ells01 systemd: logstash-event.service holdoff time over, scheduling restart. Mar 18 23:41:08 ells01 systemd: Stopped Logstash-Event. ---
**Author:** ![Kyoung-Hun\_Lee](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kyoung-hun_lee/32/43282_2.png) [@Kyoung-Hun\_Lee](https://discuss.elastic.co/u/Kyoung-Hun_Lee)\ **Post date:** [April 2, 2019, 6:43am UTC](https://discuss.elastic.co/t/jdbc-filter-error-when-running-as-service/172985/2 "2019-04-02T06:43:02Z")
Hi, I solved the problem. JDBC filter using HOME environment. ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/b/1be2c371656e760b93c6b5b0aceec42905b59264.png) You need add to your.service file: ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/0/70826c8cbc3d5c601a83f41da07196ffe26046dd.png) Good luck ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 30, 2019, 6:43am UTC](https://discuss.elastic.co/t/jdbc-filter-error-when-running-as-service/172985/3 "2019-04-30T06:43:06Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.