Map Does Not Display Filled In Colors Mapviewer Log Shows Key_column Using Default: ROWID (Doc ID 1609201.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Fusion Middleware MapViewer - Version 11.1.1.7.0 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

Displaying a map in OBIEE, the countries are not filled with the appropriate color

Mapviewer log shows:

Dec 18, 2013 8:05:25 PM oracle.sdovis.theme.CommonThemeAttrs getAttributes
FINEST: key_column using default: ROWID
Dec 18, 2013 8:05:25 PM oracle.sdovis.CacheMgr2 createGeomGroup
INFO: Creating/replacing a geometry cache group: sdovis_subreg_odf_gbl_jdbc:oracle:thin:@10.129.193.218:1521:DEV2IXH1 : BI_ADMIN_GEOMETRY_WORLD_GEOMETRY_PDT_GEOM.
Dec 18, 2013 8:05:25 PM oracle.sdovis.theme.PredGeomThemeQueryHelper createBaseQuery
FINEST: Theme BI_COUNTRY_THEME uses index hint:
Dec 18, 2013 8:05:25 PM oracle.sdovis.theme.PredGeomThemeQueryHelper createBaseQuery
FINEST: Theme BI_COUNTRY_THEME uses index hint:
Dec 18, 2013 8:05:25 PM oracle.sdovis.theme.PredGeomThemeQueryHelper createBaseQuery
FINEST: Theme base-query [BI_COUNTRY_THEME]: SELECT ROWID, #GEOMCOL#, 'C.BI_ADMIN_AREA', NAME, 'T.BI_COUNTRY_TEXT', 1, 'rule#0', ISO_COUNTRY_CODE, COUNTRY_NAME FROM BI_ADMIN_GEOMETRY_WORLD WHERE #SDOOP# #NSDPFLTROP# AND (admin_level=1)


...

WARNING: Cannot find style named RENDER_STYLE_L0V1_HILITE of ODF_GBL in all_sdo_styles
Dec 18, 2013 8:05:34 PM oracle.lbs.foi.ThemeRenderingThread render
FINER: Total time rendering foi data:21
Dec 18, 2013 8:05:34 PM oracle.lbs.foi.FOIServer renderFOILayer
FINEST: Total time spent in ThemeRenderingThread.run():59
Dec 18, 2013 8:05:34 PM oracle.lbs.foi.FOIServer renderFOILayer
FINE: Total time spent in FOIServer.renderFOILayer:60
Dec 18, 2013 8:05:34 PM oracle.lbs.foi.FOIServlet doPost
FINEST: ---- begin FOI response ----
{"foiarray":[{id:"ABAPs1AC9AAA+YkAAA",name:"United States",nsdpmeta:"{'mapId':'saw_3287_4', 'logicalType':0, 'layerID':'l0', 'visualID':'v1'}",gtype:"7",imgurl:"http://obiee.domain.com:80/mapviewer/images/foi/238_t0_S2_ABAPs1AC9AAA+YkAAA_768_112.png",x:-180,y:71.38961,width:768,height:112,attrs:["USA","UNITED STATES","UNITED STATES","589","0"]}],attrnames:["Country_Code","ODW_COUNTRY_NAME","NSDP_l0v10","NSDP_l0v11","NSDP_l0v12"],themeMBR:[-180.0,18.91172,180.0,71.38961],adjlevel:0,minx:-300.0,miny:-194.849335,maxx:300.0,maxy:285.150665,hiliteImgPref:"S5",isWholeImg:false}
---- end FOI response ----

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms