Symantec IGA

  • 1.  IDSuite and Jasperreport server

    Posted Nov 13, 2017 07:44 AM

    Team,

     

    I'm trying to setup a jasperreporting server to run the reports from the Identity manager console.

    I checked the connectivity from Identity manager. Connection test is ok.

    However when i run a report (eg Roles report) i'm getting the following error :

    jrs.jsexception.error.creating.connection

     

    java.sql.SQLNonTransientConnectionException: [TibcoSoftwareInc][Oracle JDBC Driver]database_srv at tibcosoftwareinc.jdbc.oraclebase.ddcr.b(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.ddcr.a(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.ddcq.b(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.ddcq.a(Unknown Source) at tibcosoftwareinc.jdbc.oracle.OracleImplConnection.y(Unknown Source) at tibcosoftwareinc.jdbc.oracle.OracleImplConnection.a(Unknown Source) at tibcosoftwareinc.jdbc.oracle.OracleImplConnection.ai(Unknown Source) at tibcosoftwareinc.jdbc.oracle.OracleImplConnection.b(Unknown Source) at tibcosoftwareinc.jdbc.oracle.OracleImplConnection._(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.BaseConnection.b(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.BaseConnection.k(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.BaseConnection.b(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.BaseConnection.a(Unknown Source) at tibcosoftwareinc.jdbc.oraclebase.BaseDriver.connect(Unknown Source) at tibcosoftware.jdbc.common.oracle.DriverImpl.connectDriver(DriverImpl.java:50) at tibcosoftware.jdbc.oracle.OracleDriver.connect(OracleDriver.java:56) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) at
    Anyone seen this before and knows how to solve ?
    Regards,
    Frank


  • 2.  Re: IDSuite and Jasperreport server
    Best Answer

    Broadcom Employee
    Posted Nov 13, 2017 08:37 AM

    Hi Frank

     

    It seems you are using an Identity Suite Virtual Appliance. Does your jaspersoft server resolve the host database_srv? Add database_srv to your jaspersoft server's hosts file with your VApp IP address and see if this solves your issue.

     

    KR
    Russi