Problem Description

Running UKP0026 – Road Condition Indicator – form an error message appears ‘SQLCODE ORA-00936: missing expression.’

Reason

The selected network does not contain road classes that are included in the specified weighting set.

Steps to resolve

Make sure that you are running RCI pass with the ‘right’ input parameters.

For example: for ‘A’ roads you have chosen the principal weighting set (WSPrinvxxxx),

For ‘B’, ‘C’ and ’B&C’ roads -  the non-principal weighting set (WSBCvxxxx),

For ‘U’ roads – the unclassified weighting set (WSAllClassesvxxxx). 

If all the parameters appear correct but you are still getting the error message please run the below query in SQL Developer or Toad to check which class of roads are included in the road condition indicator being run. This will prompt you to enter the RCI run number and then show you the weighting set, and how many roads of which dot classification it picked up for the RCI run.

select uap_defect_len_merg_method, dot_classification, count(*)

from ukpms_automatic_pass,

ukpms_pass_road_run_time_dets,

v_ukpms_road_section

where iit_rse_he_id = uprtd_rse_he_id

and uprtd_pass_id = uap_auto_pass

and uap_auto_pass = '&RCI_ID'

group by uap_defect_len_merg_method, dot_classification;

If it returns any sections with road classes that do not fall under the weighting set you have selected you might need to identify the sections and exclude them from network selection.