Run out of memory popup error in the Workstation when running a SQL statement that selects a large dataset

Products

• Service Virtualization

Issue/Introduction

The following error is shown in the Workstation, when running a Virtual Service in ITR that selects a large dataset in a JDBC step:

 

DevTest Workstation has run out of memory. Please either 1) Close unneeded screens, 2) Increase the memory size for the DevTest Workstation process (see Documentation on this), or 3) Restart the application and try again.

There is also a memory error when deploying the VS in the VSE.

Environment

All supported DevTest environments

Cause

Insufficient Java Heap size

Resolution

Increase the Java Memory Settings in C:\Program Files\CA\DevTest\bin\Workstation.vmoptions
Increase Xmx for example from: 

-Xmx512m

To: 

-Xm2048m

To address the memory error for the VSE, increase the Java Memory Settings in C:\Program Files\CA\DevTest\bin\VirtualServiceEnvironmentService.vmoptions

Additional Information

Memory Settings