I am trying to fetch 12000 records from DB using a Query rule I am getting the b

vamshikrishnab over 9 years ago

I am trying to fetch 12000 records from DB using a Query rule I am getting the below error. Can I know what is the maximum limit I can set to conf.data.query.memory.limit in custom.properties
Error evaluating function 'queryruleexec' : Memory threshold reached during output conversion (rule: [Trust_getExistingTDAccountInfo], type: [TRUSTTDAccountInfoDT6885], threshold: [2,097,152 bytes], objects successfully converted: [1,687])) (Data Outputs)...

Discussion posts and replies are publicly visible

0 Tejas Kargutkar
Appian Employee
over 9 years ago

The amount of memory in bytes that will be consumed in the application server for a single query before the query is halted is configured using the following property in the custom.properties file:
conf.data.query.memory.limit=1048576

The default is 1048576 bytes (1 MB).

forum.appian.com/.../Post-Install_Configurations.html

Instead of raising this value, I would recommend optimizing the query since raising the value can lead to performance problems.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Mike Cichy
Appian Employee
over 9 years ago

The end of the rule specifies the amount of objects the rule retrieved before it reached the threshold ([1,687]). With this volume, small changes to the data (longer strings, etc.) can have a big effect on how much a query rule can bring back.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vamshikrishnab over 9 years ago

Thanks Teja and Mike for your suggestions
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel