Winshuttle Support systems have migrated into Precisely systems. If you weren't automatically forwarded to the new system, please go to https://support.precisely.com to access Suppport.

Adaptive Query Throttling setting is getting enabled at query level for runner user, even though it is disabled while creating with developer user setting.
Query - Criteria = and IN not working on Sales Org
How to make a Query macro with a xml file
Query / IN Operator: The file for selecting values is empty
Error: "String or binary data would be truncated"
Can I use Query to extract data from a Structure?
Query Create From Recording is Grayed Out
Missing the DataColumn 'DomainName' in the DataTable 'Fields' for the SourceColumn 'DomainName'
When adding new fields to Query script, how can I change the order?
Exception of type 'System.OutOfMemoryException' was thrown

Exception of type 'System.OutOfMemoryException' was thrown

Madison Silva

June 27, 2019 22:46
Updated

Description

This error can appear when the Query is extracting a high number of entries and your system is unable to extract all the data at the same time.

Applies to

Query 10.x
Studio 11.x and Higher

Solution

Enable the Data Chunking feature in Query to avoid extracting all the data at the same time. When selecting a value to chunk at we suggest testing different values to find the highest number that will give a successful run.

Studio 11.x / 12.x, in Developer Settings on the Run tab:

Query 10.x, in the Advanced Run Options panel:

Comments

0 comments

Please sign in to leave a comment.

# Notification banner writer

Articles in this section

Description

Applies to

Solution

Related articles