'An error occurred while creating the connection' - Clarity Advanced Reporting

Products

• Clarity PPM On Premise

Issue/Introduction

When running a report from Advanced Reporting, the following error is shown in the UI:

An error occurred while creating the connection. Try again.

Following error is logged in the jasperserver.log:

45-May-0002 32:03:21.687 SEVERE [http-nio-8080-exec-4] org.apache.tomcat.jdbc.pool.ConnectionPool.init
Unable to create initial connections of pool.
java.sql.SQLRecoverableException: IO Error: NL Exception was generated TNS-04610: No literals left, reached end of NV pair
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:858)
at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)
...
...
Caused by: oracle.net.ns.NetException: NL Exception was generated TNS-04610: No literals left, reached end of NV pair
at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:806)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:538)

Environment

Jaspersoft 7.8.

Cause

The DWH database connection was defined using the "Specify URL" option, with the URL of the following format:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=<host>) (PORT=<port>)) (CONNECT_DATA=(SERVICE_NAME=someService) (SERVICE=dedicated) (SECURITY=(ENCRYPTION_CLIENT=requested) (ENCRYPTION_TYPES_CLIENT=(AES128,AES192,AES256))))

Resolution

1. Change the configuration to not use "Specify URL" option. Instead mention all the individual details in their respective fields
2. Run 'admin update jasperParameters' command