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)
Jaspersoft 7.8.
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))))