4 Replies Latest reply: Jun 20, 2014 9:11 AM by grueningd RSS

    MVDemo Mapviewer Integration with OBIEE Issues

    sinan_gg

      Hi ,

       

      I try to integrate mapviewer (MVDemo Sample Dataset) with OBIEE to gain more experience about mapviewer. After researching more, i will try to integrate special map data (Turkey Map) with OBIEE.

       

      Now, firstly download sample MvDemo Sample Dataset, created mvdemo2 schema in my oracle database which is called TRCB and imported mvdemo data dump in my oracle db.

       

      I think repository configuration is ok for now.

       

      In OBIEE admin console panel, i created a new mapviewer service. To add my oracle database as a mapviewer datasource, i clicked on the link ‘http://gbobit02:9704/mapviewer ‘ under Web Modules.

       

      In mapviewer admin panel, i add my connection information in config content like following.

       

      <map_data_source name="mvdemo2"

                         jdbc_host="gboract1"

                         jdbc_sid="trcb"

                         jdbc_port="4505"

                         jdbc_user="mvdemo2"

                         jdbc_password="!mvdemo2"

                         jdbc_mode="thin"

                         number_of_mappers="3"

                         allow_jdbc_theme_based_foi="false"

         />

       

      When i was checked whether the connection is ok or not, in datasource tab i didnt see any datasource information. It seems something is missing. 

       

      Which settings should i do, other than this configurations ?

       

      Thks,

      Sinan,

        • 1. Re: MVDemo Mapviewer Integration with OBIEE Issues
          sinan_gg

          I think there are very few people who have knowledge about mapviewer

          • 2. Re: MVDemo Mapviewer Integration with OBIEE Issues
            grueningd

            The syntax for the datasource connection parms looks correct. What you can do is the following:

             

            1st: Recheck your connection parameter values

            2nd:In the mapviewer configuration set the mv-log-level to finest. Restart mapviewer and check the mapviewer log. It should log anything about the issue

            • 3. Re: MVDemo Mapviewer Integration with OBIEE Issues
              sinan_gg

              Hi Gruen, this is my log file,

               

              Especially, "The Network Adapter could not establish the connection" is the key point of this log data. Have you got any idea for this _

               

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.MapperPool destroyAll

              WARNING: destroying ALL mapmaker instances.

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.oms destroyMV

              WARNING: Oracle MapViewer shut down.

              Jun 20, 2014 3:25:01 PM oracle.lbs.util.MPRequestAssembler stopRequestRecycler

              INFO: Stopping MP request recycler thread.

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.MapperConfig readVersion

              INFO: MapViewer server version: Ver11_1_1_7_1_B130528

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.MapperConfig <init>

              INFO: setting temp folder to: /usr/WebLogic/AppServer/Oracle_BI2/bifoundation/jee/mapviewer.ear/web.war/WEB-INF/temp/

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.Dimmer startElement

              FINEST: found a datasource: mvdemo2

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.MapperConfig loadConfigFile

              FINER: Loading configuration file: /usr/WebLogic/AppServer/Oracle_BI2/bifoundation/jee/mapviewer.ear/web.war/WEB-INF/conf/mapViewerConfig.xml

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.MapperPool destroyAll

              WARNING: destroying ALL mapmaker instances.

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.MapperConfig loadMapViewerConfig

              INFO: Temporary directory being used: /usr/WebLogic/AppServer/Oracle_BI2/bifoundation/jee/mapviewer.ear/web.war/WEB-INF/temp/

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.MapperConfig setLoggingOptions

              INFO: Setting logging options for MapViewer

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.MapperConfig setLoggingOptions

              INFO: setting logging level to error

              Jun 20, 2014 3:25:01 PM oracle.sdovis.ds.NativeOracleDataSource <init>

              SEVERE: IO Error: The Network Adapter could not establish the connection

              java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

                at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)

                at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)

                at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)

                at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)

                at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)

                at java.sql.DriverManager.getConnection(DriverManager.java:582)

                at java.sql.DriverManager.getConnection(DriverManager.java:185)

                at oracle.sdovis.ds.NativeOracleDataSource.<init>(NativeOracleDataSource.java:171)

                at oracle.sdovis.ds.DSManager.registerOracleJdbcDS(DSManager.java:128)

                at oracle.lbs.mapserver.core.MapperConfig.createMappers(MapperConfig.java:854)

                at oracle.lbs.mapserver.core.MapperConfig.loadMapViewerConfig(MapperConfig.java:1713)

                at oracle.lbs.mapserver.core.MapperConfig.loadConfigFile(MapperConfig.java:665)

                at oracle.lbs.mapserver.core.MapperConfig.<init>(MapperConfig.java:413)

                at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:133)

                at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:117)

                at oracle.lbs.mapserver.oms$ColdStart.run(oms.java:337)

                at java.lang.Thread.run(Thread.java:662)

              Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

                at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:398)

                at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:438)

                at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:711)

                at oracle.net.ns.NSProtocol.connect(NSProtocol.java:257)

                at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1229)

                at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:326)

                ... 16 more

              Caused by: java.net.ConnectException: Connection refused

                at java.net.PlainSocketImpl.socketConnect(Native Method)

                at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

                at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

                at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)

                at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

                at java.net.Socket.connect(Socket.java:529)

                at oracle.net.nt.MetricsEnabledSocket.connect(TcpNTAdapter.java:631)

                at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:164)

                at oracle.net.nt.ConnOption.connect(ConnOption.java:137)

                at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:374)

                ... 21 more

              Jun 20, 2014 3:25:01 PM oracle.sdovis.ds.NativeOracleDataSource <init>

              SEVERE: IO Error: The Network Adapter could not establish the connection

              java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

                at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)

                at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)

                at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)

                at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)

                at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)

                at java.sql.DriverManager.getConnection(DriverManager.java:582)

                at java.sql.DriverManager.getConnection(DriverManager.java:185)

                at oracle.sdovis.ds.NativeOracleDataSource.<init>(NativeOracleDataSource.java:171)

                at oracle.sdovis.ds.DSManager.registerOracleJdbcDS(DSManager.java:128)

                at oracle.lbs.mapserver.core.MapperConfig.createMappers(MapperConfig.java:854)

                at oracle.lbs.mapserver.core.MapperConfig.loadMapViewerConfig(MapperConfig.java:1713)

                at oracle.lbs.mapserver.core.MapperConfig.loadConfigFile(MapperConfig.java:665)

                at oracle.lbs.mapserver.core.MapperConfig.<init>(MapperConfig.java:413)

                at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:133)

                at oracle.lbs.mapserver.MapServerImpl.<init>(MapServerImpl.java:117)

                at oracle.lbs.mapserver.oms$ColdStart.run(oms.java:337)

                at java.lang.Thread.run(Thread.java:662)

              Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

                at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:398)

                at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:438)

                at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:711)

                at oracle.net.ns.NSProtocol.connect(NSProtocol.java:257)

                at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1229)

                at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:326)

                ... 16 more

              Caused by: java.net.ConnectException: Connection refused

                at java.net.PlainSocketImpl.socketConnect(Native Method)

                at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)

                at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)

                at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)

                at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)

                at java.net.Socket.connect(Socket.java:529)

                at oracle.net.nt.MetricsEnabledSocket.connect(TcpNTAdapter.java:631)

                at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:164)

                at oracle.net.nt.ConnOption.connect(ConnOption.java:137)

                at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:374)

                ... 21 more

              Jun 20, 2014 3:25:01 PM oracle.lbs.mapserver.core.MapperConfig createMappers

              SEVERE: Error creating NativeOracleDataSource.

              • 4. Re: MVDemo Mapviewer Integration with OBIEE Issues
                grueningd

                Seems the DB-server "gboract1" is not reachable from the machine where mapviewer is running?

                 

                Did you try "ping gboract1" and "tnsping gboract1" on the machine where mapviewer is installed?

                 

                Maybe Port 4505 is blocked by firewall?