All Apps and Add-ons

Where can I look to find out why an Oracle dbconnect is failing?

New Member

I have verified the connection is sound, and when I go through the GUI creating/editing the input, it pulls data. But nothing is coming into the indexer and there appears to be an error. So, where do I find out what the actual error is?.

2018-02-28 15:30:47.058 -0800 INFO c.s.dbx.server.task.listeners.JobMetricsListener - action=collectjobmetrics connection=MYDATABASEReport jdbcurl=null recordreadsuccesscount=674 dbreadtime=47048 recordreaderrorcount=1 hecrecordprocesstime=8 formathecsuccesscount=674 status=FAILED inputname=MYDATABASEReport batchsize=1000 errorthreshold=N/A isjmxmonitoring=false starttime=2018-02-2803:30:00 endtime=2018-02-2803:30:47 duration=47057 readcount=2696 writecount=0 filteredcount=0 errorcount=0

I've used two other methods to get this data, both through TOAD (our oracle UI) and a home-grown data extract tool on a remote server.

Any help would be appreciated.

Thanks.

0 Karma

New Member

So...in this particular case the part

recordreadsuccess_count=674

was indicative of an error at row 675. I fixed that. Now I am getting this:

2018-03-01 14:51:12.868 -0800 INFO c.s.dbx.server.task.listeners.JobMetricsListener - action=collectjobmetrics connection=MYDATABASEReport jdbcurl=null status=FAILED inputname=MYDATABASEReport batchsize=1000 errorthreshold=N/A isjmxmonitoring=false starttime=2018-03-0102:50:00 endtime=2018-03-0102:51:12 duration=72866 readcount=6066 writecount=0 filteredcount=0 errorcount=0

I thought maybe there would be an issue with record number 6067 but its nearly identical to the 6066 implied in the message.

Anyone know where I can find splunk's reason for failure?

0 Karma

Motivator

Hi there mate, any update on this? I'm struggling with something very similar to this.

0 Karma