All Apps and Add-ons

DB Connect - No value specified for parameter 1

vpsmax
Path Finder

Hello.

Currently, we are trying to get a new SQL query to function within DB Connect.  The SQL query runs against a Postgres database.  Although the SQL query runs fine in batch mode, it is not running so well when setting up the same in rising mode.  Attached is a screenshot of the error message we are receiving.

created_at.png

We tried setting the rising column as "created_at".  Also, we tried adding the following lines to the SQL query:

  • AND created_at > ?
  • ORDER BY created_at ASC

But we receive error messages:

  • org.postgresql.util.PSQLException: No value specified for parameter 1.
  • org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.

Can someone suggest the best approach to resolving this?

Regards,
Max

 

Labels (2)
Get Updates on the Splunk Community!

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...

Introducing Splunk Enterprise 9.2

WATCH HERE! Watch this Tech Talk to learn about the latest features and enhancements shipped in the new Splunk ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...