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.
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.
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:
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!