# Unable to export data to elastic search

**URL:** <https://discuss.elastic.co/t/unable-to-export-data-to-elastic-search/87869>\
**Category:** Elasticsearch\
**Created:** [June 1, 2017, 9:21am UTC](https://discuss.elastic.co/t/unable-to-export-data-to-elastic-search/87869 "2017-06-01T09:21:07Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ent\_1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ent_1/32/25549_2.png) [@ent\_1](https://discuss.elastic.co/u/ent_1)\
**Post date:** [June 1, 2017, 9:21am UTC](https://discuss.elastic.co/t/unable-to-export-data-to-elastic-search/87869/1 "2017-06-01T09:21:07Z")

</div>

log4j:WARN No appenders could be found for logger (org.elasticsearch.plugins).  
log4j:WARN Please initialize the log4j system properly.  
log4j:WARN See [http://logging.apache.org/log4j/1.2/faq.html#noconfig](http://logging.apache.org/log4j/1.2/faq.html#noconfig) for more info.  
Driver Correct  
Connection Succesful  
NoNodeAvailableException[None of the configured nodes are available: [{#transport#-1}{00.00.00.100}{00.00.00.100:9300}]]  
at org.elasticsearch.client.transport.TransportClientNodesService.ensureNodesAreAvailable(TransportClientNodesService.java:290)  
at org.elasticsearch.client.transport.TransportClientNodesService.execute(TransportClientNodesService.java:207)  
at org.elasticsearch.client.transport.support.TransportProxyClient.execute(TransportProxyClient.java:55)  
at org.elasticsearch.client.transport.TransportClient.doExecute(TransportClient.java:288)  
at org.elasticsearch.client.support.AbstractClient.execute(AbstractClient.java:359)  
at org.elasticsearch.client.support.AbstractClient.execute(AbstractClient.java:348)  
at org.elasticsearch.client.support.AbstractClient.index(AbstractClient.java:366)  
at com.syrajson.test.TestSyra.main(TestSyra.java:81)

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [June 1, 2017, 9:24am UTC](https://discuss.elastic.co/t/unable-to-export-data-to-elastic-search/87869/2 "2017-06-01T09:24:22Z")

</div>

> [@ent\_1](#):
>
> 00.00.00.100

This looks like an unusual IP address. Is this really correct?

---

<div class="post-metadata">

**Author:** ![ent\_1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ent_1/32/25549_2.png) [@ent\_1](https://discuss.elastic.co/u/ent_1)\
**Post date:** [June 1, 2017, 9:26am UTC](https://discuss.elastic.co/t/unable-to-export-data-to-elastic-search/87869/3 "2017-06-01T09:26:20Z")

</div>

Ip addres is not correct .. actual ip address is different

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [June 1, 2017, 9:28am UTC](https://discuss.elastic.co/t/unable-to-export-data-to-elastic-search/87869/4 "2017-06-01T09:28:15Z")

</div>

Is it reachable from the host you are logging from?

---

<div class="post-metadata">

**Author:** ![ent\_1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ent_1/32/25549_2.png) [@ent\_1](https://discuss.elastic.co/u/ent_1)\
**Post date:** [June 1, 2017, 9:29am UTC](https://discuss.elastic.co/t/unable-to-export-data-to-elastic-search/87869/5 "2017-06-01T09:29:59Z")

</div>

Yes i am able to reach with my shell script and able to load the data into elastic search.

i am trying to load the data using java api .. my program failed to load the data into elastic search

```
	int count = 0;
	String ipAddress = "00.00.00.100"; // actual ip address is different 
	Settings settings = /*Immutable*/Settings.settingsBuilder()
            .put("client.transport.sniff",true)
            .build();
	
	Client client = new TransportClient.Builder().settings(settings).build()
    .addTransportAddress(new InetSocketTransportAddress(InetAddress.getByName(ipAddress),9300));
	

	Connection connection = DatabasePlugin.getBRMConnection();
	try {
	
		String sql = "select name,poid_id0,descr from product_t";

		PreparedStatement preStatement = connection.prepareStatement(sql);

		ResultSet result = preStatement.executeQuery();

	
		while (result.next() && count < 1000) {
			
			JSONArray jsArr = convert(result);
			for (int i = 0; i < jsArr.length(); i++) {
				JSONObject jsObj = jsArr.getJSONObject(i);
				Product product = new Product();
				product.setName(jsObj.getString("NAME"));
				product.setPoidId0(jsObj.getInt("POID_ID0"));
				product.setDescr(jsObj.getString("DESCR"));
				
				IndexRequest indexRequest = new IndexRequest("catalogue_data1","product", UUID.randomUUID().toString());
				indexRequest.source(new Gson().toJson(product));
				IndexResponse response = client.index(indexRequest).actionGet();
				System.out.println(response.getIndex());
			    System.out.println(response.getType());
			    System.out.println(response.getVersion());
			}
```

---

<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:** [June 29, 2017, 9:30am UTC](https://discuss.elastic.co/t/unable-to-export-data-to-elastic-search/87869/6 "2017-06-29T09:30:09Z")

</div>

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