Clarity Jaspersoft (Advanced Reporting) Data Sources break with load balanced connection strings

Products

• Clarity PPM On Premise

Issue/Introduction

Steps to Reproduce:

1. Open Clarity NSA
2. Navigate to Database section
3. Check the "Use URL" flag for the database
4. Use the following connection format. It leverages the Load Balance feature of multiple Oracle hosts
   • jdbc:oracle:thin:@(DESCRIPTION=(RETRY_COUNT=20)(RETRY_DELAY=10)(ADDRESS_LIST= (LOAD_BALANCE=ON) (ADDRESS=(PROTOCOL=tcp)(HOST=server1.example.com)(PORT=1561)) (ADDRESS=(PROTOCOL=tcp)(HOST=server2.example.com)(PORT=1561))) (CONNECT_DATA=(SERVICE_NAME=SERVICENAME)))
5. Run "admin update jasperParameters" command from a Clarity app server
6. Attempt using Clarity application. Also attempt to run Jaspersoft reports

Expected Result:

• Clarity and Reports both should be running successfully

Actual Result:

• Clarity runs fine. However reports are failing with database connectivity errors. Following error is shown when a report is executed:
  • An error occurred while creating the connection. Try again.

Environment

Clarity 16.0.3

Cause

Jaspersoft is currently unable to connect using the Load Balanced connection strings. This is reported as DE68875.

Resolution

This is addressed in Clarity 16.1.2.