We have an web application which uses HPRM 8.3 as its backend (connection done via. SDK). The web app helps user create custom searches which are executed in HPRM and output is shown to the user.
All the features likes sorting, searching (we use string-based searches) work quiet well. But on certian scenarios we receive the following error from HPRM:
"HPE record manager Workgroup Server on <server> reported an error.
Your search is too complicated and cannot be processed by the SQL engine.
Please simplify your query before trying again"
When we run the same query (or create and execute same query) in the HPRM 8.3 Desktop application we are able to get the results. We generally get this in queries which have 'contains()' method (but not always).
Is there any specific flag we have to set to get this working or extend the complexity level using the SDK.
Also, does this depend on length of the string-query we are sending through SDK ?