Pagination - Memory threshold issue.

saicharanb over 7 years ago

We have a query as below
rule!WFT_getRequestDetailsBySearchParams(ri!process,ri!subprocess,ri!action,ri!requestor,ri!company,ri!reference,ri!sapRefNo,if(isnull(ri!fromDate),todatetime(date(2010,10,10)),ri!fromDate),if(isnull(ri!toDate),todatetime((today())),ri!toDate+intervalds(23,59,59)),ri!monetaryValue,ri!priority,ri!wftRequestID,ri!salesOffice,ri!requestStatus,ri!pageInfo)))

In the above query how is "ri!pageInfo" working? I could not find any parameters like batch size set for pageInfo. Please help how does it work for the above query.

How does pageInfo decrease the load on Appian? I have referred the below link, but did not understand much, Please help me on this.
forum.appian.com/.../System_Functions.html

Discussion posts and replies are publicly visible

Parents

0 saicharanb over 7 years ago

@sikhivahans: 1. Yes I am using data!pagingInfo when I reduced RowsPerPage.
2.Yes, I am facing the below error visually -
Error evaluating function 'queryruleexec' : Memory threshold reached during output conversion (rule: [WFT_getRequestDetailsBySearchParams], type: [WFTRequestDetailsDT863], threshold: [1,048,576 bytes], objects successfully converted: [493]))
com.appiancorp.process.expression.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'wft_getrequestdetailsbysearchparams' (called by rule 'wft_temposearchquery') at function 'queryruleexec': Error evaluating function 'queryruleexec' : Memory threshold reached during output conversion (rule: [WFT_getRequestDetailsBySearchParams], type: [WFTRequestDetailsDT863], threshold: [1,048,576 bytes], objects successfully converted: [493]) (APNX-1-4198-000)

3. Different query rules with different batch size, how do I join/integrate two queryRules. For example: I have two query Rules, How to call both in my data set.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 saicharanb over 7 years ago

@sikhivahans: 1. Yes I am using data!pagingInfo when I reduced RowsPerPage.
2.Yes, I am facing the below error visually -
Error evaluating function 'queryruleexec' : Memory threshold reached during output conversion (rule: [WFT_getRequestDetailsBySearchParams], type: [WFTRequestDetailsDT863], threshold: [1,048,576 bytes], objects successfully converted: [493]))
com.appiancorp.process.expression.ExpressionRuntimeException$AppianExceptionProvider: Expression evaluation error in rule 'wft_getrequestdetailsbysearchparams' (called by rule 'wft_temposearchquery') at function 'queryruleexec': Error evaluating function 'queryruleexec' : Memory threshold reached during output conversion (rule: [WFT_getRequestDetailsBySearchParams], type: [WFTRequestDetailsDT863], threshold: [1,048,576 bytes], objects successfully converted: [493]) (APNX-1-4198-000)

3. Different query rules with different batch size, how do I join/integrate two queryRules. For example: I have two query Rules, How to call both in my data set.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data