Splunk Enterprise
Highlighted

DB-connect

Contributor
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.
0 Karma
Highlighted

Re: DB-connect

Contributor

@vijaysri 

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.

0 Karma
Highlighted

Re: DB-connect

Contributor
 
0 Karma
Highlighted

Re: DB-connect

Contributor

@vijaysri 

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 ? 

0 Karma
Highlighted

Re: DB-connect

Contributor

@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.

0 Karma