Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
All Apps and Add-ons
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Apps and Add-ons
- :
- All Apps and Add-ons
- :
- The lookup table for Splunk app does not exist whe...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark Topic
- Subscribe to Topic
- Mute Topic
- Printer Friendly Page
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
cbahor
Splunk Employee
04-27-2017
05:59 PM
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
woodcock
Esteemed Legend
04-07-2017
11:46 AM
Did you run the configuration for app?
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Get Updates on the Splunk Community!
Join Us for Splunk University and Get Your Bootcamp Game On!
If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...
.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!
.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...
Announcing Scheduled Export GA for Dashboard Studio
We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...
