# Import Error "expected START\_OBJECT or END\_OBJECT but found \[VALUE\_NUMBER\]"

**URL:** <https://discuss.elastic.co/t/import-error-expected-start-object-or-end-object-but-found-value-number/50041>\
**Category:** Elasticsearch\
**Created:** [May 14, 2016, 2:51am UTC](https://discuss.elastic.co/t/import-error-expected-start-object-or-end-object-but-found-value-number/50041 "2016-05-14T02:51:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![fujitora](https://avatars.discourse-cdn.com/v4/letter/f/6de8d8/32.png) [@fujitora](https://discuss.elastic.co/u/fujitora)\
**Post date:** [May 14, 2016, 2:51am UTC](https://discuss.elastic.co/t/import-error-expected-start-object-or-end-object-but-found-value-number/50041/1 "2016-05-14T02:51:42Z")

</div>

I want to import Mysql data into elasricsearch.  
But get an error in the middle of import.  
I running as rake task( model\_name.import ) after create index.

```auto
rake aborted!
Elasticsearch::Transport::Transport::Errors::BadRequest: [400] {"error":{"root_cause":[{"type":"illegal_argument_exception","reason":"Malformed action/metadata line [417], expected START_OBJECT or END_OBJECT but found [VALUE_NUMBER]"}],"type":"illegal_argument_exception","reason":"Malformed action/metadata line [417], expected START_OBJECT or END_OBJECT but found [VALUE_NUMBER]"},"status":400}

```

I do not know the cause.

My elasticsearch's is stable 2.2.0, HEAD.

---

<div class="post-metadata">

**Author:** ![nik9000](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nik9000/32/44947_2.png) [@nik9000](https://discuss.elastic.co/u/nik9000)\
**Post date:** [May 14, 2016, 1:29pm UTC](https://discuss.elastic.co/t/import-error-expected-start-object-or-end-object-but-found-value-number/50041/2 "2016-05-14T13:29:44Z")

</div>

The error message is telling you that on line 417 of the bulk you have a number where one doesn't make sense. The line is invalid json. I can't help with the ruby/rake stuff, but maybe you can go from there?

---

<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 5, 2017, 10:51pm UTC](https://discuss.elastic.co/t/import-error-expected-start-object-or-end-object-but-found-value-number/50041/3 "2017-07-05T22:51:26Z")

</div>