PVSS00event - PARAM/WARNING - EvQueryList, doQuery, Max. parse time for query exceeded, query aborted

Enclosed you'll find the explanation for a log-message which can occur when a limit for non-historical event-queries is reached. The log-message is written to the PVSS_II.log-file.

PVSS00event (0), 2011.10.06 13:49:13.531, PARAM,WARNING, 54, Unexpected state, EvQueryList, doQuery, Max. parse time for query exceeded, query aborted, SELECT '_online.._stime','_online.._user','_online.._manager','_online.._value','_online.._text','_online.._status' FROM '{DPGROUP(_DpGroup00022_Public)}' WHERE _LEAF

 

Log-message with symbolic names:

PVSS00event (0), <TIMESTAMP>, PARAM,WARNING, 54, Unexpected state, EvQueryList, doQuery, Max. parse time for query exceeded, query aborted, <query-string>


This log-message describes that allowed parse time for resolving the query-string was reached. The limitation is made with the config-entry maxParseTime in the [event]-section.

If the function getLastError() is used in the script where the function to read the data was started you’ll get the following error. When using the function throwError() the error is written to the PVSS_II.log-file.

PVSS00ui (1), <TIMESTAMP>, PARAM,SEVERE, 81, Syntax error, Connect doQuery not successful, max. allowed parsing time exceeded


If this error is reported please check if this query should be allowed or not. The maximum value has to be defined in discussion with the users operating the plant.

Please do not increase the value for the config-entry to a very high value (e.g. 180) or set it to 0 (no limitation).
While the event-manager is parsing the query-statement other functions at the event-manager will not be executed and the system is “blocking”.

The limitation for queries is part of the system stability functions in WinCC OA. For details please have a look at the online-help, search for the keywords “Error tolerance” and “stability”.

Date added:
Last revised:
Hits:
5.813
Rating:
Rating: 3.3. 83 vote(s).
83 anonymous votes
No rating done at all.
Your vote was '' (0 of 5) You are an anonymous user.
You may log on to do personalized votings
Click the rating bar to rate this item Please log on to do ratings
  • Notification

    FE user cannot be identified! (1403201096)