Masking Job Failure: Insufficient System Memory

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Masking jobs in the TDM Portal may fail with "Insufficient system memory in resource pool 'default'". This typically occurs during high-volume masking operations.

Sample log:

Message: There is insufficient system memory in resource pool 'default' to run this query.
   SQLSTATE: S0135
   Error code: 701

Cause

Error 701 indicates that SQL Server's database engine failed to allocate enough memory to execute the query. This usually happens because the query is requesting a massive memory grant, or the server is experiencing severe internal memory pressure.

Resolution

1. Tune Masking options:

   • Reduce the fetchSize and commitSize in your masking configuration (e.g., from 50,000 down to 10,000).
   • If "Large Table Split" is enabled, consider disabling it for the affected masking job to reduce DB load.

2. Check Database Resource Governor:

   • Check with your DBA if there are specific memory limits applied to the 'default' resource pool, or if any more resource available.

3. Additional Info:

   • Refer to the article: Optimizing and Troubleshooting Masking Job Failures in CA Test Data Manager for further configuration guidelines.