DBConnect parameter 1 error with rising input

[nick405060]

3.1.3, gives me a java.sql.SQLException: Invalid parameter index 1. error, or a Parameter #1 has not been set error. Any clues? I'm literally just trying to do the most basic rising input possible for a SELECT * query and I had the same issue with another database last week, which all of a sudden started working.

[nick405060 · Accepted solution]

The app interface claims to populate the SQL query template for you on the right-hand side, but it does so incorrectly: it only populates half of it. It populates the rising column in the query template but not the table name. Select the table, select batch type rising, select the rising column, copy and paste the SQL template into the SQL section but modify the table name.

It sounds like a silly problem that you should have caught, but it's not. The app claims to populate the SQL query template for you, but it only populates part of it. Ridiculously unexpected. For anyone having this problem, this is a Splunk QA team problem not a user problem.