Automatic Pass status ‘Flagged to be stopped’. Can’t finish it.
One of the reasons to stop an Automatic Pass could be that the Pass has at least one section whose start_date value is set to a later date than a scanning was performed.
To find these sections run this sql code:
FROM nm_elements_all ne, ukpms_tts tts, ukpms_pass_road_run_time_dets u
WHERE ne.ne_id = tts.iit_rse_he_id
AND u.uprtd_rse_he_id = ne.ne_id
AND u.uprtd_rec_type = 1
AND ne.ne_start_date > tts.iit_start_date
GROUP BY u.uprtd_pass_id,
ORDER BY u.uprtd_pass_id, ne.ne_unique
Here are some ways to solve the issue.
The first one, to amend start_dates for these sections, setting start_dates to earlier than a scanning was performed.
Another one is removing the section(s) from the Pass. (We recommend it):
1. Make a copy of this Automatic Pass.
2. EXLUDE these ‘wrong’ sections from a new Automatic Pass
(on Automatic Pass form select Network Selection button, Choose the network where these ‘wrong’ sections are assigned),
On Selection Criteria choose ROAD NETWORK area and press Select Criteria button
And append these ‘wrong’ sections in the end of Network Criteria list choosing EXCLUDE operator for every section
3 Run this new Automatic Pass