Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Mondrian cannot use JDBC Data source which uses Oracle TNS name

  1. #1
    Join Date
    Oct 2014

    Question Mondrian cannot use JDBC Data source which uses Oracle TNS name

    Hello All,

    Could someone please help with the following issue:

    I have 2 JDBC Data sources created in Pentaho BA Server:

    1. Oracle Connection with providing user credentials, host, port and SID as database name.
    2. Oracle Connections with providing user credentials and TNS name as database name, since if there is SERVICE NAME then I should use TNS name.

    Both above connections ping successfully.

    When I use the #1 Option as JDBC Data source for my Cube schema - everything works.
    But, when I use the #2 Option, cube cannot be loaded and the following exception occurs in the log file:

    java.lang.RuntimeException: Unable to get connnection jdbc:mondrianataSource=Report DB; EnableXmla=false; overwrite=false; Locale=en_US; Catalog=mondrian:/My_Cube_Schema; UseContentChecksum=true
    at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:152)
    at com.pentaho.analyzer.service.impl.OlapConnectionManagerImpl.createConnection(SourceFile:75)
    at com.pentaho.analyzer.service.impl.a.getConnection(SourceFile:55)

    So, the question is, how could I achieve the connection for my cube, if I have just SERVICE NAME as for connection to DB.

    Any help would be appreciated!


    Last edited by bagdat; 08-09-2018 at 05:46 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.