ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Jaspersoft Install error 'java.nio.BufferUnderflowException' when trying to establish a connection with JDBC on DB

book

Article ID: 194839

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

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

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] this causes this issue. The issue is caused by a failure to connect to the database (DB) with a large security banner set. More information about this defect is provided on the oracle support site and attached to this knowledge base article.

Environment

Jaspersoft with Oracle 12.1.0.2.0 to 12.2.0.0.0 as database 

Resolution

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

Additional Information

See also: Jaspersoft / reports known issues with Clarity

Attachments

1594378658936__Document 2361281.1.pdf get_app