I created a Transaction Group to store cycle data to a table. My customer is querying this table to transfer the data to his system. He uses the _ndx column to detect new data. We are seeing this column reset to a lower number sometimes. It remains unique but is not always higher than a previous record.
How does the TG generate the _ndx data?
It's usually the database engine that does that automatically. (The INSERT query normally doesn't pass any data to that column.)
What engine are you using?
MySQL