Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki RCI fault ORA-00936 in UKP0026
    • Sign In
    • -Exor - Wiki
      • +ALIM Document Manager
      • An Attempt to Reset Your Password Has Failed
      • +AWLRS
      • +Exor Asset Manager
      • +Exor CIM / FIM
      • +Exor Document Manager
      • +Exor Enquiry Manager
      • +Exor Information Manager
      • +Exor Information Manager TMA Reporting Pack
      • +Exor Maintenance Manager
      • +Exor Maintenance Mobile
      • +Exor MapCapture
      • +Exor MapCapture (ESRI)
      • +Exor MCI MapCapture Interface
      • +Exor Network Event Manager
      • +Exor Network Manager
      • +Exor Oracle
      • Exor Problems and Solutions
      • +EXOR product placeholder
      • Exor Public Enquiry Manager API
      • +Exor Schemes Manager
      • +Exor Spatial Manager
      • +Exor Street Gazetteer Manager
      • Exor Streetworks Manager
      • Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • -Exor UKPMS
        • Error at point 14 when running a pass
        • +HMDIF Load - Exor UKPMS
        • +Network Selection - Exor UKPMS
        • REP-300 error
        • -Reports - Exor UKPMS
          • 'Divisor is equal to zero' error in UKPMS reports
          • Blank UKP0040 report
          • Performance CI Report - Exor UKPMS
          • RCI fault ORA-00936 in UKP0026
        • +Survey Load - Exor UKPMS
        • Survey tolerance errors
        • +UKPMS Pass - Exor UKPMS
      • +Transportation Intelligence Gateway
      • Unable to connect to Power BI dataset
      • +Video Series for Exor
      • Working From Home with Exor
    • +AssetWise ALIM for Transportation

     
     Questions about this article, topic, or product? Click here. 

    RCI fault ORA-00936 in UKP0026

       
      Applies To 
       
      Product(s): Exor UKPMS
      Version(s): 04.05.00.00
      Environment:  N/A
      Area: 
      Subarea: 
      Original Author: Renatas Mazeika, Bentley Technical Support Group
       

     

     

     

     

     

     

     

     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.



    • UKP0026
    • UKP
    • ORA-00936
    • Exor
    • ukpms
    • Road Condition Indicator
    • RCI
    • Share
    • History
    • More
    • Cancel
    • renatas Created by Bentley Colleague renatas
    • When: Mon, Aug 26 2013 4:59 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Mon, Apr 11 2016 6:47 AM
    • Revisions: 11
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies