Skip to Content
avatar image
Former Member

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

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]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 16, 2017 at 05:17 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 16, 2017 at 05:10 PM

    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 ?

    Add comment
    10|10000 characters needed characters exceeded

    • 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....