topic Re: DB-connect in Splunk Enterprise

DB-connect

VijaySrrie — Mon, 22 Jun 2020 02:33:33 GMT

Hi, I am trying to connect to Database using DB connect. When I choose Input type as Batch --> I am able to fetch the database and able to see the logs But when I choose as Raising --> with raising column --> access_timestamp I am getting this error --> org.postgresql.util.PSQLException: No value specified for parameter 1. Please let me know how to proceed further.

Re: DB-connect

anilchaithu — Mon, 22 Jun 2020 22:38:45 GMT

@VijaySrrie

you should use initial check point value (part of the query) for this field "access_timestamp ". Then the query uses this as checkpoint and fetches the data after that.

Re: DB-connect

VijaySrrie — Mon, 29 Jun 2020 09:12:29 GMT

Re: DB-connect

anilchaithu — Mon, 29 Jun 2020 16:15:36 GMT

@VijaySrrie

The query looks good. what about the settings?

I assume you are using access_timestamp as rising column. Did you set up the initial check point value for this field ?

Re: DB-connect

VijaySrrie — Tue, 30 Jun 2020 00:25:09 GMT

@anilchaithu - I used access_timestamp but the query was not working with rising column, so we have added one more select statement in the start of the query. Now it is working fine.