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

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

1240062 — Tue, 29 Sep 2020 16:55:43 GMT

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.

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

jplumsdaine22 — Tue, 29 Sep 2020 16:52:25 GMT

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

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

1240062 — Wed, 22 Nov 2017 16:19:15 GMT

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.

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

jplumsdaine22 — Wed, 22 Nov 2017 16:33:27 GMT

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