OBIEE - Increase Map Joins

OBIEE has a default limit of 500 joins to a map.

There are occasions where you may need to up this limit and you will need to make changes to this setting if more points of contact to the map exist.

You will need to add something like the below into your instanceconfig.xml file

<SpatialMaps>
<ColocatedOracleMapViewerContextPath>/mapviewer</ColocatedOracleMapViewerContextPath>
<RemoteOracleMapViewerAbsoluteURL/>
<LayerDataLayout>
<MaxRecords>1500</MaxRecords>
</LayerDataLayout>
</SpatialMaps>

OBIEE - Mapviewer Error after 11.1.1.7 Upgrade

You may get an error after upgrading your 11.1.1.6 environment to 11.1.1.7.

Here is what to do:

After upgrading to OBIEE 11.1.1.7 mapviewer shows error:

  "HTTP 500 Internal server Error"

When trying URL:

  http://localhost:9704/mapviewer


The log contains :

java.lang.NoClassDefFoundError: oracle/adfinternal/view/faces/taglib/html/HtmlHtmlTag
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
at java.lang.Class.getConstructor0(Class.java:2699)
at java.lang.Class.newInstance0(Class.java:326)
at java.lang.Class.newInstance(Class.java:308)
Truncated. see log file for complete stacktrace
>
<Watch 'UncheckedException' with severity 'Notice' on server 'bi_server1' has triggered at Jul 9, 2013 12:00:02 PM CEST. Notification details:
WatchRuleType: Log
WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'WL-101020') OR (MSGID = 'WL-101017') OR (MSGID = 'WL-000802') OR (MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802'))
WatchData: DATE = Jul 9, 2013 12:00:02 PM CEST SERVER = bi_server1 MESSAGE = [ServletContext@285430038[app:mapviewer module:/mapviewer path:/mapviewer spec-version:2.5 version:11.1.1]] Root cause of ServletException.
java.lang.NoClassDefFoundError: oracle/adfinternal/view/faces/taglib/html/HtmlHtmlTag
at java.lang.Class.getDeclaredConstructors0(Native Method)
at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
at java.lang.Class.getConstructor0(Class.java:2699)
......
......
......
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
SUBSYSTEM = HTTP USERID = SEVERITY = Error THREAD = [ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)' MSGID = BEA-101017 MACHINE = VMBO TXID = CONTEXTID = 3f3d2d8955322f32:-750ddf2f:13fc2ab56ea:-8000-00000000000012de TIMESTAMP = 1373364002231
WatchAlarmType: AutomaticReset
WatchAlarmResetPeriod: 30000
>

CAUSE

Known issue

Need to clean some files

SOLUTION

There is a known issue when upgrading to 11.1.1.7

Here is the workaround:

Workaround:

A number of files have to be removed from the MapViewer deployment and the
Weblogic internal cache of the MapViewer application needs to be deleted.

- Stop the managed server, e.g. bi_server1

(Note : the following step is also required if 11.1.1.7.1 patches are to be
applied)
- Delete the following files from MapViewer deployment, e.g. <middleware
home>/Oracle_BI1/bifoundation/jee/mapviewer.ear

web.war/WEB-INF/lib/adf-faces-api.jar
web.war/WEB-INF/lib/adf-faces-impl.jar
web.war/WEB-INF/lib/commons-digester.jar
web.war/WEB-INF/lib/commons-logging-1.1.jar
web.war/WEB-INF/lib/jsf-api.jar
web.war/WEB-INF/lib/jsf-impl.jar
web.war/WEB-INF/lib/jsr173_1.0_api.jar
web.war/WEB-INF/lib/mvutil.jar
web.war/WEB-INF/lib/xdb.jar
web.war/WEB-INF/adf-faces-config.xml
web.war/WEB-INF/orion-web.xml

- Recursively delete the directory: <middleware
home>/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_use
r/mapviewer_11.1.1


- Restart the managed server.

Internal Reference:
Bug 16906739 - UPGRADE OF BIEE FROM 11.1.1.6.0 TO 11.1.1.7.0 CAUSES MAPVIEWER RUNTIME FAILURE

Also documented in the Release notes:

41.6.1.4 MapViewer Runtime Failure After Upgrading from Release 11.1.1.6 to Release 11.1.1.7 (link http://docs.oracle.com/cd/E28280_01/doc.1111/e14770/biee.htm#CHDJIDBD )

OBIEE Using Maps as Reports

Prior to OBIEE 11g the only way to get maps into your BI reports and dashboards was to use some fancy javascript, some custom html and embedding the result using a NSDP link. A mouthful and a pain, but doable.

NSDP = Non-Spatial Data Provider i.e the name you give a shape on a map, a road name or park name that has a business meaning that is constant and provides a link between the spatial and business worlds.

As I work in London, and as they say in Blue Peter - "Here's one I prepared earlier".

I'll be doing a short series of articles on preparing mapsand thoughts on using them to enhance visuals.