Searching by expression in /design/objects fails with the following error
/design/objects
Additionally, the following error appears in the application server log:
ERROR com.appiancorp.rest.shared.AppianExceptionMapper - Internal Server Error on REST API invocation. com.appiancorp.exceptions.LocalizedAppianRuntimeException$LocalizedAppianException: Expression evaluation error [evaluation ID = <EVALUATION_ID>] : Query failed [request=CdtQueryRequest{from=ObjectInfo (id=-10), timeZone=null, query=Query[Selection[uuid (show)], criteria[CdtSearch{field=expressions, searchQuery=753, searchType=prefix, isHighlightResults=true, startTag=<EE><89><95><EE><89><96>, endTag=<EE><89><95>, snippetLength=100}], PagingInfo[startIndex=0, batchSize=10000, sort=[Sort[#RELEVANCE# desc]]]]}, ES SearchRequest=SearchRequest{searchType=QUERY_THEN_FETCH, indices=[designer-objects-ia-7-5], indicesOptions=IndicesOptions[ignore_unavailable=false, allow_no_indices=true, expand_wildcards_open=true, expand_wildcards_closed=false, expand_wildcards_hidden=false, allow_aliases_to_multiple_indices=true, forbid_closed_indices=true, ignore_aliases=false, ignore_throttled=true], types=[], routing='null', preference='null', requestCache=null, scroll=null, maxConcurrentShardRequests=0, batchedReduceSize=512, preFilterShardSize=null, allowPartialSearchResults=null, localClusterAlias=null, getOrCreateAbsoluteStartMillis=-1, ccsMinimizeRoundtrips=true, source={"from":0,"size":10000,"query":{"bool":{"must":[{"bool":{"must":[{"match_phrase_prefix":{"expressions":{"query":"753","slop":0,"max_expansions":50,"boost":1.0}}}],"adjust_pure_negative":true,"boost":1.0}}],"filter":[{"term":{"_t":{"value":"DTObjectInfo","boost":1.0}}}],"adjust_pure_negative":true,"boost":1.0}},"version":true,"_source":{"includes":["uuid"],"excludes":[]},"sort":[{"_score":{"order":"desc"}}],"track_total_hits":2147483647,"highlight":{"pre_tags":["<EE><89><95><EE><89><96>"],"post_tags":["<EE><89><95>"],"fields":{"expressions":{"fragment_size":100}}}}}] (APNX-1-4198-000)...Caused by: ElasticsearchException[Elasticsearch exception [type=illegal_argument_exception, reason=The length of [expressions] field of [<OBJECT_UUID>] doc of [designer-objects-ia-7-5] index has exceeded [1000000] - maximum allowed to be analyzed for highlighting. This maximum can be set by changing the [index.highlight.max_analyzed_offset] index level setting. For large texts, indexing with offsets or term vectors is recommended!]]
An object was found which exceeded the Search Server's maximum content size limit of 1,000,000 characters. Using objects with content size over 1,000,000 may cause issues.
A product use case to improve handling of objects with content size greater than 1,000,000 characters has been logged to the Appian Product Team for consideration to add this functionality in the product. Please note it is not Appian Support’s policy to disclose how or when a product use case will be implemented.
Caused by: ElasticsearchException[Elasticsearch exception [type=illegal_argument_exception, reason=The length of [expressions] field of [<OBJECT_UUID>] doc of [designer-objects-ia-7-5] index has exceeded [1000000] - maximum allowed to be analyzed for highlighting. This maximum can be set by changing the [index.highlight.max_analyzed_offset] index level setting. For large texts, indexing with offsets or term vectors is recommended!]]
This article applies to all versions of Appian.
Last Reviewed: February 2022