Mapviewer Local Installation Does Not Render Correctly ADF DVT Maps

(Doc ID 1567705.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle 9iAS MapViewer - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Using JDeveloper 11.1.1.7 with http://elocation.oracle.com/mapviewer
and
Using JDeveloper 11.1.1.7 with http://localhost:8888/mapviewer

We are able to generate a map when using the http://elocation.oracle.com/mapviewer as the URL Endpoint in a JDev application.
As we can not have all the data from http://elocation.oracle.com/mapviewer to install in a local installation we tried WORLD_SAMPLE but the WOM_AREA is just too complicated to use. So, we used mvdemo STATES table, problem is:

When we switch to a local mapviewer URL Endpoint http://localhost:8888/mapviewer the colors are not rendered


GOOD:
The one working: Using JDeveloper 11.1.1.7 with http://elocation.oracle.com/mapviewer

dvt:mapColorTheme has the following:

    baseMapName="ELOCATION.WORLD_MAP" mapZoom="0"
  inlineStyle="width:100%; height:600px;" startingY="0.0"
  binding="#{backingBeanScope.backing_view1.map}">
    value="#{bindings.EmployeeMapVO1.geoMapModel}"
  bucketCount="5" minColor="#ff0000"
  maxColor="#00ff00" locationColumn="POLYGON_NAME"
  clickListener="#{bindings.EmployeeMapVO1.geoMapModel.processClickAction}"
  selectionListener="#{bindings.EmployeeMapVO1.geoMapModel.processSelection}"/>
  


Edit ColorMap Theme:
Map Theme
 Name: MAP_STATES_NAME < Location column: POLYGON_NAME

Data Bucket Count: 5
Data:
 Location: StateProvince
 Location Label: DepartmentName
 Data Value: CountEmployeesEmployeeId
 Data Label: Number Of Employees


BAD:
The one NOT working: Using JDeveloper 11.1.1.7 with http://localhost:8888/mapviewer

This is using the mvdemo dataset

In the code:

    baseMapName="MVDEMO.BASE_MAP_STATES" mapZoom="0"
  inlineStyle="width:100%; height:600px;" startingY="42"
  binding="#{backingBeanScope.backing_view1.map}">
    value="#{bindings.EmployeeMapVO1.geoMapModel}"
  bucketCount="5" minColor="#ff0000"
  maxColor="#00ff00" locationColumn="STATE"
  clickListener="#{bindings.EmployeeMapVO1.geoMapModel.processClickAction}"
  selectionListener="#{bindings.EmployeeMapVO1.geoMapModel.processSelection}"/>
  


In the GUI shows:

DATA SOURCE: MVDEMO
Base Map: BASE_MAP_STATES <Starting X: -112
Starting Y: 42
Zoom level:0


dvt:mapColorTheme has the following in the GUI:

Edit ColorMap Theme:
Map Theme
 Name: THEME_DEMO_STATES
 Location column: STATE

Data Bucket Count: 5
Data:
 Location: StateProvince
 Location Label: DepartmentName
 Data Value: CountEmployeesEmployeeId
 Data Label: Number Of Employees

The SELECT statement used is:

conn HR/hr
SELECT COUNT(EMPLOYEES.EMPLOYEE_ID), Department_name,
STATE_PROVINCE
FROM
EMPLOYEES, DEPARTMENTS, LOCATIONS
WHERE employees.department_id=departments.department_id
and Departments.location_id=locations.location_id and STATE_PROVINCE IS NOT NULL
GROUP BY Department_name, LOCATIONS.STATE_PROVINCE

The data output from sqlplus is:

  CO DEPARTMENT_NAME STATE_PROVINCE
----- ------------------------------ -------------------------
  5 IT Texas
  2 Accounting Washington
  1 Public Relations Bavaria
  45 Shipping California
  6 Finance Washington
  34 Sales Oxford
  3 Executive Washington
  1 Administration Washington
  6 Purchasing Washington
  2 Marketing Ontario

10 rows selected.

The data output from the STATES table is:

conn mvdemo/mvdemo
select state from states where state in ('California','Texas');

STATE
--------------------------
California
Texas

So, it's supposed to match that from the HR schema query.

Logging:

1. Not able to get a log for the GOOD because it is using the elocation service
2. Log for the BAD (not rendering the map)

Log shows:

FINEST: Theme query [ THEME_DEMO_STATES ]: SELECT /*+ index(STATES STATES_SDX) */ ROWID, GEOM, 'C.S02_COUNTRY_AREA', STATE_ABRV,

'T.S02_STATE_ABBREVS', 1, 'rule#0' FROM STATES WHERE MDSYS.SDO_FILTER(GEOM, MDSYS.SDO_GEOMETRY(2003, 8307, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,

1003, 3), MDSYS.SDO_ORDINATE_ARRAY(:mvqboxxl, :mvqboxyl, :mvqboxxh, :mvqboxyh)), 'querytype=WINDOW') = 'TRUE' AND STATE IN (select * from

TABLE (:NSDPVLIST) )
Jul 8, 2013 4:55:21 PM oracle.sdovis.theme.PredGeomThemeQueryHelper bindNsdpData
FINEST: NSDP keys begin:
Texas
Washington
Bavaria
California
Washington
Oxford
Washington
Washington
Washington
Ontario
NSDP keys end.
Jul 8, 2013 4:55:21 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
FINER: [ THEME_DEMO_STATES ] Fetch size: 100
Jul 8, 2013 4:55:21 PM oracle.sdovis.theme.PredGeomThemeProducer loadFeaturesInWindow
INFO: [ THEME_DEMO_STATES ] sql exec time: 13ms, total time loading 3 features: 19ms.
Jul 8, 2013 4:55:21 PM oracle.sdovis.NsDpHandler doJoin
WARNING: duplicate NSRow found: Washington
Jul 8, 2013 4:55:21 PM oracle.sdovis.NsDpHandler doJoin
WARNING: duplicate NSRow found: Washington
Jul 8, 2013 4:55:21 PM oracle.sdovis.NsDpHandler doJoin
WARNING: duplicate NSRow found: Washington
Jul 8, 2013 4:55:21 PM oracle.sdovis.NsDpHandler doJoin
WARNING: duplicate NSRow found: Washington
Jul 8, 2013 4:55:21 PM oracle.sdovis.NsDpHandler doJoin
FINER: Cannot find any matching NSRow for key (from spatial table): TX
Jul 8, 2013 4:55:21 PM oracle.sdovis.NsDpHandler doJoin
FINEST: Time spent on NSDP join:3ms. Matches found: 0.
Jul 8, 2013 4:55:21 PM oracle.sdovis.NsDpHandler doDataJoin
INFO: NSDataHandler: no matching feature found.
Jul 8, 2013 4:55:21 PM oracle.lbs.mapserver.core.MapperPool freeMapper
FINER: freeMapper() begins...
Jul 8, 2013 4:55:21 PM oracle.lbs.foi.FOIServer renderFOILayer
FINEST: Total time spent in ThemeRenderingThread.run():122
Jul 8, 2013 4:55:21 PM oracle.lbs.foi.FOIServer renderFOILayer
FINE: Total time spent in FOIServer.renderFOILayer:123
Jul 8, 2013 4:55:21 PM oracle.lbs.foi.FOIServlet doPost
FINEST: ---- begin FOI response ----
{"foiarray":[]}
---- end FOI response ----


We understand the duplicates of Washington, however we do not understand why it cannot find matching rows.

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