Search code examples
progress-4glopenedgeprogress-db

Progress Error: Invalid query with CONTAINS

I'm getting the error "Invalid query with CONTAINS" in one of our application server logs. This service was not experiencing this error yesterday and I'm not aware of anything in our code that might have changed.

Can anyone give any insight into what might be causing this error outside of our code?

Solution

  • 1) CONTAINS operator uses word indexes. Check if index is setup correctly for the error query.

    2) If a word index is defined on a CHARACTER field that is large, you might consider increase the value of the Stash Area (–stsh) startup parameter.

    3) You can also try to rebuild your indexes useing the PROUTIL utility with the IDXBUILD or IDXFIX qualifier.