All Apps and Add-ons

Splunk DB Connect connection to Hana - Unable to open record reader

rajeshmeea21
Explorer

Hello All,

We are getting following error while connecting to HANA database using Splunk DB Connect App.

I have followed the instructions given in this post

https://answers.splunk.com/answers/583196/splunk-db-connect-connection-to-hana.html

Error log sample.

2018-01-23 11:20:52.412 +1100  [QuartzScheduler_Worker-6] INFO  org.easybatch.core.job.BatchJob - Job 'HanaInput' starting
2018-01-23 11:20:52.412 +1100  [QuartzScheduler_Worker-6] INFO  org.easybatch.core.job.BatchJob - Batch size: 1,000
2018-01-23 11:20:52.412 +1100  [QuartzScheduler_Worker-6] INFO  org.easybatch.core.job.BatchJob - Error threshold: N/A
2018-01-23 11:20:52.412 +1100  [QuartzScheduler_Worker-6] INFO  org.easybatch.core.job.BatchJob - Jmx monitoring: false
2018-01-23 11:20:52.413 +1100  [QuartzScheduler_Worker-6] INFO  c.s.d.s.dbinput.recordreader.DbInputRecordReader - action=db_input_record_reader_is_opened input_task="HanaInput" query=SELECT key, value FROM sys.m_host_information;
2018-01-23 11:20:52.418 +1100  [QuartzScheduler_Worker-6] ERROR org.easybatch.core.job.BatchJob - Unable to open record reader
java.lang.NullPointerException: null
    at com.splunk.dbx.server.dbinput.recordreader.DbInputRecordReader.isOracleInput(DbInputRecordReader.java:111)
    at com.splunk.dbx.server.dbinput.recordreader.DbInputRecordReader.getRowProcessor(DbInputRecordReader.java:105)
    at com.splunk.dbx.server.dbinput.recordreader.DbInputRecordReader.open(DbInputRecordReader.java:89)
    at org.easybatch.core.job.BatchJob.openReader(BatchJob.java:117)
    at org.easybatch.core.job.BatchJob.call(BatchJob.java:74)
    at org.easybatch.extensions.quartz.Job.execute(Job.java:59)
    at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
2018-01-23 11:20:52.418 +1100  [QuartzScheduler_Worker-6] INFO  org.easybatch.core.job.BatchJob - Job 'HanaInput' finished with status: FAILED

Any idea?

peter_krammer
Communicator

Hi, for me the Problem was solved by updating the Splunk DB Connect app to version 3.1.3.

0 Karma

peter_krammer
Communicator

Have you solved your Problem in the meantime? I got the same issue.

0 Karma
Get Updates on the Splunk Community!

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Wednesday, May 29, 2024  |  11AM PST / 2PM ESTRegister now and join us to learn more about how you can ...

Get Your Exclusive Splunk Certified Cybersecurity Defense Engineer Certification at ...

We’re excited to announce a new Splunk certification exam being released at .conf24! If you’re headed to Vegas ...