Database Module troubleshooting
Verify Index Data
Verify add-on setup and input configuration is done properly for the DB Connect 2, Windows and Unix/Linux by searching for index, sources, and source types.
|Add-on||Example Index Verification Search|
|DB Connect 2|
|Add-on for Windows|
|Add on for Unix and Linux|
The table below displays searches that can verify module entity and KPI data.
Note: Check fields used for Database KPIs, (deadlock_rate, instance_read_iops, instance_write_iops, response_time, connections, connection_pool_used_percent, transaction_rate).
Cannot connect to database using DB Connect 2
To connect to your database using DB Connect 2, the corresponding JDBC driver needs to be copied over to the
C:\Program Files\Splunk\etc\apps\splunk_app_db_connect\bin\lib location. For SQLServer, you can download the driver from the SQLServer web site.
Cannot conduct MySql Database Queries on mysql_variables
MySql Database Queries on mysql_variables fail if
@@global.show_compatibility_56 is not set. To fix this issue:
set @@global.show_compatibility_56 to "ON" against the MySql database in question.
Query data delay
If you experience query data delays when using Splunk DB Connect 2 with the Splunk Add-on for Oracle, this issue could happen because of:
- Network issues between your Oracle server and your Splunk platform deployment.
- Dropped connectivity between your Splunk platform deployment and Splunk DB Connect 2.
The problem exists only with query data. All other inputs (
oracle:connections) generate data normally. Query data might not be found for several hours, but data will eventually appear. Restarting your Splunk can also speed up this process.
Entities not found
When you are unable to locate operating system entities, see ITSI module troubleshooting section on entities.
Troubleshooting entity appearance speed
It will take about an hour to start seeing a full sparkline chart and for KPIs to become active. For more information, see entity appearance speed.
Metrics not collected
If you are unable to view your data, run the data model audit to make sure your data models are processing your data.
If you are running into issues seeing your KPI data, see ITSI module troubleshooting section on KPIs.
If a user encounters a permission-related obstacle, the issue could be related to their assigned role.
ITSI permissions are determined by the role that each user has. Each role offers a different set of user permissions.
See ITSI module troubleshooting to learn about permissions within ITSI.
Learn about adding navigation to a Splunk app.
Database Module data model reference table
About the End User Experience Monitoring Module
This documentation applies to the following versions of Splunk® IT Service Intelligence: 4.0.0, 4.0.1, 4.0.2, 4.0.3, 4.0.4, 4.1.0, 4.1.1, 4.1.2, 4.1.5, 4.2.0, 4.2.1, 4.2.2, 4.2.3, 4.3.0, 4.3.1, 4.4.0, 4.4.1, 4.4.2, 4.4.3, 4.4.4, 4.4.5, 4.5.0 Cloud only, 4.5.1 Cloud only, 4.6.0 Cloud only, 4.6.1 Cloud only, 4.6.2 Cloud only, 4.7.0, 4.7.1, 4.7.2, 4.7.3, 4.7.4, 4.8.0 Cloud only, 4.8.1 Cloud only, 4.9.0, 4.9.1, 4.9.2, 4.9.3, 4.9.4, 4.9.5, 4.9.6, 4.10.0 Cloud only, 4.10.1 Cloud only, 4.10.2 Cloud only, 4.10.3 Cloud only, 4.10.4 Cloud only, 4.11.0, 4.11.1, 4.11.2, 4.11.3, 4.11.4, 4.11.5, 4.11.6, 4.12.0 Cloud only, 4.12.1 Cloud only, 4.13.0, 4.13.1, 4.14.0 Cloud only