Skip to Content
0

SAP Crystal Reports 2013 - Java Out of Memory Error - Database Connection

Jun 16, 2017 at 03:33 PM

107

avatar image
Former Member

I run the SIEM (Security Information and Event Management) tool for a municipal utility called Eugene Water and Electric Board. Under NERC CIP regulations we have to run certain reports on a regular basis.

We are using a SIEM tool that has a database I can connect to using .jar files they provided and a JDBC connection. I run the full version of Crystal Reports 2013 in order to get custom reporting out of this database that is not possible with the provided tool. I ran into an issue where the only way the connection is made successfully is through a non-TLS (non-secure) connection.

While it is possible to connect in an insecure manner, but due to the sensitivity of the data, it is not possible to operate this way outside of the test system.

1) Is there a way to resolve the error message below by setting up TLS, if so where would that be? I am open to .jar files, keystores, and xml's, whatever it takes to correct the problem.

2) Is the error below related to the client or server?

3) I can provide the name of the SIEM tool in a private message if that will help.

Logon failed.

Details: SQL Exception: [SQL State:] 08006 [Error Message:] connection exception: connection failure: java.lang.OutOfMemoryError: Java heap space [Database Vendor Code: -1305]

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Brian Dong Jun 16, 2017 at 05:17 PM
0

Hi Jason,

In the Windows Control Panel, run the JAVA Control Panel. In the Advanced tab, there should be a section for Advanced Security Settings. Make sure the options for Use TLS 1.0, 1.1 and 1.2 are selected.

The problem is definitely on the driver side but it does sound like the driver is failing because JAVA isn't properly configured.

Good luck,

Brian

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

I check both boxes for update TLS protocols. Will see what happens on next connection attempt.

0
Denis Konovalov
Jun 16, 2017 at 05:10 PM
0

I'm not sure how this error can be related to TLS and secured connections.
It says that the java process responsible for the connection (your jdbc connection) is running out of heap space.

I'd say you need to talk to the vendor of this jdbc driver and DB you're connecting to , so they can provide details of why it happens.

This error doesn't come from CR, it comes from DB connection.

Also, where and when in the workflow do you see this ?

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Denis,

Thank you for the context. I was not sure what end the message was produced from.

1) You are spot on with the JDBC driver, it is a custom driver and database provided by the vendor. They don't officially support it, so I am pushing hard in any direction that provides a solution. Very important to a local utility with a smaller budget. Awaiting a new response from their side.

2) The error comes during the Data Explorer step. With TLS enabled on the server side, I use Data Explorer to connect to my saved connection jdbc:hsqldb:hsql//xxx.xxx.xxx.xxx/"database name here." If I disabled TLS on the server side it works.

3) They have a light version of SAP Crystal Reports that they built and with TLS on, custom drivers, and config theirs works just fine. They support that setup, but not the full version. They helped get me setup with a non-TLS connection and then said TLS was out of scope, but will try to check with Dev, so I am waiting on more from them.

4) Still trying SAP community in case there is a setting you all know about that we missed. I performed troubleshooting over the weekend and came up with this.

I increased the Java Heap Size in the CRConfig.xml due to the wording of the error message. I then received an additional error directly following another logon attempt:

<JVMMaxHeap>1024000000</JVMMaxHeap>

<JVMMinHeap>64000000</JVMMinHeap>

I raised min and max.

Logon failed:

Details: SQL Exception: [SQL State:] 08006 [Error Message:]

Connection exception: connection failure: org.hsqldb.HsqlException:

Connection exception [Database Vendor Code: -1305]

0

Interesting. I wonder what is the difference between light and normal CR.

When SSL is enabled the connection driver will use more memory, see if you can monitor memory usage by processes during workflow, see which one is taxing.

Second error is not helpful at all. Again its coming from driver but with no details. maybe that's why that vendor is not supporting this particular config....

0