| Product(s): | Exor Net / Core / Network / Assets | ||
| Version(s): | All | ||
| Environment: | N/A | ||
| Area: | N/A | ||
| Subarea: | N/A |
Problem
When trying to create an asset either from forms or SM, you get an error message similar to:
ORA-20001 HIG 0286 No snaps at this position
The error seems to apply to specific coordinates only. Other coordinates may be OK. Tolerance is set and the distance between the asset and the network is within the set tolerance.
Solution
If this error occurred through the csv loader, loading an off network asset check if the csv definition references view V_LOAD_INV_MEM_ON_ELEMENT, from v4700 this can be removed but need to ensure theme that is used to snap referenced in the base tables theme field has the date tracked 'live network', as well as in the base theme tab at the bottom of the screen.
Have a look at the base theme that is set for the asset type you are trying to create in GIS0010 - GIS Themes form. If it is set the base (table) network this may mean that sometimes, it will try to snap to end-dated sections and hence give this error. Change the base network theme to the date-tracked network which only contains the 'live' network.
To change the base themes for a layer, please refer to this post
Also note that if you get this error for Off-network assets, the easiest way to fix it is to delete any base themes. So if for example you theme id is 2347, you will need to run the following statement in SQL as the highways owner:
delete from nm_base_themes where nbth_theme_id=2347
In order to see the layers that the system will try to snap to you can run the following statement: (using as an example a theme_id of 2347)
SELECT b.nnth_nth_theme_id, nth_theme_name, nth_feature_table
FROM NM_BASE_THEMES, NM_NW_THEMES a, nm_nw_themes b, nm_themes_all
WHERE nbth_theme_id = 2347
AND nbth_base_theme = a.nnth_nth_theme_id
AND EXISTS ( SELECT 1 FROM NM_THEME_ROLES, HIG_USER_ROLES
WHERE hur_username = USER
AND hur_role = nthr_role
AND nthr_theme_id = b.nnth_nth_theme_id )
AND a.nnth_nlt_id = b.nnth_nlt_id
and b.nnth_nth_theme_id = nth_theme_id
This would return a list of network themes. Ensure that the list does not include network layer that contain end-dated sections.
Network geometries
However, the problem may also be with the actual geometry on the section you are trying to snap the asset to. To do this first make sure that the network layer is at the top of the layer list in the legend and then click on the shape properties tool and then the section in question. This would popup a window showing you the x,y and m values for the section.
If you have duplicate values in there e.g. both the first and second point have a measure value of 0, then the snapping algorithm might throw this error as it cannot find a single point with this measure. If thats the case you can do the following:
- Select the section and click on reshape
- When the handles appear along the section, right click and select Shape Properties- the same window will appeare as before but this time the M values will be editable.
- Enter a new M value for the second vertex (you cannot change the M value of the first vertex). The M value should be valid, i.e. have a value between the first and third M values.
- Click on Save to save your changes in the Reshape window.
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!
| Original Author: | Bentley Technical Support Group |