All Apps and Add-ons
×

Join the Conversation

Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
Ask a Question

The lookup table for Splunk app does not exist when searching Hadoop

suarezry
Builder
‎04-06-2017 10:46 AM

Greetings,

We are running Splunk Enterprise v6.5.3 with Hortonworks HDP v2.5. We have just installed the Splunk Add-on for Microsoft SQL Server. Now everytime I search Hadoop I am getting the following error on the splunk browser:

[myHadoopProvider] [hadoop-datanode1] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:execution:dm_exec_query_stats'.
[myHadoopProvider] [hadoop-datanode1] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:execution:dm_exec_sessions'.
[myHadoopProvider] [hadoop-datanode1] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:instance'.
[myHadoopProvider] [hadoop-datanode1] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:instancestats'.
[myHadoopProvider] [hadoop-datanode1] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:os:dm_os_performance_counters'.
[myHadoopProvider] [hadoop-datanode1] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:os:dm_os_sys_info'.
[myHadoopProvider] [hadoop-datanode1] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:table'.
[myHadoopProvider] [hadoop-datanode1] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:transaction:dm_tran_locks'.
[myHadoopProvider] [hadoop-datanode1] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:user'.
[myHadoopProvider] [hadoop-datanode3] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:execution:dm_exec_query_stats'.
[myHadoopProvider] [hadoop-datanode3] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:execution:dm_exec_sessions'.
[myHadoopProvider] [hadoop-datanode3] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:instance'.
[myHadoopProvider] [hadoop-datanode3] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:instancestats'.
[myHadoopProvider] [hadoop-datanode3] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:os:dm_os_performance_counters'.
[myHadoopProvider] [hadoop-datanode3] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:os:dm_os_sys_info'.
[myHadoopProvider] [hadoop-datanode3] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:table'.
[myHadoopProvider] [hadoop-datanode3] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:transaction:dm_tran_locks'.
[myHadoopProvider] [hadoop-datanode3] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:user'.
[myHadoopProvider] [hadoop-datanode4] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:execution:dm_exec_query_stats'.
[myHadoopProvider] [hadoop-datanode4] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:execution:dm_exec_sessions'.
[myHadoopProvider] [hadoop-datanode4] The lookup table 'sqlserver_host_dbserver_lookup' does not exist. It is referenced by configuration 'mssql:instance'.

How do I fix this?

0 Karma
Reply

cbahor
Splunk Employee
Splunk Employee
‎04-27-2017 05:59 PM

Have you tried this fix?

https://answers.splunk.com/answers/421957/splunk-add-on-for-microsoft-sql-server-the-lookup.html#ans...

0 Karma
Reply

woodcock
Esteemed Legend
‎04-07-2017 11:46 AM

Did you run the configuration for app?

Reply

gambler
New Member
‎04-18-2017 02:11 AM

I'm getting a similar error. Appears to be when a hadoop search references something in the KVSTORE.

0 Karma
Reply
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!

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas

Why Splunk Customers Should Attend Cisco Live 2026 Las Vegas     Cisco Live 2026 is almost here, and this ...

What Is the Name of the USB Key Inserted by Bob Smith? (BOTS Hint, Not the Answer)

Hello Splunkers,   So you searched, “what is the name of the usb key inserted by bob smith?”  Not gonna lie… ...

Automating Threat Operations and Threat Hunting with Recorded Future

    Automating Threat Operations and Threat Hunting with Recorded Future June 29, 2026 | Register   Is your ...