All Apps and Add-ons

DB Connect - Data Input Query and Error Received of - DB Input definition cannot continue with an empty table in Rising Column mode

EmEdwards
Path Finder

I'm new to using Splunk so please could someone clarify this issue for me.
I added data using DB connect to a SQL Server view.
The first time I added a Data Input I used Batch Input as my selection of Data which is a list of people lets say....
On later querying this data is Search and Reporting I had numerous duplicates for Individuals which messed up my result set.
So I tried a new Data Input using a Rising column of a unique primary key of PeopleID for example.

Today on checking the Data Input has not added any NEW records and is displaying an error of
DB Input definition cannot continue with an empty table in Rising Column mode

The Rising Column is a Primary Key and does not contain any empty values in source.
On running the view it's connecting to there are new records which have not been added.

Please can someone explain how I use a Data Input that will add new records or updated records ?

Thanks

0 Karma

EmEdwards
Path Finder

Hi, this post was some time back. To be honest I ended up going back to an older version of DBX and this resolved the problem I had.
In the older version I use at the moment I only have a select on the table as the query with no where clause or order by needed, then in the UI you specify the rising column from a drop down field and DBX does the rest.
In the newer versions I think I tested removing the order by clause and this too made a difference. Good luck.

0 Karma

EmEdwards
Path Finder

Oh and sorry the query I'm using for DB connect and the rising column looks a bit like this example ;

SELECT *
FROM "Utilities"."dbo"."People"
Where PeopleID >?
ORDER BY PeopleID asc

0 Karma

wsmworkhard
Explorer

I have the same issue. And my SQL query looks like yours (Date>? ORDER BY Date asc)
Does this happen because no PeopleID greater than current checkpoint value found in database? (no more data in DB)

0 Karma
Get Updates on the Splunk Community!

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...

DevSecOps: Why You Should Care and How To Get Started

 WATCH NOW In this Tech Talk we will talk about what people mean by DevSecOps and deep dive into the different ...

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...