JDBC Datasource Failed error when starting Locator or Map Viewer Servlet Failed


 Product(s):Exor Core / Network / Document Manager
 Version(s):4.x
 Environment:N/A
 Area:Locator
 Subarea:N/A

Problem

When trying to start locator, the following error message is displayed:
JDBC DataSource Failed
Map Server Servlet setting was: [url]
Datasource Name setting was: [name]
Please check Product Options and restart

or


Solution

First, if this worked OK before and just stopped suddenly - make sure to restart Map Services.

Secondly, as per the error message, you will need to check your product options and make sure they are correct and match the settings in the mapviewerconfig.xml file. This file can be found in the application server. For example c:\product\10.1.3.1\OracleAS_1\j2ee\home\applications\mapviewer_11_1_1\web\WEB-INF\conf\mapViewerConfig.xml

You can open this file in a text editor and have a look for the map_data_source section. eg.:

<map_data_source name=”exor”
                      jdbc_host=”your_host_name”
                      jdbc_sid=”your_db_sid”
                      jdbc_port=”1521”
                      jdbc_user=”highways”
                      jdbc_password=”!<highwayspwd>”
                      jdbc_mode=”thin”
                      number_of_mappers=”3”
                      allow_jdbc_theme_based_foi="true"
/>

Check if these are correct for your settings.

Also check the relevant product options in the highways application:

WEBMAPDSRC
 set this to the value of map_data_source in the mapviewerconfig.xml file

WEBMAPMSV
 http://<application server>/mapviewer/omserver

WEBMAPSERV
 blank this is no longer used

JDBCSID
 The SID of the Database

JDBCPORT
 The port on which the database can be connected (usually 1521)

JDBCHOST
 The machine on which the database resides

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

 Original Author:Technical Support Group