# Elasticsearch java.lang.ArrayIndexOutOfBoundsException: 1

**URL:** <https://discuss.elastic.co/t/elasticsearch-java-lang-arrayindexoutofboundsexception-1/21427>\
**Category:** Elasticsearch\
**Created:** [December 30, 2014, 3:53am UTC](https://discuss.elastic.co/t/elasticsearch-java-lang-arrayindexoutofboundsexception-1/21427 "2014-12-30T03:53:58Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![vinay\_H\_M](https://avatars.discourse-cdn.com/v4/letter/v/b38774/32.png) [@vinay\_H\_M](https://discuss.elastic.co/u/vinay_H_M)\
**Post date:** [December 30, 2014, 3:53am UTC](https://discuss.elastic.co/t/elasticsearch-java-lang-arrayindexoutofboundsexception-1/21427/1 "2014-12-30T03:53:58Z")

</div>

Hi All

I found the error while running the elasticsearch ..plzz some one solve it

[2014-12-30  
09:16:22,389][ERROR][org.agileworks.elasticsearch.river.csv.CSVRiver]  
[Aliyah Bishop] [csv][my\_csv\_river] Error has occured during processing  
file 'PDUserDeviceDataTable.csv.processing' , skipping line:  
'[9999249573";"875";"testaasim";"00:12:F3:1B:A5:68";"2";"1344";"0";"29.7";"58.3";"1419835852";"20.0";"30.0";"40.0";"50.0";"500";"500";"12.9226205";"77.5605173]'  
and continue in processing  
java.lang.ArrayIndexOutOfBoundsException: 1  
at  
org.codehaus.groovy.runtime.BytecodeInterface8.objectArrayGet(BytecodeInterface8.java:360)  
at  
org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.processDataLine(OpenCSVFileProcessor.groovy:72)  
at  
org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.this$2$processDataLine(OpenCSVFileProcessor.groovy)  
at  
org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor$this$2$processDataLine.callCurrent(Unknown  
Source)  
at  
org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.process(OpenCSVFileProcessor.groovy:49)  
at  
org.agileworks.elasticsearch.river.csv.CSVConnector.processAllFiles(CSVConnector.groovy:47)  
at  
org.agileworks.elasticsearch.river.csv.CSVConnector.run(CSVConnector.groovy:20)  
at java.lang.Thread.run(Thread.java:745)

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/dd2f00ef-d99a-48a6-9051-ebd974c39243%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/dd2f00ef-d99a-48a6-9051-ebd974c39243%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![vinay\_H\_M](https://avatars.discourse-cdn.com/v4/letter/v/b38774/32.png) [@vinay\_H\_M](https://discuss.elastic.co/u/vinay_H_M)\
**Post date:** [December 30, 2014, 3:57am UTC](https://discuss.elastic.co/t/elasticsearch-java-lang-arrayindexoutofboundsexception-1/21427/2 "2014-12-30T03:57:54Z")

</div>

On Tuesday, December 30, 2014 9:23:58 AM UTC+5:30, Vinay H M wrote:

> Hi All
> 
> I found the error while running the elasticsearch ..plzz some one solve it
> 
> [2014-12-30  
> 09:16:22,389][ERROR][org.agileworks.elasticsearch.river.csv.CSVRiver]  
> [Aliyah Bishop] [csv][my\_csv\_river] Error has occured during processing  
> file 'PDUserDeviceDataTable.csv.processing' , skipping line:  
> '[9999249573";"875";"testaasim";"00:12:F3:1B:A5:68";"2";"1344";"0";"29.7";"58.3";"1419835852";"20.0";"30.0";"40.0";"50.0";"500";"500";"12.9226205";"77.5605173]'  
> and continue in processing  
> java.lang.ArrayIndexOutOfBoundsException: 1  
> at  
> org.codehaus.groovy.runtime.BytecodeInterface8.objectArrayGet(BytecodeInterface8.java:360)  
> at  
> org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.processDataLine(OpenCSVFileProcessor.groovy:72)  
> at  
> org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.this$2$processDataLine(OpenCSVFileProcessor.groovy)  
> at  
> org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor$this$2$processDataLine.callCurrent(Unknown  
> Source)  
> at  
> org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.process(OpenCSVFileProcessor.groovy:49)  
> at  
> org.agileworks.elasticsearch.river.csv.CSVConnector.processAllFiles(CSVConnector.groovy:47)  
> at  
> org.agileworks.elasticsearch.river.csv.CSVConnector.run(CSVConnector.groovy:20)  
> at java.lang.Thread.run(Thread.java:745)

the command i am using to create index

curl -XPUT localhost:9200/\_river/my\_csv\_river/\_meta -d '  
{  
"type" : "csv",  
"csv\_file" : {  
"folder" : "/home/paqs/Downloads/kibana/dec",  
"filename\_pattern" : ".\*\.csv$",  
"poll":"1m",  
"fields" : [  
"Sno",  
"userld",  
"userName",  
"deviceld",  
"deviceCurrentMode",  
"co2Level",  
"dustLevel",  
"temperature",  
"relativeHumidity",  
"timeStamp",  
"tempLow",  
"tempHigh",  
"rhLow",  
"rhHigh",  
"dust",  
"pollution",  
"latitude",  
"longitude"  
],  
"first\_line\_is\_header" : "false",  
"field\_separator" : ",",  
"escape\_character" : "\",  
"quote\_character" : """,  
"field\_id" : "id",  
"field\_timestamp" : "imported\_at",  
"concurrent\_requests" : "1",  
"charset" : "UTF-8",  
"script\_before\_file":  
"/home/paqs/Downloads/kibana/dec/before\_file.sh",  
"script\_after\_file":  
"/home/paqs/Downloads/kibana/dec/after\_file.sh",  
"script\_before\_all":  
"/home/paqs/Downloads/kibana/dec/before\_all.sh",  
"script\_after\_all": "/home/paqs/Downloads/kibana/dec/after\_all.sh"  
},  
"index" : {  
"index" : "decdevicedata",  
"type" : "alert",  
"bulk\_size" : 1000,  
"bulk\_threshold" : 10  
}  
}'

the curl command i am using to create the mapping

Create a mapping

# 

curl -XPUT [http://localhost:9200/decdevicedata](http://localhost:9200/decdevicedata) -d '  
{  
"settings" : {  
"number\_of\_shards" : 1  
},  
"mappings" : {  
"alert" : {  
"properties" : {  
"Sno": {"type" : "integer"},  
"co2Level" : {"type" : "integer"},  
"deviceCurrentMode" : {"type" : "integer"},  
"deviceld" : {"type" : "string"},  
"dust" : {"type" : "integer"},  
"dustLevel" : {"type" : "integer"},  
"latitude": {"type" : "integer"},  
"longitude": {"type" : "integer"},  
"pollution" : {"type" : "integer"},  
"relativeHumidity" : {"type" : "float"},  
"rhLow": {"type" : "float"},  
"rhHigh": {"type" : "float"},  
"temperature": {"type" : "float"},  
"tempLow": {"type" : "float"},  
"tempHigh": {"type" : "float"},  
"timeStamp" : {"type" : "date", "ignore\_malformed" : true,  
"format" : "dateOptionalTime"},  
"userld" : {"type" : "integer"},  
"userName" : {"type" : "string", "index" : "not\_analyzed"}

```
        }
    }
}

```

}'

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [December 30, 2014, 7:54am UTC](https://discuss.elastic.co/t/elasticsearch-java-lang-arrayindexoutofboundsexception-1/21427/3 "2014-12-30T07:54:49Z")

</div>

I don't know this plugin but are you sure you can provide a shell script?  
Sounds like Groovy is trying to execute it...

--  
David 😉  
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

> Le 30 déc. 2014 à 04:57, Vinay H M [vinay@paqs.biz](mailto:vinay@paqs.biz) a écrit :
> 
> > On Tuesday, December 30, 2014 9:23:58 AM UTC+5:30, Vinay H M wrote:  
> > Hi All
> > 
> > I found the error while running the elasticsearch ..plzz some one solve it
> > 
> > [2014-12-30 09:16:22,389][ERROR][org.agileworks.elasticsearch.river.csv.CSVRiver] [Aliyah Bishop] [csv][my\_csv\_river] Error has occured during processing file 'PDUserDeviceDataTable.csv.processing' , skipping line: '[9999249573";"875";"testaasim";"00:12:F3:1B:A5:68";"2";"1344";"0";"29.7";"58.3";"1419835852";"20.0";"30.0";"40.0";"50.0";"500";"500";"12.9226205";"77.5605173]' and continue in processing  
> > java.lang.ArrayIndexOutOfBoundsException: 1  
> > at org.codehaus.groovy.runtime.BytecodeInterface8.objectArrayGet(BytecodeInterface8.java:360)  
> > at org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.processDataLine(OpenCSVFileProcessor.groovy:72)  
> > at org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.this$2$processDataLine(OpenCSVFileProcessor.groovy)  
> > at org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor$this$2$processDataLine.callCurrent(Unknown Source)  
> > at org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.process(OpenCSVFileProcessor.groovy:49)  
> > at org.agileworks.elasticsearch.river.csv.CSVConnector.processAllFiles(CSVConnector.groovy:47)  
> > at org.agileworks.elasticsearch.river.csv.CSVConnector.run(CSVConnector.groovy:20)  
> > at java.lang.Thread.run(Thread.java:745)
> 
> the command i am using to create index
> 
> curl -XPUT localhost:9200/\_river/my\_csv\_river/\_meta -d '  
> {  
> "type" : "csv",  
> "csv\_file" : {  
> "folder" : "/home/paqs/Downloads/kibana/dec",  
> "filename\_pattern" : ".\*\.csv$",  
> "poll":"1m",  
> "fields" : [  
> "Sno",  
> "userld",  
> "userName",  
> "deviceld",  
> "deviceCurrentMode",  
> "co2Level",  
> "dustLevel",  
> "temperature",  
> "relativeHumidity",  
> "timeStamp",  
> "tempLow",  
> "tempHigh",  
> "rhLow",  
> "rhHigh",  
> "dust",  
> "pollution",  
> "latitude",  
> "longitude"  
> ],  
> "first\_line\_is\_header" : "false",  
> "field\_separator" : ",",  
> "escape\_character" : "\",  
> "quote\_character" : """,  
> "field\_id" : "id",  
> "field\_timestamp" : "imported\_at",  
> "concurrent\_requests" : "1",  
> "charset" : "UTF-8",  
> "script\_before\_file": "/home/paqs/Downloads/kibana/dec/before\_file.sh",  
> "script\_after\_file": "/home/paqs/Downloads/kibana/dec/after\_file.sh",  
> "script\_before\_all": "/home/paqs/Downloads/kibana/dec/before\_all.sh",  
> "script\_after\_all": "/home/paqs/Downloads/kibana/dec/after\_all.sh"  
> },  
> "index" : {  
> "index" : "decdevicedata",  
> "type" : "alert",  
> "bulk\_size" : 1000,  
> "bulk\_threshold" : 10  
> }  
> }'
> 
> the curl command i am using to create the mapping
> 
> Create a mapping
> 
> # 
> 
> curl -XPUT [http://localhost:9200/decdevicedata](http://localhost:9200/decdevicedata) -d '  
> {  
> "settings" : {  
> "number\_of\_shards" : 1  
> },  
> "mappings" : {  
> "alert" : {  
> "properties" : {  
> "Sno": {"type" : "integer"},  
> "co2Level" : {"type" : "integer"},  
> "deviceCurrentMode" : {"type" : "integer"},  
> "deviceld" : {"type" : "string"},  
> "dust" : {"type" : "integer"},  
> "dustLevel" : {"type" : "integer"},  
> "latitude": {"type" : "integer"},  
> "longitude": {"type" : "integer"},  
> "pollution" : {"type" : "integer"},  
> "relativeHumidity" : {"type" : "float"},  
> "rhLow": {"type" : "float"},  
> "rhHigh": {"type" : "float"},  
> "temperature": {"type" : "float"},  
> "tempLow": {"type" : "float"},  
> "tempHigh": {"type" : "float"},  
> "timeStamp" : {"type" : "date", "ignore\_malformed" : true, "format" : "dateOptionalTime"},  
> "userld" : {"type" : "integer"},  
> "userName" : {"type" : "string", "index" : "not\_analyzed"}
> 
> ```
> }
> }
> }
> 
> ```
> 
> }'
> 
> --  
> You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
> To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com).  
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/F953BC4D-D6F8-42B5-A21D-80929F4B0142%40pilato.fr](https://groups.google.com/d/msgid/elasticsearch/F953BC4D-D6F8-42B5-A21D-80929F4B0142%40pilato.fr).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![vinay\_H\_M](https://avatars.discourse-cdn.com/v4/letter/v/b38774/32.png) [@vinay\_H\_M](https://discuss.elastic.co/u/vinay_H_M)\
**Post date:** [December 30, 2014, 10:00am UTC](https://discuss.elastic.co/t/elasticsearch-java-lang-arrayindexoutofboundsexception-1/21427/4 "2014-12-30T10:00:36Z")

</div>

ya shell script can be used ... but this error is occurring when i run the  
elasticsearch... can i get the one sample code to extract the csv file and  
to execute in elasticsearch and kibana

On Tuesday, December 30, 2014 1:25:03 PM UTC+5:30, David Pilato wrote:

> I don't know this plugin but are you sure you can provide a shell script?  
> Sounds like Groovy is trying to execute it...
> 
> --  
> David 😉  
> Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> 
> Le 30 déc. 2014 à 04:57, Vinay H M \<vi...@paqs.biz \<javascript:\>\> a  
> écrit :
> 
> On Tuesday, December 30, 2014 9:23:58 AM UTC+5:30, Vinay H M wrote:
> 
> > Hi All
> > 
> > I found the error while running the elasticsearch ..plzz some one solve  
> > it
> > 
> > [2014-12-30  
> > 09:16:22,389][ERROR][org.agileworks.elasticsearch.river.csv.CSVRiver]  
> > [Aliyah Bishop] [csv][my\_csv\_river] Error has occured during processing  
> > file 'PDUserDeviceDataTable.csv.processing' , skipping line:  
> > '[9999249573";"875";"testaasim";"00:12:F3:1B:A5:68";"2";"1344";"0";"29.7";"58.3";"1419835852";"20.0";"30.0";"40.0";"50.0";"500";"500";"12.9226205";"77.5605173]'  
> > and continue in processing  
> > java.lang.ArrayIndexOutOfBoundsException: 1  
> > at  
> > org.codehaus.groovy.runtime.BytecodeInterface8.objectArrayGet(BytecodeInterface8.java:360)  
> > at  
> > org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.processDataLine(OpenCSVFileProcessor.groovy:72)  
> > at  
> > org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.this$2$processDataLine(OpenCSVFileProcessor.groovy)  
> > at  
> > org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor$this$2$processDataLine.callCurrent(Unknown  
> > Source)  
> > at  
> > org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.process(OpenCSVFileProcessor.groovy:49)  
> > at  
> > org.agileworks.elasticsearch.river.csv.CSVConnector.processAllFiles(CSVConnector.groovy:47)  
> > at  
> > org.agileworks.elasticsearch.river.csv.CSVConnector.run(CSVConnector.groovy:20)  
> > at java.lang.Thread.run(Thread.java:745)
> 
> the command i am using to create index
> 
> curl -XPUT localhost:9200/\_river/my\_csv\_river/\_meta -d '  
> {  
> "type" : "csv",  
> "csv\_file" : {  
> "folder" : "/home/paqs/Downloads/kibana/dec",  
> "filename\_pattern" : ".\*\.csv$",  
> "poll":"1m",  
> "fields" : [  
> "Sno",  
> "userld",  
> "userName",  
> "deviceld",  
> "deviceCurrentMode",  
> "co2Level",  
> "dustLevel",  
> "temperature",  
> "relativeHumidity",  
> "timeStamp",  
> "tempLow",  
> "tempHigh",  
> "rhLow",  
> "rhHigh",  
> "dust",  
> "pollution",  
> "latitude",  
> "longitude"  
> ],  
> "first\_line\_is\_header" : "false",  
> "field\_separator" : ",",  
> "escape\_character" : "\",  
> "quote\_character" : """,  
> "field\_id" : "id",  
> "field\_timestamp" : "imported\_at",  
> "concurrent\_requests" : "1",  
> "charset" : "UTF-8",  
> "script\_before\_file":  
> "/home/paqs/Downloads/kibana/dec/before\_file.sh",  
> "script\_after\_file":  
> "/home/paqs/Downloads/kibana/dec/after\_file.sh",  
> "script\_before\_all":  
> "/home/paqs/Downloads/kibana/dec/before\_all.sh",  
> "script\_after\_all": "/home/paqs/Downloads/kibana/dec/after\_all.sh"  
> },  
> "index" : {  
> "index" : "decdevicedata",  
> "type" : "alert",  
> "bulk\_size" : 1000,  
> "bulk\_threshold" : 10  
> }  
> }'
> 
> the curl command i am using to create the mapping
> 
> Create a mapping
> 
> # 
> 
> curl -XPUT [http://localhost:9200/decdevicedata](http://localhost:9200/decdevicedata) -d '  
> {  
> "settings" : {  
> "number\_of\_shards" : 1  
> },  
> "mappings" : {  
> "alert" : {  
> "properties" : {  
> "Sno": {"type" : "integer"},  
> "co2Level" : {"type" : "integer"},  
> "deviceCurrentMode" : {"type" : "integer"},  
> "deviceld" : {"type" : "string"},  
> "dust" : {"type" : "integer"},  
> "dustLevel" : {"type" : "integer"},  
> "latitude": {"type" : "integer"},  
> "longitude": {"type" : "integer"},  
> "pollution" : {"type" : "integer"},  
> "relativeHumidity" : {"type" : "float"},  
> "rhLow": {"type" : "float"},  
> "rhHigh": {"type" : "float"},  
> "temperature": {"type" : "float"},  
> "tempLow": {"type" : "float"},  
> "tempHigh": {"type" : "float"},  
> "timeStamp" : {"type" : "date", "ignore\_malformed" : true,  
> "format" : "dateOptionalTime"},  
> "userld" : {"type" : "integer"},  
> "userName" : {"type" : "string", "index" : "not\_analyzed"}
> 
> ```
> }
> }
> }
> 
> ```
> 
> }'
> 
> --  
> You received this message because you are subscribed to the Google Groups  
> "elasticsearch" group.  
> To unsubscribe from this group and stop receiving emails from it, send an  
> email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \<javascript:\>.  
> To view this discussion on the web visit  
> [https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com)  
> [https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com?utm_medium=email&utm_source=footer)  
> .  
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/966dee53-7347-43ef-aba7-e86467d60124%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/966dee53-7347-43ef-aba7-e86467d60124%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [December 30, 2014, 11:08am UTC](https://discuss.elastic.co/t/elasticsearch-java-lang-arrayindexoutofboundsexception-1/21427/5 "2014-12-30T11:08:15Z")

</div>

I would first try without any script.  
If it still does not work, you should may be open an issue in the project.

--  
David 😉  
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

> Le 30 déc. 2014 à 11:00, Vinay H M [vinay@paqs.biz](mailto:vinay@paqs.biz) a écrit :
> 
> ya shell script can be used ... but this error is occurring when i run the elasticsearch... can i get the one sample code to extract the csv file and to execute in elasticsearch and kibana
> 
> > On Tuesday, December 30, 2014 1:25:03 PM UTC+5:30, David Pilato wrote:  
> > I don't know this plugin but are you sure you can provide a shell script?  
> > Sounds like Groovy is trying to execute it...
> > 
> > --  
> > David 😉  
> > Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
> > 
> > > Le 30 déc. 2014 à 04:57, Vinay H M [vi...@paqs.biz](mailto:vi...@paqs.biz) a écrit :
> > > 
> > > > On Tuesday, December 30, 2014 9:23:58 AM UTC+5:30, Vinay H M wrote:  
> > > > Hi All
> > > > 
> > > > I found the error while running the elasticsearch ..plzz some one solve it
> > > > 
> > > > [2014-12-30 09:16:22,389][ERROR][org.agileworks.elasticsearch.river.csv.CSVRiver] [Aliyah Bishop] [csv][my\_csv\_river] Error has occured during processing file 'PDUserDeviceDataTable.csv.processing' , skipping line: '[9999249573";"875";"testaasim";"00:12:F3:1B:A5:68";"2";"1344";"0";"29.7";"58.3";"1419835852";"20.0";"30.0";"40.0";"50.0";"500";"500";"12.9226205";"77.5605173]' and continue in processing  
> > > > java.lang.ArrayIndexOutOfBoundsException: 1  
> > > > at org.codehaus.groovy.runtime.BytecodeInterface8.objectArrayGet(BytecodeInterface8.java:360)  
> > > > at org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.processDataLine(OpenCSVFileProcessor.groovy:72)  
> > > > at org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.this$2$processDataLine(OpenCSVFileProcessor.groovy)  
> > > > at org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor$this$2$processDataLine.callCurrent(Unknown Source)  
> > > > at org.agileworks.elasticsearch.river.csv.OpenCSVFileProcessor.process(OpenCSVFileProcessor.groovy:49)  
> > > > at org.agileworks.elasticsearch.river.csv.CSVConnector.processAllFiles(CSVConnector.groovy:47)  
> > > > at org.agileworks.elasticsearch.river.csv.CSVConnector.run(CSVConnector.groovy:20)  
> > > > at java.lang.Thread.run(Thread.java:745)
> > > 
> > > the command i am using to create index
> > > 
> > > curl -XPUT localhost:9200/\_river/my\_csv\_river/\_meta -d '  
> > > {  
> > > "type" : "csv",  
> > > "csv\_file" : {  
> > > "folder" : "/home/paqs/Downloads/kibana/dec",  
> > > "filename\_pattern" : ".\*\.csv$",  
> > > "poll":"1m",  
> > > "fields" : [  
> > > "Sno",  
> > > "userld",  
> > > "userName",  
> > > "deviceld",  
> > > "deviceCurrentMode",  
> > > "co2Level",  
> > > "dustLevel",  
> > > "temperature",  
> > > "relativeHumidity",  
> > > "timeStamp",  
> > > "tempLow",  
> > > "tempHigh",  
> > > "rhLow",  
> > > "rhHigh",  
> > > "dust",  
> > > "pollution",  
> > > "latitude",  
> > > "longitude"  
> > > ],  
> > > "first\_line\_is\_header" : "false",  
> > > "field\_separator" : ",",  
> > > "escape\_character" : "\",  
> > > "quote\_character" : """,  
> > > "field\_id" : "id",  
> > > "field\_timestamp" : "imported\_at",  
> > > "concurrent\_requests" : "1",  
> > > "charset" : "UTF-8",  
> > > "script\_before\_file": "/home/paqs/Downloads/kibana/dec/before\_file.sh",  
> > > "script\_after\_file": "/home/paqs/Downloads/kibana/dec/after\_file.sh",  
> > > "script\_before\_all": "/home/paqs/Downloads/kibana/dec/before\_all.sh",  
> > > "script\_after\_all": "/home/paqs/Downloads/kibana/dec/after\_all.sh"  
> > > },  
> > > "index" : {  
> > > "index" : "decdevicedata",  
> > > "type" : "alert",  
> > > "bulk\_size" : 1000,  
> > > "bulk\_threshold" : 10  
> > > }  
> > > }'
> > > 
> > > the curl command i am using to create the mapping
> > > 
> > > Create a mapping
> > > 
> > > # 
> > > 
> > > curl -XPUT [http://localhost:9200/decdevicedata](http://localhost:9200/decdevicedata) -d '  
> > > {  
> > > "settings" : {  
> > > "number\_of\_shards" : 1  
> > > },  
> > > "mappings" : {  
> > > "alert" : {  
> > > "properties" : {  
> > > "Sno": {"type" : "integer"},  
> > > "co2Level" : {"type" : "integer"},  
> > > "deviceCurrentMode" : {"type" : "integer"},  
> > > "deviceld" : {"type" : "string"},  
> > > "dust" : {"type" : "integer"},  
> > > "dustLevel" : {"type" : "integer"},  
> > > "latitude": {"type" : "integer"},  
> > > "longitude": {"type" : "integer"},  
> > > "pollution" : {"type" : "integer"},  
> > > "relativeHumidity" : {"type" : "float"},  
> > > "rhLow": {"type" : "float"},  
> > > "rhHigh": {"type" : "float"},  
> > > "temperature": {"type" : "float"},  
> > > "tempLow": {"type" : "float"},  
> > > "tempHigh": {"type" : "float"},  
> > > "timeStamp" : {"type" : "date", "ignore\_malformed" : true, "format" : "dateOptionalTime"},  
> > > "userld" : {"type" : "integer"},  
> > > "userName" : {"type" : "string", "index" : "not\_analyzed"}
> > > 
> > > ```
> > > }
> > > }
> > > }
> > > 
> > > ```
> > > 
> > > }'
> > > 
> > > --  
> > > You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
> > > To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com).  
> > > To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/2bb5ffb1-3213-4055-8f58-467721e1ed5d%40googlegroups.com).  
> > > For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
> 
> --  
> You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
> To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/966dee53-7347-43ef-aba7-e86467d60124%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/966dee53-7347-43ef-aba7-e86467d60124%40googlegroups.com).  
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/7B1DFA6C-D5E5-4C7F-97E8-49F6EB5E9730%40pilato.fr](https://groups.google.com/d/msgid/elasticsearch/7B1DFA6C-D5E5-4C7F-97E8-49F6EB5E9730%40pilato.fr).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<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:** [July 6, 2017, 12:41am UTC](https://discuss.elastic.co/t/elasticsearch-java-lang-arrayindexoutofboundsexception-1/21427/6 "2017-07-06T00:41:27Z")

</div>


