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!
Extending Observability Content to Splunk Cloud
Watch Now!
In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...
More Control Over Your Monitoring Costs with Archived Metrics!
What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...
New in Observability Cloud - Explicit Bucket Histograms
Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...
