# Unable to add index for parsed data from elastic search index management

**URL:** <https://discuss.elastic.co/t/unable-to-add-index-for-parsed-data-from-elastic-search-index-management/203005>\
**Category:** Kibana\
**Created:** [October 10, 2019, 10:50am UTC](https://discuss.elastic.co/t/unable-to-add-index-for-parsed-data-from-elastic-search-index-management/203005 "2019-10-10T10:50:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mduduzi](https://avatars.discourse-cdn.com/v4/letter/m/b487fb/32.png) [@mduduzi](https://discuss.elastic.co/u/mduduzi)\
**Post date:** [October 10, 2019, 10:50am UTC](https://discuss.elastic.co/t/unable-to-add-index-for-parsed-data-from-elastic-search-index-management/203005/1 "2019-10-10T10:50:28Z")

</div>

I'm new in the ELK system building and configuration and have a few challenges.  
I am unable to add index for parsed data from elastic search index management. I however can see the the parsed data from Kibana index pattern but when l try create the index it takes forever to create the index. Please assist.

I am pulling data from a SQL database using the below string in logstash

input {  
jdbc {

```
    jdbc_connection_string => //HostName\instanceName;database=DBName;user=UserName;password=Password" 
    jdbc_user => User
    jdbc_driver_library => "C:\Program Files\Microsoft JDBC Driver 6.2 for SQL Server\sqljdbc_6.2\enu\sqljdbc4-2.0.jar"       
    jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"        
    statement => "SELECT TOP 100 * FROM Example_table"
}

```

}

output {  
#stdout { codec =\> json\_lines }  
elasticsearch {  
hosts =\> ["localhost:9200"]  
}  
}

Below is the response from elastic search indices in the index management stats and health state is continuously yellow.

{  
"\_shards": {  
"total": 2,  
"successful": 1,  
"failed": 0  
},  
"stats": {  
"uuid": "swDiyIk-TyWagC\_vrSOOgg",  
"primaries": {  
"docs": {  
"count": 35320,  
"deleted": 0  
},  
"store": {  
"size\_in\_bytes": 10176016  
},  
"indexing": {  
"index\_total": 35320,  
"index\_time\_in\_millis": 15253,  
"index\_current": 0,  
"index\_failed": 0,  
"delete\_total": 0,  
"delete\_time\_in\_millis": 0,  
"delete\_current": 0,  
"noop\_update\_total": 0,  
"is\_throttled": false,  
"throttle\_time\_in\_millis": 0  
},

In Kibana index pattern l can see the indices but when l try create the index it takes forever to create. Kindly assist not sure what could be the issue.

See below for kibana screenshots

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/4/f4d016814fd9dedb03860762d4a7b08cb50ff01b.png)

System keeps on saying creating index forever

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/7/e/7ebca9b2fbc008b446f0865e89bc1a39e34f5947.png)

---

<div class="post-metadata">

**Author:** ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)\
**Post date:** [October 10, 2019, 7:01pm UTC](https://discuss.elastic.co/t/unable-to-add-index-for-parsed-data-from-elastic-search-index-management/203005/2 "2019-10-10T19:01:04Z")

</div>

Can you check both the Kibana and Elasticsearch logs when you're attempting to create that index pattern?

---

<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:** [November 7, 2019, 7:01pm UTC](https://discuss.elastic.co/t/unable-to-add-index-for-parsed-data-from-elastic-search-index-management/203005/3 "2019-11-07T19:01:10Z")

</div>

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