AnsweredAssumed Answered

Jaspersoft install connection reset

Question asked by chris_shaffer on Sep 18, 2015
Latest reply on Apr 28, 2016 by bursy01

Hello,

 

I am doing an install of Jaspersoft with 14.2 on Oracle (non-rac). When upgrading the CA PPM I encountered the "connection reset" issue with the c-oracle.jar driver (https://communities.ca.com/thread/241727918). I then hit the issue outlined in the Change and Impact Guide around the non oracle rac and the additional JDBC parameters.Everything went fine and the upgrade completed.

 

While installing Jaspersoft on RHEL, I am encountering a similar issue. First, I got a logon denied message when I know the logon works. I copied the working c-oracle.jar file to the Jaspersoft install and I was able to make it past that error. Next I encounter a random connection reset error from JDBC. This appears to be the same JDBC issue from CA PPM but this time I am out of ideas on what to update.

 

Has anyone seen or encountered this before?

 

ldfile: /nfs/ppminstall/jaspersoft/install/buildomatic/build.xml

     [echo] Filtering properties (cleaning out blank spaces)

[encrypt-props] Encrypt dbPassword,sysPassword

     [echo] chkIfPackageManagedTomcat: check if package managed tomcat

     [echo] Tomcat DBCP Factory: com.jaspersoft.jasperserver.tomcat.jndi.JSBasicDataSourceFactory

     [echo] creating /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default

    [mkdir] Created dir: /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default

     [copy] Copying 1 file to /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default

     [copy] Copying 1 file to /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default

     [copy] Copying 1 file to /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default

     [copy] Copying 1 file to /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default

     [echo] dbSidOrServiceName = :CLAR0U

     [echo] dbSidOrServiceNameProp = SID=CLAR0U

     [copy] Copying 1 file to /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default

     [echo] chkAndSetLocaleDbSettings: parse: scripts.properties for db commands

     [copy] Copying 32 files to /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default

     [copy] Copying 1 file to /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default

     [copy] Copying 1 file to /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default/webapp/WEB-INF

     [echo] chkIfPackageManagedTomcat: check if package managed tomcat

     [echo] using settings file: /nfs/ppminstall/jaspersoft/install/buildomatic/build_conf/default/maven_settin gs.xml

 

init-js-db-pro:

     [echo] For JDBC driver the artifactId and version properties are set:

     [echo] maven.jdbc.artifactId=ojdbc6

     [echo]   maven.jdbc.version=11.2.0.4

     [echo]   Specified JDBC driver jar exists

 

BUILD FAILED

/nfs/ppminstall/jaspersoft/install/buildomatic/bin/db-common.xml:92: The following error occurred while executi ng this line:

/nfs/ppminstall/jaspersoft/install/buildomatic/bin/app-server.xml:60: java.sql.SQLRecoverableException: IO Erro r: Connection reset

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

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

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

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

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

        at com.jaspersoft.buildomatic.sql.ant.AdvancedSQLExec.establishConnection(AdvancedSQLExec.java:177)

        at com.jaspersoft.buildomatic.sql.ant.AdvancedSQLExec.getConnection(AdvancedSQLExec.java:145)

        at com.jaspersoft.buildomatic.sql.ant.AdvancedSQLExec.execute(AdvancedSQLExec.java:78)

Outcomes