Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
ALIM | Exor
  • Product Communities
  • AssetWise
  • ALIM | Exor
  • More
  • Cancel
ALIM | Exor
ALIM | Exor - Wiki JDBC Datasource Failed error when starting Locator or Map Viewer Servlet Failed
    • Sign in
    • -Exor - Wiki
      • +ALIM Document Manager
      • +AWLRS
      • Exor Accidents Manager
      • +Exor Asset Manager
      • +Exor CIM / FIM
      • +Exor Document Manager
      • +Exor Enquiry Manager
      • +Exor Information Manager
      • +Exor Information Manager TMA Reporting Pack
      • +Exor Maintenance Manager
      • +Exor Maintenance Mobile
      • +Exor MapCapture
      • +Exor MapCapture (ESRI)
      • +Exor MCI MapCapture Interface
      • +Exor Network Event Manager
      • -Exor Network Manager
        • +'Group has overlaps' error adding section to group
        • "HIG 0182: User not instantiated correctly. Probable missing INSTANTIATE_USER trigger. Contact exor support for assistance" when login
        • Allow users to use Locator but not to change network data
        • Application server running 100% since upgrade
        • Batch emails ignore table tag
        • Changing Base Themes
        • Copyright statement displayed in Locator
        • Could not find Theme error in Locator
        • Create New User
        • Create User Hangs Intermittently
        • CSV Load ORA-06550 PLS 00103 error
        • Database clone product options
        • Date format restricted to DD-MON-YYYY
        • Default-web-access.log taking up too much space
        • Elements - Exor Network Manager
        • Error ORA-105100 uploading documents.
        • Error received while resizing route using toolbar, ORA-01422 unhandled exception
        • Error whilst creating theme
        • Errors in CSV Loader
        • Errors while creating asset layer using GIS Layer Tool
        • Exor Error NE_ID_OF invalid identifier
        • Exor listener processes are not currently running
        • Exor password format rules
        • Exor webhelp is not working
        • Exor will not start after server restart
        • Export Asset data from grid in Locator cannot locate file once exported
        • Export location of surveyp.ped in NM0580
        • FRM-92101 Error when opening application
        • +GRI/GIS Data - Exor Network Manager
        • Group membership security
        • +Groups of Sections - Exor Network Manager
        • HIG-0067 error when entering a form because of user options
        • HIG-0179 error message trying to select local file
        • Highways owner cannot see certain layers in locator
        • How to Change Highways Owner User Password
        • How to change the user password on a MAS System
        • How to check all the component parts or versions of Locator
        • How To Clear Your Java Cache
        • How to Enable the Java Console
        • How to unlock a user or change a users password
        • In which table is the user account email stored?
        • Initial view of Locator shows entire country
        • +Install/Upgrade - Exor Network Manager
        • Instantiate user error
        • Invalid number error ordering results by a string field in the Locator form
        • Invalid Username/Password in Sandbox
        • Java Certificate issue
        • Java error launching Exor after JRE update
        • JDBC Datasource Failed error when starting Locator or Map Viewer Servlet Failed
        • +Jobs - Exor Network Manager
        • Layer not displayed but exists in Mapbuilder and GIS0010 form
        • Legend Tool doesn’t work on Locator
        • Location remains unassigned error when creating an asset
        • +Locator - Exor Network Manager
        • Locator - Initial extent of map does not appear correctly
        • Locator - Measure tool does not work - Your query failed
        • Locator export fails but shows no errors
        • Locator: Map doesn’t open. FRM-92104 A network error or server failure has occurred.
        • My Database has been updated - I can't login - get errors trying to save
        • Navigating between fields in the form
        • Navigator: ORA-28112: failed to execute policy function
        • NET-0339 error when using CSV Loader
        • Network edits on hierarchical assets
        • New Asset Type Not Selectable In Alert Manager
        • New Defect Scheduled Alerts do not work
        • NM0116 shows nothing in attribute values
        • No network found within Tolerance error when creating a Defect
        • No snaps at this position when creating an asset
        • ORA 29279 SMTP Permanent Address error in alerts
        • ORA-20110: Unable to close Element it has un-replaceable inventory
        • ORA-257: archiver error. Connect internal only, until freed.
        • Oracle Discoverer timestamp differences
        • +Other - Exor Network Manager
        • Password security options
        • Popup windows do not display
        • +Reclassify - Exor Network Manager
        • Reference to uninitialized collection error
        • Refresh Java Permissions For An Oracle Directory
        • Report fails with REP-300: CONNECT BY clause
        • +Reports - Exor Network Manager
        • Results are not returned in the correct order in Locator
        • Split/Merge - Exor Network Manager
        • Subordinate users cannot see all options in the Feature Edit menu
        • Templates hang in 4500
        • The attributes are not being filled out on the email.
        • The specified environment ID EXORLIVE invalid for Job Type report
        • Theme is visible by all users even if they dont have the required roles
        • Unable to connect to MAS database via JDBC link
        • Unable to restart the mapviewer layer on the mapping server
        • Understanding Datum, Non Datum, Linear groups, Non-Linear groups, Group of groups
        • Unigue constraint NE_PK violated error
        • Useful scripts to identify database sessions and locks
        • Users cannot connect during high usage periods
        • Users form HIG1832 FRM-40200. Field is protected against update.
        • WMS alternatives
        • WMS Map is not visible in Locator
        • You do not have privileges to perform this action error on logon
        • “Invalid module” error accessing form through FastPath
      • +Exor Oracle
      • Exor Problems and Solutions
      • +EXOR product placeholder
      • +Exor Public Enquiry Manager API
      • +Exor Schemes Manager
      • +Exor Spatial Manager
      • +Exor Street Gazetteer Manager
      • Exor Streetworks Manager
      • +Exor Streetworks Mobile
      • +Exor Structures Manager
      • Exor Structures Mobile
      • +Exor TMA API and Web Service
      • +Exor TMA Noticing Manager
      • +Exor TMA Permitting Manager
      • +Exor UKPMS
      • ORA-20000: HIG-0230: Inconsistency detected error on login
      • +Transportation Intelligence Gateway
      • +Video Series for Exor
      • Working From Home with Exor

     
     Questions about this article, topic, or product? Click here. 

    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
    • JDBC Datasource Failed
    • Locator
    • Map Viewer Servlet Failed
    • Net
    • JDBC
    • Exor Network Manager
    • Share
    • History
    • More
    • Cancel
    • Elisabeth Pry Created by Bentley Colleague Elisabeth Pry
    • When: Thu, Sep 19 2013 5:14 PM
    • Jyoti Patil Last revision by Bentley Colleague Jyoti Patil
    • When: Thu, Mar 7 2019 4:06 AM
    • Revisions: 9
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies