All Apps and Add-ons

In the Splunk DB Connect app, after indexing data from my Oracle DB, Why doesn't Splunk recognize field-value pairs?

marziaolla
Path Finder

Hello there,
I got an issue with Splunk DB Connect app.
After indexing data from my Oracle DB, Splunk doesn't recognize field-value pairs

I got an event like that:

06/02/2018, Name=myname, Date_of_birth=24/10/1987

In the interesting fields I don't find the field name and Date_of_birth but only index, linecount and punct.

How can I solve my problem?

Tnx

0 Karma
1 Solution

harsmarvania57
Ultra Champion

As this data is not in CSV format, can you please change sourcetype to some custom sourcetype??

View solution in original post

0 Karma

harsmarvania57
Ultra Champion

As this data is not in CSV format, can you please change sourcetype to some custom sourcetype??

0 Karma

marziaolla
Path Finder

i solved the issue using a custom sourcetype.

Tnx so much for the help 🙂

0 Karma

harsmarvania57
Ultra Champion

I have converted my comment to answer so you can accept/upvote it.

0 Karma

harsmarvania57
Ultra Champion

Are you running your search in fastmode ? Try to change it to Smartmode or Verbosemode.

0 Karma

marziaolla
Path Finder

Hi,
the search is running in verbose mode.

0 Karma

harsmarvania57
Ultra Champion

Can you please double check whether are you getting data in double quote or not ? Like this 06/02/2018, Name="myname", Date_of_birth="24/10/1987"

Because when I tried to fetch data from Oracle database all fields with value coming in double quotes as mentioned above.

0 Karma

marziaolla
Path Finder

Hi,
data are getting in with double quote as mentioned 🙂

0 Karma

harsmarvania57
Ultra Champion

What sourcetype are you using for this data ? Any props.conf or transforms.conf present for that sourcetype ?

0 Karma

marziaolla
Path Finder

i'm using CSV sourcetype

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...