As Jul 1 2022 build, it is spotted in the _init_bis_devdb step that the records by job number is no longer unique after filtering down the doc # ==1. This cause a series of downstream issue:
the unique id create from ogr_fid as uid is no longer true unique identifier in the database with many duplicates
in the table joining operations where the assumption is the records are unique and this leads to tables become too large for build
As Jul 1 2022 build, it is spotted in the _init_bis_devdb step that the records by job number is no longer unique after filtering down the doc # ==1. This cause a series of downstream issue:
ogr_fid
asuid
is no longer true unique identifier in the database with many duplicates