All Apps and Add-ons
Highlighted

splunk db connect index1 out of range error

Path Finder

Hi,

we useing db connect to read data from a MS SQL CMDB. We where able to create a valid connction and Identity. If we create a Batch Input they will be no errors but if we change to rising then the MS jdbc driver thows this error:

com.microsoft.sqlserver.jdbc.sqlserverexception the index 1 is out of range.

my first though was to give the filed "checkpoint value" a value but it change nothing...

any idears?

Thanks!!!

Highlighted

Re: splunk db connect index1 out of range error

Path Finder

Did you enter the actual value for the checkpoint value in the query? I did this and was getting the same error until I changed it to a question mark

Highlighted

Re: splunk db connect index1 out of range error

Engager

Thanks, this helped 🙂

Highlighted

Re: splunk db connect index1 out of range error

Explorer

After the 5.10 schema upgrade, having two databases to modify my table query pointers, and getting the index 1 error, I figured out that you have to unlock the pointer and set it to zero because you are starting the index from scratch and the pointer (AutoID) had no place to start. This fixed my error and allowed me to continue to the last step and save the query. I did have to take the line pull up to 100,000 lines to catch up in a hurry.

0 Karma
Highlighted

Re: splunk db connect index1 out of range error

Path Finder

i had the same issue - see https://answers.splunk.com/answers/569404/unable-to-configure-an-input-on-splunk-db-connect.html,i got the same issue and ended up using the '?' in the SQL query and this worked.

e.g.

SELECT *
FROM "SQLAuditLogs"."dbo"."AuditInfra"
WHERE event
time > ?
ORDER BY event_time ASC

View solution in original post

Highlighted

Re: splunk db connect index1 out of range error

Communicator

Question mark did not work for me. 0_o

0 Karma
Highlighted

Re: splunk db connect index1 out of range error

Engager

The question mark did work for me - thanks!

0 Karma
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.