Problem

 Highways owner cannot see certain layers in locator

Solution

1. Check the Theme functions for the theme(s) in GIS Themes form. It should include the NM0572 form (Locator)

2. Check that the Theme name in GIS Themes form is EXACTLY the same as the one defined in Mapbuilder for the same layer

3. Check that there is an entry in the user_sdo_geom_metadata for the theme(s).

4. Check the java console log. It should include the query used to display the themes in Locator. Run this query in sqlplus to see if it returns the expected themes. An example of this query is given below:

select name, gt_table_name, gt_feature_table, geometry_column, nvl(srid,0), nvl(gt_pk_column,'NOTSET'), nvl(gt_feature_pk_column,'NOTSET'), nvl(gt_label_column,'NOTSET'), nvl(gt_theme_id,-1), decode(nvl(gt_theme_id,-1), -1,'NONE','NONE'), style_from_xml(styling_rules), DECODE(NVL(nnth_nth_theme_id,'-1'),-1,'I','N'), decode(nvl(ntv_visible,'Y'),'Y','Y','N') from user_sdo_themes, user_sdo_geom_metadata, gis_themes, nm_nw_themes, nm_themes_visible where table_name = base_table and gt_theme_name = name and gt_theme_id = nnth_nth_theme_id(+) and ntv_nth_theme_id(+) = gt_theme_id and name in ('ESU','TYPE 23','TYPE 22','TYPE 21','TYPE 4 STREETS','TYPE 3 STREETS','TYPE 1 AND 2 STREETS','SITES IN PROGRESS','SITES','SITES ABANDONED','SITES CLOSED','SITES COMPLETE','SITES LAST 3 YEARS','SITES LAST 6 MONTHS','SITES OLDER THAN 3 YEARS','SITES PROP IN PROG LAST 6 MONT','SITES PROPOSED IN PROGRESS','TMA_SITES','TMA_RESTRICTIONS','TMA_ACTIVE_PHASES','ROUTE_NETWORK','ENQUIRIES BY STATUS','ENQUIRIES BY SOURCE')

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!