# Create river error (no such index) index\_not\_found\_exception
**URL:** https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054
**Category:** Elasticsearch
**Created:** [July 6, 2017, 8:51am UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054 "2017-07-06T08:51:12Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@ines\_ben\_kraiem](https://discuss.elastic.co/u/ines_ben_kraiem)
#### Post date: [July 6, 2017, 8:51am UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/1 "2017-07-06T08:51:12Z")
I keep getting an error when i wrote this url [http://localhost:9200/capteur/\_search](http://localhost:9200/capteur/_search)
error
root\_cause
0
type "index\_not\_found\_exception"
reason "no such index"
resource.type "index\_or\_alias"
[resource.id](http://resource.id) "capteur"
index\_uuid "_na_"
index "capteur"
type "index\_not\_found\_exception"
reason "no such index"
resource.type "index\_or\_alias"
[resource.id](http://resource.id) "capteur"
index\_uuid "_na_"
index "capteur"
status 404
Does anyone have a clue what could be going wrong?
Thanks in advance.
---
### Author:  [@Charles.w](https://discuss.elastic.co/u/Charles.w)
#### Post date: [July 6, 2017, 10:27am UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/2 "2017-07-06T10:27:46Z")
Hi,
Rivers are deprecated since 1.5 as explained by Shay Bannon in [this article](https://www.elastic.co/blog/deprecating-rivers), so you should definitely consider upgrading your cluster 😉
So what version of elasticsearch are you using ? What is your usecase ? Is there any reason not to upgrade your cluster ?
Best regards,
Charles.w
---
### Author:  [@ines\_ben\_kraiem](https://discuss.elastic.co/u/ines_ben_kraiem)
#### Post date: [July 6, 2017, 10:34am UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/3 "2017-07-06T10:34:21Z")
Thanks for your replay.
In fact i installed the latest version of elasticsearch (5.4.3)and i am using slq server 2014 and i would like to use kibana tool on my base to do some analysis.
Note : My database contains about 200 000 000 lines so it is possible to use kibna ?
And if rivers are deprecated how can i configure elasticsearch with sqlserver.
Best regards.
---
### Author:  [@Charles.w](https://discuss.elastic.co/u/Charles.w)
#### Post date: [July 6, 2017, 10:50am UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/4 "2017-07-06T10:50:34Z")
Hi,
In regards to your data ingestion needs you might consider:
- using a logstash pipeline with the [logstash-input-jdbc](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) plugin as input, some filters of your choice and the [logstash-output-elasticsearch](https://www.elastic.co/guide/en/logstash/current/plugins-outputs-elasticsearch.html) plugin as output
- write your own ingestion tool using one of the many [elasticsearch client libraries](https://www.elastic.co/guide/en/elasticsearch/client/index.html)
On the data visualization side of things, it all depends on how your datas are structured and what you want to do with them.
Best regards,
Charles.w
---
### Author:  [@ines\_ben\_kraiem](https://discuss.elastic.co/u/ines_ben_kraiem)
#### Post date: [July 8, 2017, 11:52am UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/5 "2017-07-08T11:52:40Z")
Thanks for your replay !
After the configuration i created db.conf and i get this result
I don't understand why it only shows me 5 lines but in the database it exits 400000 lines!
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [July 8, 2017, 12:11pm UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/6 "2017-07-08T12:11:03Z")
You have probably the first 10 docs. Not 5.
---
### Author:  [@ines\_ben\_kraiem](https://discuss.elastic.co/u/ines_ben_kraiem)
#### Post date: [July 8, 2017, 12:46pm UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/7 "2017-07-08T12:46:20Z")
yes You're right i have to change the result number in query editor. And to display the results with kibana how I can do please ?
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [July 8, 2017, 4:00pm UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/8 "2017-07-08T16:00:49Z")
That's a question to ask in #kibana
---
### Author:  [@ines\_ben\_kraiem](https://discuss.elastic.co/u/ines_ben_kraiem)
#### Post date: [July 8, 2017, 5:35pm UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/9 "2017-07-08T17:35:55Z")
Ok. Thanks for your replay 🙂
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 5, 2017, 5:36pm UTC](https://discuss.elastic.co/t/create-river-error-no-such-index-index-not-found-exception/92054/10 "2017-08-05T17:36:08Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.