Getting the memory threshold issue while executing Query rule

Question

Hi getting the following error 
 Can any one help to increase the threshold 
 
 There is a problem with task &ldquo;GetPipelineDetailsForUploaded datafromDB&rdquo; in the process &ldquo;PRTRR Upload Pipeline Candidates-806609311-3385&rdquo;. ERROR:An error occurred while evaluating expression: RemovedPipelineList:rule!PRTRR_getRemovedPipelineDetails(ac!pipelinekey,true(),true()) (Expression evaluation error in rule 'prtrr_getremovedpipelinedetails' at function 'queryruleexec': Memory threshold reached during output conversion (rule: [PRTRR_getRemovedPipelineDetails], type: [PRTRRVWPipelineCandidateDT5402], threshold: [1,048,576 bytes], objects successfully converted: [2,255])) (Data Outputs)

Sidhant Behura · Answer

You can optimize your querying using query entity. If you think it wont still wont work(query entity or using batchsize/paging) you can consider increasing "conf.data.query.memory.limit" property. Refer this link : docs.appian.com/.../Post-Install_Configurations.html Also refer database performance best practices : community.appian.com/.../database-performance-best-practices I faced this same problem and the solution which I considered is pulling data is batches and using them.

Getting the memory threshold issue while executing Query rule

Top Replies