Problem

Inspection Loader showing Error 9260 Chainage on I record exceeds required chainage for section. : Correct the section chainage.: Got issue as trying to load defect(chainage 71 meteres) outside length of the section length (net_length 57 meters). Shapefile was recent. Yet when using Locator or map capture to create defect the chainage created exceeded the road length ie- at 71 meters. This issue occured as the spatial length measured 108 meters (using Spatial manager measure tool the section looked like 57 meters a mismatch) So looked at a few more sections with the same issue ( highlighted by script below) and spatial lengths looked like they should match the section length from elements form. So required resetting via a script.

Solution

1. The following below highlighted discrepancies ( need to ensure hig_map_sdo below reflects the correct layer for teh customer )

SELECT ne.ne_id, ne.ne_unique,ne.ne_length net_length,ne.ne_start_date,ne.ne_end_date,
  2         sdo_lrs.geom_segment_end_measure (shape) measure_len,
  3         (ne_length - sdo_lrs.geom_segment_end_measure (shape)) diff_m
  4    FROM hig_map_sdo nsg, nm_elements_all ne
  5   WHERE nsg.ne_id = ne.ne_id
  6   AND sdo_lrs.geom_segment_end_measure(shape) != ne_length;

2. start RepairShapeLengths.sql corrected spatial length to net length.
3. Also queried back each section in elements form and modified rse_max_chain to reflect max inventory chainage to new max value 57 meters from 108 meters

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!