Memory Allocation Failure for pRSData in Function

 

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