DB Connect ignoring rising column and pulls all rows after initial checkpoint value for every query.

[att35]

Hi,

I am using DB Connect V2(Configured on Indexer) to pull data from MSSQL Database with timestamp as the Rising Column. Data in the preview looks good but once the input is saved, each query pulls everything from the checkpoint timestamp onward instead of pulling only the rows that were added after the last updated checkpoint.

SELECT COLUMN1,
         COLUMN2,
         COLUMN3,
         COLUMN4,
         TIMESTAMP
FROM <Table_Name>
WHERE TIMESTAMP > ?
ORDER BY  TIMESTAMP DESC

Is there anything else I am missing in the configuration?

~ Abhi

[Richfez]

Shouldn't those be

ORDER BY <checkpointfieldname> ASC

?

I'd have to whip open my own DB connect to confirm, but hopefully that's all this is.

[att35]

To test, I edited the checkpoint value manually and set it to the current time. After saving, the input started working properly and checkpoint was getting updated with the latest data but after a while it again went back to the old checkpoint value I had set.

[vsingla1]

@abhijittikekar I am also facing the same issue. Did you get a solution to your issue?