Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • More
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki Missing Phase Data
    • 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
        • Attachments in work reference cannot be seen
        • Change contact number in works form
        • Daily Failed Transactions Alert
        • Exor TMA unable to view street in Works
        • Failure accessing WMS theme.
        • FRM 41035 error when select notice type
        • HIG-0169: Database constraint violated: TNSW_UK
        • How to check if a notice was sent / received
        • How to configure TMA Attachments
        • How to fetch results on Review Notices form(TMA1030)
        • How to locate the .net wsdl file
        • How to remove and add recipients from S58s
        • How To Respond To A Temporary Traffic Signal Application
        • Incoming inspections fail to load
        • +Inspections - Exor TMA Noticing Manager
        • Interim Construction Method Warning Missing
        • Invalid enumeration value 0
        • Invalid XML error when sending notice
        • Major Works 3 Months Notice FPN
        • Many Inspection Records Updated
        • Missing Phase Data
        • New User Cannot Send Notices
        • No notice type for informal overrun warning
        • Notice Sent OK but Not Received
        • Notice went out of sequence in TMA3000
        • +Notices - Exor TMA Noticing Manager
        • Opening the EXOR Application Directly to TMA1000 Works Form
        • ORA 13356 adjacent points in a geometry are redundant
        • +Other - Exor Noticing Manager
        • +Other - Exor TMA Noticing Manager
        • Proximity Validation warning
        • Report not returning all records
        • +Reports - Exor Noticing Manager
        • +Reports - Exor TMA Noticing Manager
        • Restrictions - Exor Noticing Manager
        • Revoke Cancel FPN
        • Sample Inspection Quotas Report Figures Too Low
        • Scheduler only assigns to 1 inspector
        • Sender Does not Exist in NSG Error
        • Some DCD Inspections Not Downloaded
        • Start date for Major Notices
        • +Street Groups - Exor Noticing Manager
        • Street of Interest or Lane Rental Check Box
        • The XML page cannot be displayed Cannot view XML input using XSL style sheet
        • TMA Works Phase Master refresh: error in materialized view path
        • +Transactions - Exor Noticing Manager
        • +Transactions - Exor TMA Noticing Manager
        • Type 4 Street Used On Works
        • Unable to change one type of issued Direction notice type to another
        • Unable to select the Promoter/Contractor contact on Phase Details tab
        • Unable to use Links->Works function
        • What is the difference between created and modified dates
        • Works - Exor Noticing Manager
        • +Works - Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • +Transportation Intelligence Gateway
      • Unable to connect to Power BI dataset
      • +Video Series for Exor
      • Working From Home with Exor

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

    Missing Phase Data

      Product(s): Exor Noticing Manager
      Version(s): 04.05.10.02
      Environment: N/A
      Area: Works
      Subarea: N/A

    Problem Description

    When a works is queried in the TMA Works form (TMA1000), only the works ref and street details show - the phases part of the form is blank.

    For example:

     

    Solution

    There can be a few reasons for this issue.  The main ones are

    • working hours is blank (this mainly happened after TMA 4510 fix 18 was applied)
    • a duration challenge notice has been sent / received, then a user has blanked out the challenge date information and saved.

    To check for the above, run this query:

    SELECT twor_works_ref,
           tphs_phase_no,
           tphs_challenge_durn_type,
           tphs_challenge_durn_value,
           tphs_challenge_end_date,
           tphs_working_hours
      FROM tma_phases, tma_works
     WHERE     tphs_phase_no = <phase number>
           AND tphs_works_id = twor_works_id
           AND twor_works_ref = <works ref enclosed in single quotes>;

    If the working hours is blank, run this to resolve the issue:

    UPDATE Tma_Phases
       SET Tphs_Working_Hours = '0'
     WHERE     Tphs_Working_Hours IS NULL
           AND tphs_phase_no = <phase number>
           AND tphs_works_id = (SELECT twor_works_id
                                  FROM tma_works
                                 WHERE twor_works_ref = <works ref enclosed in single quotes>);

    If the challenge details are blank and you know a duration challenge has been sent or received (this can be checked in the Monitor Web Service Transactions form (TMA3000) if you're not sure), contact Bentley support who can reset these values for you.

    See Also

    https://communities.bentley.com/products/assetwise/exor/w/wiki/40246/ora-06502-in-phase-due-to-complete-report

      Original Author: Lee Jackson
    • Exor Noticing Manager
    • Works
    • missing phase
    • Exor
    • empty phase
    • 04.05.10.02
    • Share
    • History
    • More
    • Cancel
    • Lee Jackson Created by Bentley Colleague Lee Jackson
    • When: Thu, Jun 26 2014 7:27 AM
    • Sarah Willis-Culpitt Last revision by Bentley Colleague Sarah Willis-Culpitt
    • When: Wed, Nov 14 2018 4:50 AM
    • Revisions: 7
    • 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

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