Problem Note 63596: An incremental indexing job with a delete-by-query call fails, and an error in the Elasticsearch log states that there are too many query terms
 |  |  |  |  |
In SAS® Visual Investigator, when you run an incremental indexing job for the delete table, the indexing job can fail with an error indicating that there are too many query terms.
This issue can occur under these circumstances:
- You have an entity with at least one relationship for incremental deletions.
- There are 1,025 or more objects in the delete table.
- You run an incremental indexing job to pick up all the deletions.
The expectation is that all items in the delete table will be deleted from Elasticsearch. However, you might see that the indexing job fails, and the Elasticsearch log indicates that the job fails because there are too many query terms.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.3.1 | Viya | ||
An update for this issue is available for SAS Visual Investigator 10.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-02-04 11:41:55 |
| Date Created: | 2019-02-01 17:02:27 |