The problem is caused by Splunk line-break heuristics.
Issues with bad line breaking/line merging Then, copy those settings to DB Connect and try again. Use one of these tools to connect to the database and ensure that connectivity is good, host and port are correct, and that your credentials work.
Is the right JDBC driver being loaded? To find out, in DB Connect, click Configuration in the top navigation bar, Settings, and Drivers to view the driver status screen.
If necessary, download a newer version of the driver. Verify that the driver and the driver version are supported by looking for them in Supported databases.
Database and Splunk Enterprise administrators should work together to determine the optimal logging setup for their environment and decide how to handle special scenarios like troubleshooting. For example, by default non-administrators can't access _internal. You can control access to logged events by limiting access to the _internal index using Splunk Enterprise roles. To view DB Connect logging activity, use a search command such as the following:
You can also see whether DB Connect is generating any internal errors, using a search with the following parameters: For more information about the health dashboard, see Monitor database connection health. The health dashboard is a pre-configured dashboard that allows you to monitor and troubleshoot several aspects of your database connections from inside Splunk Enterprise. When you're trying to figure out the cause of degraded performance or figure out how failure rates correspond to transaction type or database user, the place to start is the health dashboard in Splunk DB Connect. Have questions? In addition to these troubleshooting tips, visit Questions related to Splunk DB Connect on Splunk Answers to see what questions and answers the Splunk community has about using Splunk DB Connect.
If the Troubleshooting Tool for DB Connect does not solve your issue, try the following steps. This topic describes how to troubleshoot common Splunk DB Connect issues.