Posted on behalf of an Exor user.
Pre-processing some UKPMS data gives 'Unknown Section' error in Spooled Output. The section references in the original .hmd file that is being pre-processed do not have "/" symbol which is visible in the Spooled Output for both section references. They are showing as 5450U458_00010 and 5450U1041_00010 accordingly.
There is one more section reference in .hmd file for which no error is being displayed in the spooled output.
See screenshot below:
Validation style 1 means that the road section identifier is derived using values in a table called UKPMS_SECT_LABEL which says where each element of a road section identifier begins and ends in the hmdif file. The pre-processor then puts it into the format the inventory loader expects. Check the values in the UKPMS_SECT_LABEL table (if Managed Service then please contact TSG to do this for you) against their positions in the hmdif file and if changes to UKPMS_SECT_LABEL are needed then contact TSG for a script to do so. If it looks right then check that the sections DO exist, are not end-dated, and that the user pre-processing has the right admin unit privileges to load data for that section.
Answer Verified By: Kristijonas
If in nm_elements_all table section reference appears as 5450U458__/00010 and in hmdif file as 5450U458_00010 (one underscore character less that in the table) – could it be that hmdif file actually needs to be amended rather than the UKPMS_SECT_LABEL table?
Values in UKPMS_SECT_LABEL correspond to the nm_elements_all section reference version.
Definitely, the file(s) should probably be sent back to the surveyors, although some users prefer to edit them themselves. Each part of the section identifier should match what we have in the system, it's only the '/' that's optional.
Turns out that for some reason yet to be explained the surveying company dropped one of the "_" underscores from the section/linkcode identifier on these sections when resubmitting them to me.
They have now been asked to explain why after wasting so much of my time and Bentleys but thanks to the Bentley team for help in identifying the problem.
Wish you all a good weekend.
John