| 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
| Original Author: | Lee Jackson |