Exor Spatial Manager
Posted on behalf of an Exor user.
I noticed that the NSG OFFN layer wasn't displaying when I brought it into SM.
I have tried a theme refresh in GIS0020 for the OFFN layer, but get this error:
Probably something's wrong with the spatial index in the base table. Try the following please:
Make sure that the base table is selected in the GIS0020 form (in this case NM_NAT_NSGN_OFFN_SDO) and press the [>] button on the right-hand side of the form.
Select the SDO Metadata tab and check if a spatial index exists. If not press the [Create index] button. If it does exist, press the [Rebuild index].
Pano Voudouris | Senior Support Engineer
No Spatial Index on that base table and don't appear to have the [Create Index] button...
Screen shot attached
SDE Metadata populated.
OFFN layer loaded across ok, all seems to be displaying ok, the identify tool works and the street attributes form can be opened from a selected centreline.
Next test was to try and recalculate the start and end XYs on a NSG centreline after an ESU reshape.
I did the ESU reshape, then opened the OFFN street attributes form, clicked 'calculate' and 'save'.
I got an error dialog which I saved as a log file (attached).
I think its probably something to do with the registration of one of the dependant asset layers but still looking at this. In the meantime can you please let me know the versions of the nm3nsgstreet and the nm3invval package bodies please? i.e. select nm3invval.get_body_version from dual;
Also- can you please check the NM_DBUG table? there will be an error flagged up in the debug table which has a reference to the failure. It will have a string with nm3nsgstreet.update_street in it, you should be able to access it with a query such as:
Select nd_text from nm_dbug
Where upper(nd_text) like ‘%NM3NSGSTREET.UPDATE_STREET%’
"$Revision: 2.15 $" in new HWDEV (4500)
Norfolk Specific: "$Revision: 3.0 $" in current HWLV (4300)
nm_dbug table is empty in new HWDEV (4500)
Issue has been taken offline as its user-specific