The Comparison Report - Routes report provides a comparison of the routes in the system as it was just prior to running the interface compared to the contents of the buffer tables loaded by the interface run. It is primarily used with Test Mode interface runs so that the changes that would be made by a Full Mode interface run can be evaluated.

Each changed route is displayed in its own row containing the following information:

  • Route Name – This is the name of the route described by this line.
  • Current: LRS Description – This is a concise description of the route as it was just prior to running the interface system job. It shows the extents of the route (the beginning and ending measures) plus any gaps in the route. This field will be empty if the route in question did not exist prior to running the interface job.
  • Buffer: LRS Description – This is a concise description of the route as it exists in the buffer table that was loaded by the interface system job. It shows the extents of the route (the beginning and ending measures) plus any gaps in the route. This field will be empty if the route in question does not exist after running the interface job.
  • Error Text – This field shows a description of any errors that were found in this route after the interface system job was run. The possible values for this field and their meanings are:
    • The System ID of this route is null – System ID is a key field that should never be null
    • The route name of this route is null – Route name is a key field that should never be null
    • The start measure of this route is null – Start measure is a key field that should never be null
    • The end measure of this route is null – End measure is a key field that should never be null
    • The start measure of this route is greater than the end measure – Measures should always go from lower values to higher values
    • This route has no geometry – Null geometry removes the ability to display this route and its related events on maps within the AgileAssets system, but other functions will work as designed
    • Duplicate Route – This indicates more than one route with the same name and this is not allowed
  • Status – This field shows the word “Change” if the values on the Current LRS fields differ from the values of the LRS Buffer fields. This field shows the word “Error” if the route did not change but exhibits an error. Otherwise this field is blank. By default, a filter is applied based on this field to show only rows where this field is not null.
  • No labels