topic Re: Database lookup says its table doesn't exist in Splunk Search

Database lookup says its table doesn't exist

redc — Tue, 25 Mar 2014 18:37:39 GMT

I'm attempting to create my first database lookup. I followed this documentation, choosing to specify the fields directly (only need one field): http://docs.splunk.com/Documentation/DBX/1.0.11/DeployDBX/Setupadatabaselookuptable

I gave it a name (HDMCF), specified a SQL database and the table name, selected the one field I want to be put into the lookup (ValueDesc), and saved it. Everything looks good.

When I try to search on it, I get an error that the lookup table doesn't exist:

| lookup HDMCF ValueDesc

Output:

Error in 'lookup' command: The lookup table 'HDMCF' does not exist.

What am I missing? Does there need to be a lookup definition for it (and if so, how do I set that up)?

Re: Database lookup says its table doesn't exist

devicenul1 — Wed, 14 May 2014 14:31:06 GMT

Having the exact same issue, anyone have any ideas? The documentation leaves a lot to be desired.

Re: Database lookup says its table doesn't exist

redc — Wed, 04 Jun 2014 20:34:52 GMT

When I configured the lookup, the table I used needed to be "dbo.tablename" (rather than just "tablename"). After changing the lookup to use "dbo.tablename", I stopped getting this error.