1

Getting below error while executing MKS integrity query.

Cannot show view information: Your query was stopped because it was using too may system resources.

Afriza N. Arief
  • 7,696
  • 5
  • 47
  • 74
maestromani
  • 841
  • 1
  • 9
  • 31

3 Answers3

1

Your query is likely taking longer than the time alotted by the Integrity server to queries. By default this value is 15 seconds. This usually indicates that your query is very broad or that an index needs to be created in the database to help increase the performance of the query. The latter requires the assistance of your database administrator.

DISCLAIMER: I am employed by the PTC Integrity Business Unit (formerly MKS).

Kael
  • 71
  • 1
  • 3
0

one thing that you can check is if your query could have a very big list of items as results. try adding more restrictive filters first and then ease them step by step. At least this was my use case :)

YaP
  • 339
  • 3
  • 13
-1

Try to use filter as much as can, when you use filters it’s limiting unnecessary results.

DeepakK
  • 1
  • 3
  • 1
    The order of answers changes depending on which one are Active, Oldest and Votes. So please don't use "Agree with above comment", as we don't know which one you mean. – Steven Feb 05 '21 at 07:44