All Apps and Add-ons

Splunk DB Connect character encoding problem

Path Finder



I found a problem in Splunk DB connect when I tried to add a new input.

I can add new connections and the current inputs are working.

But when I try to add new input or try to use the “SQL Explorer” after choosing connection I get a “Cannot get schemas“ error message.

In the _internal index I found this error message: „Unable to get schemas metadata java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): EE8ISO8859P2”

After this I updated DB Connect and the Oracle JDBC drivers but it did not help.

I consulted our DB admins. As it turned out these DBs really differ when it comes to character encoding (EE8ISO8859P2 vs. UTF8).

Of course the orai18n.jar file is there with the driver.

I found this in the documentation:

"Splunk DB Connect requires you to set up your database connection to return results encoded in UTF-8. Consult your database vendor's documentation for instructions about how to do this."

Is it possible that DB Connect can only handle Oracle DB with UTF-8 encoding?





Labels (1)
0 Karma
Get Updates on the Splunk Community!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...