Calrity: Error java.nio.BufferUnderflowException When Trying to Establish a Connection With JDBC on Database Connectivity while installing Jaspersoft

Products

• Clarity PPM On Premise

Issue/Introduction

While Installing Jaspersoft provided with Clarity, there is an error java.nio.BufferUnderflowException When Trying to Establish a Connection With JDBC and installation breaks 

 

BUILD FAILED
D:\Jaspersoft\ca_ppm_jaspersoft_7.1.0_6.1.0.28\install.xml:289: The following error occurred while executing this line:
D:\Jaspersoft\ca_ppm_jaspersoft_7.1.0_6.1.0.28\install.xml:610: Unable to connect Jasper Database  ERROR: java.nio.BufferUnderflowException

Cause

While installation Jaspersoft used native Oracle driver and due to a known bug in Oracle Version 12.1.0.2.0 to 12.2.0.0.0 [Release 12.1 to 12c] which causes this issue.The issue is caused by failure to connect to database with a large security banner set. More information about this defect is provided in oracle support site and attached to this knowledge base too 

 

 

Environment

Jaspersoft with Oracle 12.1.0.2.0 to 12.2.0.0.0  as database 

Resolution

Please use the workaround provided by Oracle to either apply the oracle patch or reduce the sec_user_unauthorized_access_banner in the database sqlnet.ora below 231 bytes long