My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.