# Got error in logstash. help me!

**URL:** <https://discuss.elastic.co/t/got-error-in-logstash-help-me/262587>\
**Category:** Logstash\
**Created:** [January 29, 2021, 4:17am UTC](https://discuss.elastic.co/t/got-error-in-logstash-help-me/262587 "2021-01-29T04:17:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Farmer\_J](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farmer_j/32/83091_2.png) [@Farmer\_J](https://discuss.elastic.co/u/Farmer_J)\
**Post date:** [January 29, 2021, 4:17am UTC](https://discuss.elastic.co/t/got-error-in-logstash-help-me/262587/1 "2021-01-29T04:17:26Z")

</div>

hi guys . i got some error code in AMI  
when i excute logstash config file for indexing

these is error codes=\>  
Failed to execute action {:action=\>LogStash::PipelineAction::Create/pipeline\_id:main, :exception=\>"LogStash::ConfigurationError", :message=\>"Expected one of #, input, filter, output at line 214, column 1 (byte 8248) after ", :backtrace=\>["/logstash-7.1.1/logstash-core/lib/logstash/compiler.rb:41:in `compile_imperative'", "/logstash-7.1.1/logstash-core/lib/logstash/compiler.rb:49:in `compile\_graph'", "/logstash-7.1.1/logstash-core/lib/logstash/compiler.rb:11:in `block in compile_sources'", "org/jruby/RubyArray.java:2577:in `map'", "/logstash-7.1.1/logstash-core/lib/logstash/compiler.rb:10:in `compile_sources'", "org/logstash/execution/AbstractPipelineExt.java:151:in `initialize'", "org/logstash/execution/JavaBasePipelineExt.java:47:in `initialize'", "/logstash-7.1.1/logstash-core/lib/logstash/java_pipeline.rb:23:in `initialize'", "/logstash-7.1.1/logstash-core/lib/logstash/pipeline\_action/create.rb:36:in `execute'", "/logstash-7.1.1/logstash-core/lib/logstash/agent.rb:325:in `block in converge\_state'"]}

here is my config mates

from under

jdbc\_fetch\_size =\> 1000  
use\_column\_value =\> true  
tracking\_column =\> "updat"  
tracking\_column\_type =\> "timestamp"  
#last\_run\_metadata\_path =\> "/logstash/.logstash\_jdbc\_last\_run"  
record\_last\_run =\> true  
clean\_run =\> true

}  
}  
filter {  
aggregate{  
task\_id =\> "%{spoid}\_%{bid}"  
code =\>"  
map['spoid'] = event.get('spoid')  
map['bid'] = event.get('bid')  
map['free'] = event.get('free')  
map['kind'] = event.get('kind')  
map['sponam'] = event.get('sponam')  
map['planam'] = event.get('planam')  
map['addcod'] = event.get('addcod')  
map['zipadmsi'] = event.get('zipadmsi')  
map['zipadmgu'] = event.get('zipadmgu')  
map['zipcod'] = event.get('zipcod')  
map['add1'] = event.get('add1')  
map['add2'] = event.get('add2')  
map['pladesc'] = event.get('pladesc')  
map['lon'] = event.get('lon')  
map['lat'] = event.get('lat')  
map['stacolor'] = event.get('stacolor')  
map['cnt'] = event.get('cnt')  
map['ord'] = event.get('ord')  
map['id'] = event.get('id')  
map['text'] = event.get('text')  
map['spotman'] ||=   
map['spotman'] \<\< {'dcchacod' =\> event.get('dcchacod')}  
"  
timeout\_tags =\> ["aggregate"]  
push\_previous\_map\_as\_event =\> true  
timeout =\> 3  
timeout\_code =\> "  
elapsed\_time = Time.now - event.timestamp.time  
event.tag('last') if elapsed\_time \>= 3  
"  
}  
}  
date{  
match =\> ["setdt","yyyyMMdd'T'HHmmss"]  
timezone =\> "Asia/Seoul"  
target =\> "setdt"  
}  
mutate {

```
    add_field => {"msg_id" => "%{bid}%{spoid}"}

```

}

output {  
elasticsearch {  
hosts =\> ["[search-everon-jkgsx53bmgr3lhvcwpgylxnd7e.ap-northeast-2.es.amazonaws.com:443](http://search-everon-jkgsx53bmgr3lhvcwpgylxnd7e.ap-northeast-2.es.amazonaws.com:443)"]  
ssl =\> true  
index =\> "everon\_spot"  
ilm\_enabled =\> false  
document\_id =\> "%{msg\_id}"

```
    }
            stdout{codec => json}

```

}

plze help me!!!

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [January 30, 2021, 5:07pm UTC](https://discuss.elastic.co/t/got-error-in-logstash-help-me/262587/2 "2021-01-30T17:07:09Z")

</div>

Can you post just your entire conf and use the code block so it formats it correctly?

The issues says it's at `line 214, column 1` but it hard to tell since it looks like you didn't put your entire conf in here. There is no input block at the start.

Wrap your code in ``` so it shows like the below and is easier to read.

```auto
input {
   jdbc { ...

```

---

<div class="post-metadata">

**Author:** ![Farmer\_J](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/farmer_j/32/83091_2.png) [@Farmer\_J](https://discuss.elastic.co/u/Farmer_J)\
**Post date:** [February 5, 2021, 6:39am UTC](https://discuss.elastic.co/t/got-error-in-logstash-help-me/262587/3 "2021-02-05T06:39:37Z")

</div>

im so sorry for reply to late

and appreciate your help @aaron-nimocks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 5, 2021, 6:39am UTC](https://discuss.elastic.co/t/got-error-in-logstash-help-me/262587/4 "2021-03-05T06:39:45Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.