ZRS Data source connection failed

Hello,

Installed ZRS 8.1.1, updates online to 8.1.2 (first time for me)

Connected Domain (using primary server login)

As you can see an Oracle database

When creating an Ad Hoc view and selecting fields I get:

Has anyone got a tip/idea for me what this could be?

Adding domain went ok, can ping database server. DO I need additional rights on database?

Couldn't find it in manual, but maybe overlooked it.

John

  • 0  

    I would suggest a support ticket.....Very odd you would get this error here.  I will look for some reasons, but I doubt I will find anything.   Since you are Oracle, you are unlikely to be educational, which means your support agreement should include such cases.  If the case appears to get stuck in support, let me know as well as the case number.

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

  • 0 in reply to   

    case is 02888204-ZRS data source connection failed Oracle

    Support asked me to reconfigure domain configuration.

    But didn't help ( I use the zone manager option not the resource file option).

    results in same error message. I can connect to the zone over 7443, could connection from ZRS to database server be the cause? Do I need direct connection from ZRS to database server, maybe look into that?

  • 0   in reply to 

    If you are not getting the help you need.....Please Ask for it to be escalated.  

    I see your Support Engineer did request and get a Sr Engineer to assist.  This person would be the ideal person to help, but perhaps it will be useful to have the case directly assigned if things appear to be dragging.

    --

    If you found this post useful, give it a “Like” or click on "Verify Answer" under the "More" button

    Be sure to "Like" My (and a few others) Cool Solutions below! 

    https://community.microfocus.com/members/craigdwilson/bookmarks

  • Suggested Answer

    0 in reply to   

    After session with opentext and engineer of jaspersoft we replaced the text below for every domain in the file  context.xml in the META-INF folder so it works with Oracle 

    driverClassName="oracle.jdbc.OracleDriver          changed to          driverClassName="tibcosoftware.jdbc.oracle.OracleDriver"

    url="jdbc:oracle:thin:servername database:1521/name of service"  changed to          url="jdbc:tibcosoftware:oracle://servername database:1521;ServiceName=name of service"