Sexigraf Powershell version: "Exception calling "QueryPerf" with "1" argument(s): "XML document element count exceeds configured maximum 500000"

[raphoun]

Hello,

When collecting vcenter with a lot of assets (22000 VMs and 295 hosts) we have this error in Sexigraf and no data for this vcenter.

PS>TerminatingError(): "Exception calling "QueryPerf" with "1" argument(s): "XML document element count exceeds configured maximum 500000

while parsing call information for method QueryPerf
at line 1, column 171

while parsing SOAP body
at line 1, column 64

while parsing SOAP envelope
at line 1, column 0

while parsing HTTP request for method queryStats
on object of type vim.PerformanceManager
at line 1, column 0""
>> TerminatingError(Measure-Command): "Exception calling "QueryPerf" with "1" argument(s): "XML document element count exceeds configured maximum 500000

while parsing call information for method QueryPerf
at line 1, column 171

while parsing SOAP body
at line 1, column 64

while parsing SOAP envelope
at line 1, column 0

while parsing HTTP request for method queryStats
on object of type vim.PerformanceManager
at line 1, column 0""
2022-02-16T08:51:41.6286409+00:00 [ERROR] VM MultiQueryPerf failure
2022-02-16T08:51:41.6290119+00:00 [ERROR] Exception calling "QueryPerf" with "1" argument(s): "XML document element count exceeds configured maximum 500000

while parsing call information for method QueryPerf
at line 1, column 171

while parsing SOAP body
at line 1, column 64

while parsing SOAP envelope
at line 1, column 0

while parsing HTTP request for method queryStats
on object of type vim.PerformanceManager
at line 1, column 0"
2022-02-16T08:51:41.6316179+00:00 [ERROR] Exit
Transcript stopped, output file is /var/log/sexigraf/ViPullStatistics.log
PS>TerminatingError(): "System error."
**********************
PowerShell transcript end
End time: 20220216085141
**********************

Would it be possible to change the way it is collectif to avoid to exceeds the maximum of 50000 elements?

Thanks,

Raphaël

[rschitz]

Hi Raphaël, we can try to split the query when there is more than 15K VMs for ex.
i'll let you know

[raphoun]

Hello Raph

Any new about this feature? :)

[rschitz]

Hi mate, try this new version and let me know ;)