Earthdata Forum

In modules.ancDB.insert_record, the status and attephstat fields in the satfiles table of the ancillary DB are updated for all the records instead of just the record that is being modified. Lines 95 to 98 should be changed to:
           if atteph:
               c.execute('''UPDATE satfiles
                                 SET attephstat = ?
                                 WHERE satid = ?''', [dbstat, satid])
         else:
               c.execute('''UPDATE satfiles
                                 SET status = ?
                                 WHERE satid = ?''', [dbstat, satid])

Thanks :grin:
We'll see about adding this fix to the next update.

Sean

This issue might be related, because as a consequence the satfiles table remains on a state determined by the latest inserted record. So if this was missing some optimal anc files, a query for any other sat file will return the same result even if its corresponding anc files are present, hence leaving the DB in an inconsistent state. And the result for the same sat file will be different if queried after the insertion of another sat file for which all associated optimal anc files exist.