Oracle RAC with TIBCO jasper studio

[uma.shankar61]

Hi We are trying check one of new feature of oracle 19c which Transparent application failover which help the connection to mask any outages from DB and continue to run the workload on the surviving instance. As part of it we would like to know whether TIBCO jasper stuido for reporting support RAC. 

We have tested RAC feature it doesnt failover the connection to surving instance. Request you to help on this .We need to know the  connection properties that are feasabile setting to ONS configuration,FCF for connection failover 

[anish.rai]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Tirupathi Mangalarapu]

Can you please provide more information on how you defined your JDBC connection string information on the Studio Adapter? What driver are you are using? Can you please explain in detail what you mean by it does not failover any errors etc?

 

[uma.shankar61]

we are using 19c jdbc drivers. we are tried using full tnsentry and ldap connection string. We are getting no more data to read from socket is the error we are getting

[uma.shankar61]

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Unable to get next record from result set.
    at com.jaspersoft.studio.editor.preview.view.control.ReportController.fillReport(ReportController.java:551)
    at com.jaspersoft.studio.editor.preview.view.control.ReportController.access$18(ReportController.java:526)
    at com.jaspersoft.studio.editor.preview.view.control.ReportController$1.run(ReportController.java:444)
    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: net.sf.jasperreports.engine.JRException: Unable to get next record from result set.
    at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:170)
    at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:1556)
    at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1399)
    at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:1378)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1200)
    at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:112)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:621)
    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:135)
    at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLRecoverableException: No more data to read from socket
    at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:811)
    at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:449)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:410)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
    at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1079)
    at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3456)
    at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:742)
    at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:698)
    at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:412)
    at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:166)
    ... 8 more
 

[Tirupathi Mangalarapu]

Hello Uma, 

Based on the error message, the connection is no longer valid, and hence you see this error. I would like to see the connection string of your JDBC driver and the parameters that you passed.