Query Error "Too Many Values"

[shokkul]

config values related to query

Code: Select all

[valarch]
queryMaxValues = 0

[event]
maxDpNamesCount = 0

[data]
maxLinesInQuery  = 0
maxValueRequestCount  = 0

Error in the Logfile

Code: Select all

WCCOAui      (1), 2019.12.10 14:58:11.912, PARAM,SEVERE,    143, Query aborted with the following error: HistQuery, constructAnswerMsg, archive request returns an error - too many values!

Hello All,

I am using query for historical data and I get "too many values" error. I already set config files for removing limitations for query but I am still experiencing query error. What can I do to get rid of this error?

Thanks

[leoknipp]

If you search the Knowledge Base --> Log-Messages for this error you will find an entry for it:

https://www.winccoa.com/knowledge-base/ ... df0a7b602f

Best Regards
Leopold Knipp
Senior Support Specialist

[shokkul]

Hello Leoknipp, thanks for your reply,

Yes I found this entry and according to that entry I set maxLinesInQuery and maxValueRequestCount option to zero but I am still getting too many values error. Is there any other reason that I encounter this problem?

Thanks

[leoknipp]

Which type of archiving are you using?
If HDB archiving is used you possibly have to modify the limits for the HDB managers too.
Please have a look at the PVSS_II.log file to see if you get log message from other managers when trying to read data.

Best Regards
Leopold Knipp
Senior Support Specialist

[shokkul]

I fixed the issue with set maxLinesInQuery and maxValueRequestCount option to very high value (10.000.000) so it means setting these values to 0 doesn't remove the limiters. I think it's a bug

Thanks

[leoknipp]

We have not seen problems when deactivating the limits for the queries.
Please take into account that you must use useful limits. Huge queries will take a lot of time and also processing the result will take time and will possibly cause a high memory usage.

Have you been using the value 0 for both entries and it did not work?
Have you restarted the system after modifiying the config files?
How many results/values do you read from the database and what is done with the data?

Best Regards
Leopold Knipp
Senior Support Specialist