topic Re: db connect doesn't see table in Splunk Search

db connect doesn't see table

a212830 — Fri, 26 Apr 2013 01:18:22 GMT

Hi,

I have a database input issue. I setup the database connection, and run a tail command, but it keeps telling me that the table or view doesn't exist. It does exist, and I do have permissions to see it. I can see it when I query it via the DB Connect -> DB Info, and when I look at it via Oracle SQL Developer.

Any suggestions?

Re: db connect doesn't see table

Jason — Fri, 26 Apr 2013 11:46:51 GMT

If you can query the table/view using the DB Connect -> DB Query dashboard in Splunk, try setting up the database tail by selecting the "enter SQL" in the manager screen for the tail.

Re: db connect doesn't see table

a212830 — Fri, 26 Apr 2013 13:31:58 GMT

Tried it - still fails with view/table not found. The same query will work from db connect - db query.