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