Problem 

The issue is that the user is unable to create a new provisional street on NSG0010, which is then used in TMA Manager. A user needs to create a new provisional street for several reasons, the main one being when they need to send an authority a notice for works on a new street which isn’t in the nsg gazetteer yet.

The problem occurs when an error is shown when trying to enter coordinates. If you don’t enter any coordinates then the form gives another error saying that they are mandatory.
To reproduce this I did the following:

1. In NSG0010 entered all the provisional street details and removed the usrn number.
2. Entered the start X and Y and then hit tab to move to the End X field but the first error is shown:
    FRM-40735: WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-13226
3. Click ok and can enter the coordinates, then click ok on the same message as you move to end Y.
4. Now try to save the record and the following error is shown, which is the error the user reported:
    FRM-40735: POST-RECORD trigger raised unhandled exception ORA-13226
5. The same POST-RECORD trigger error is shown if you try and click on the Type 21 field, before or after you try and save the provisional street record.

Solution

To fix this problem you may only need to rebuild the spatial indexes. This can be done by opening the NSG0010 form, then open the toolbox menu and select the Spatial Indexes option.
Problem 59725

If rebuilding the spatial indexes does not fix the issue, then it could be caused by missing spatial metadata. To check, run the following query in SQLPlus as the Highways Table Owner:

SELECT * FROM USER_SDO_GEOM_METADATA WHERE TABLE_NAME = 'NM_POINT_LOCATIONS' AND COLUMN_NAME = 'NPL_LOCATION';

If this returns no records, run the following statements to create the missing metadata and related index:

INSERT INTO USER_SDO_GEOM_METADATA (TABLE_NAME, COLUMN_NAME, DIMINFO, SRID)
SELECT 'NM_POINT_LOCATIONS', 'NPL_LOCATION',NM3SDO.CALCULATE_TABLE_DIMINFO('NM_POINT_LOCATIONS', 'NPL_LOCATION'), NULL FROM DUAL;

DROP INDEX NM_POINT_LOCATIONS_SPIDX;

CREATE INDEX NM_POINT_LOCATIONS_SPIDX ON NM_POINT_LOCATIONS
(NPL_LOCATION)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
NOPARALLEL;

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!