| Product(s): | Exor MapCapture (ESRI) | ||
| Version(s): | 04.07.00.03 | ||
| Environment: | N\A | ||
| Area: | ESRI-based Mapcapture | ||
| Subarea: | N\A |
Problem
Two inspectors tried to load their inspection files from their personal folders. As they had also downloaded the files from MapCapture at the same time, the files had the same name - 1611081422_ALLINSP.RDI However, the system did not load both files. It loaded one file twice. Fortunately this was spotted by one inspector and he was able to load a second time.
This is causing concerns that this problem may have happened before and gone un-noticed or it may happen again.
The more unique file name would resolve this.
Solution
Please run the below script to find any inspection files with the same name. You can then check the individual loads to find out if this has ever occurred in the past.
select * from mai_insp_load_batches_v where hpf_filename in (select hpf_filenamefrom mai_insp_load_batches_v
group by hpf_filename
having count(*) > 1)
order by hpf_filename;
This issue is also addressed in the new Exor MapCapture that is no longer Esri-based.
| Original Author: | Kristijonas Nalivaika |