Unable to retrieve data from Oracle sample table using Logstash

Elastic Stack Logstash
1 

Hi All, I am very new to Elastic . i was following a blog and video which describes step by step of how to configure create a simple db table and to retrieve values from table using logstash and to display in kibana portal. 

All in windows environment

1. I have configured a employee_config.conf file
input {
    jdbc {
     clean_run => true
        jdbc_driver_library => "C:\Tools\ojdbc8-19.3.0.0.jar"
        jdbc_driver_class => "oracle.jdbc.driver.OracleDriver"
        jdbc_connection_string => "jdbc:oracle:thin:@xxxx:xxxx:xxx"
        jdbc_user => "KIBANA"
        jdbc_password => "xxxxxxxx"
        #schedule => "* * * * *"
        statement => "select * from EMPLOYEE"
        use_column_value => true
        #tracking_column => "category"
        tracking_column => "LAST_NAME"
    }
}
filter {
  mutate {
    remove_field => ["@version"]
  }
}
output{
    elasticsearch { 
        hosts => ["http://localhost:9200/"]
        index => "employee_idx"
        user => "elastic"
        password => "xxxxxxx"
        ssl => false
        ssl_certificate_verification => false
    }
    
}

2. Already there are few rows in the oracle table.

3. Then I tried to start the elasticsearch but then i m getting this below error

ERROR][o.e.i.g.GeoIpDownloader  ]exception during geoip databases updatejavax.net.ssl.SSLHandshakeException:
 PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException:
 unable to find valid certification path to requested target

But i can able to get the json sample resposne from the default URL(http://localhost:9200)

5. I have started Kibana and there are no issues in the portal.

6. I tried to execute the command logstash and i dont see any error either.

7.When i try to log to kibana portal under management-->dev tools--> and then i just want to execute  GET employee_idx/_search  inorder to get the response from Employee table as a json.

But i am getting the result as below

{
  "error": {
    "root_cause": [
      {
        "type": "index_not_found_exception",
        "reason": "no such index [employee_idx]",
        "resource.type": "index_or_alias",
        "resource.id": "employee_idx",
        "index_uuid": "_na_",
        "index": "employee_idx"
      }
    ],
    "type": "index_not_found_exception",
    "reason": "no such index [employee_idx]",
    "resource.type": "index_or_alias",
    "resource.id": "employee_idx",
    "index_uuid": "_na_",
    "index": "employee_idx"
  },
  "status": 404
}

Is there anything that i have missed or need to add. Please see i am new to this topic and following some blogs and video which are organised for a begineer.

Please guide/help.

Best Regards,
Ram
2

Hi @sundarcdm1, Welcome to the Elastic community.

  1. Which version of Elasticsearch you are running ? Is it setup with certificate ? If https://localhost:9200 giving response, which means it is disabled.
  2. index_not_found_exception: As mentioned there is no such index. you need to first solve Elasticsearch error.