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:
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;
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_INDEXNOPARALLEL;
CREATE INDEX NM_POINT_LOCATIONS_SPIDX ON NM_POINT_LOCATIONS
(NPL_LOCATION)
INDEXTYPE IS MDSYS.SPATIAL_INDEX
NOPARALLEL;
Product TechNotes and FAQs
Bentley Technical Support KnowledgeBase
Bentley LEARN Server
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!