splunk db connect: java.lang.StringIndexOutOfBoundsException: String index out of range

[vijaynsheth]

Splunk Enterprise: 7.2.5
Using Splunk DB Connect for Oracle and running into error when adding an Input and on "execute SQL"
message: java.lang.StringIndexOutOfBoundsException: String index out of range

Looked at various Answers but don't see any solution

[markvanber]

Since the string stores an array of characters, just like arrays the position of each character is represented by an index (starting from 0). If you try to access the character of a String at the index is either negative or greater than the size of the string, a StringIndexOutOfBoundsException is thrown. For some methods such as the java substring, charAt method, this exception also is thrown when the index is equal to the size of the string.

How to solve the StringIndexOutOfBoundsException

• Check the length of the string before using substring()
• Exception handling using try...catch.

[Prewin27]

Check your query.

https://docs.oracle.com/javase/8/docs/api/index.html?java/lang/StringIndexOutOfBoundsException.html