Exor TMA Manager 04.05.00.00
User enters works details into the Works form (tma1000) then clicks to issue notice TMA1001 and gets an error
Error Internal error during validation tma_spatial_validation_proximity_check ORA-29913: error in executing ODCIAGGREGATEMERGE callout
The works coordinates were within the area of the related street and there was no visible reason why the validation should fail.
In order that the notice could be sent, the user turned off the proximity validation while the notice was sent and then turned it back on again.
Please could someone advise if there is an issue that we can resolve at this end, or if this is an issue that will have to be dealt with manually if it happens again.
issue with USRN 47818007 - Wolvershill Road, North Somerset.
Posted on behalf of an Exor user.
It may be that the street may have some invalid geometries.
Try running the following and see if yoy get any errors reported back:
SELECT ne_id, SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(c.geoloc, 0.005)
FROM v_nm_nat_nsgn_offn_sdo_dt c WHERE c.nsg_reference = '47818007' ;
Pano Voudouris | Senior Support Engineer
response from customer
I've run the query and the following results occurred:
SQL> col var format a10
SQL> SELECT ne_id
2 , SDO_GEOM.VALIDATE_GEOMETRY_WITH_CONTEXT(c.geoloc, 0.005) var
3 FROM v_nm_nat_nsgn_offn_sdo_dt c
4 WHERE c.nsg_reference = '47818007';
22 rows selected.
Have asked for further advice from Development and will get back to you asap
If your new works record has a Works Category of Immediate, you don’t need to supply phase coordinates on the initial notice (0200) as the following rule applies:
LocationCoordinates are optional when ChargeCategory=6 (secondary promoter) or for WorksCategory values of 4 or 5 (Immediate works). Coordinates should be provided in all other circumstances.
If you see the validation error then dont supply any coordinates for the initial notice so you can continue the works. You will need to supply coordinates on a later notice so please use the following workaround to bypass the error.
If you urgently need to send a notice for a works that contains phase coordinates and generates a proximity validation error, double check the coordinates you want to use and send a notice with the proximity validation feature disabled. To disable the TMA Proximity Validation feature, log in as a user with the HIG_ADMIN role and update product option TMAPROXVAL to N. Once you have sent the notice, re-enable the feature by setting the product option to Y.
Lee Jackson | Product Manager
Answer Verified By: Jodie Preston