We're trying to use DB Connect 2 with a query that's using SELECT MAX(column) to pull a single value every 5 minutes. The input setup is able to return a value without issue and the Health dashboard is showing the transactions are running according to schedule successfully, but no data is being populated in the index. I also looked at the _internal index and log files for dbx errors, but there are only normal informational/debug messages.
Thanghals,
Does your db input definitions are in dbconnect app or the app where definitions are, share objects globally ?
You may try to solve this issue by moving inputs definition inside dbconnect2 app.