getting error like "java.sql.SQLException: Missing IN or OUT parameter at index:: 2". Can you please troubleshoot?

[1240062]

SELECT A.* FROM "STG_CONTACT"."CRMTRC_CONVERSION_EVENT" A where A.CRMTRC_TIMESTAMP> ? and A.CRMTRC_TIMESTAMP< ?+5 order by CRMTRC_TIMESTAMP

I am getting error while iam running data input. Any help can be appreciated.

[jplumsdaine22]

Sounds like the second ? is not getting filled. I'm not sure that splunk will use every instance of the ?, so you'll need to rewrite your query.

However, as you want to limit your results to the 5 results after your checkpoint value, you could use the max_rows parameter in the db_inputs.conf file instead. Just use max_rows = 6 and change your query to be

SELECT A.* FROM "STG_CONTACT"."CRMTRC_CONVERSION_EVENT" A where A.CRMTRC_TIMESTAMP> ? order by CRMTRC_TIMESTAMP

[1240062]

Thank you , but...here Check point is date that I have given. +5 means from that check point it adds 5 days to that date. So , how can I write? I need data between the two dates.

[jplumsdaine22]

ah right. Is there a reason you want a window? Usually with an input you would want all the latest data from the table