Problem Description:

Showcase Query users get a Change Link error when trying to run existing queries, followed by: Memory allocation failure for pRSData in function allocateResultSetMemoryForBlocking().

Users creating a new query will also see this error. Everything was running fine until they started getting the error.

ShowCase server job log contains:

*NONE Information 10/15/14 08:55:05.964290 SCJNAT SUP9300 *STMT SCJNAT SUP9300 *STMT
From module . . . . . . . . : JOBLOGOS
From procedure . . . . . . : Java_com_showcasecorp_JoblogOutputStream_internalFlush
Statement . . . . . . . . . : 19
To module . . . . . . . . . : JOBLOGOS
To procedure . . . . . . . : Java_com_showcasecorp_JoblogOutputStream_internalFlush
Statement . . . . . . . . . : 19
Thread . . . . : 00002A01
Message . . . . : JDBC ERROR ACJDE RMI TCP Connection(9722)-192.168.12.198 "10/15/2014 08:55:05.964 AM" java.sql.SQLException:
Memory allocation failure for pRSData in function allocateResultSetMemoryForBlocking().

Resolution

Unknown cause, but could be related to a problem in JVM memory allocation. Restart the Showcase server to start a new JVM. This should resolve the issue. However, if memory problems persist, it's possible to force the Showcase server to use a different version of Java using the following steps:

To change the JVM, do this:

  1. From an IBMi command line, enter

    edtf '/scserver/proddata/config/showcase.cfg'

    (this is example, "scserver" is the name of the ShowCase server library)

  2. On a blank line near the top, enter this:

    showcasecorp.scserver.jvm.path=/QOpenSys/QIBM/ProdData/JavaVM/jdk70/64bit

  3. Save and exit by hitting F3 twice
  4. Restart the ShowCase server using the ENDSCSVER and STRSCSVER commands

Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: March 25, 2019