Splunk Enterprise
Highlighted

DB-connect

Communicator
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

Communicator

@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

Communicator
 
0 Karma
Highlighted

Re: DB-connect

Communicator

@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

Communicator

@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
Speak Up for Splunk Careers!

We want to better understand the impact Splunk experience and expertise has has on individuals' careers, and help highlight the growing demand for Splunk skills.