hi,
Our Windows application server (2022) keeps going down with below error message. We have our PB 2022 R2 application hosted on this server..
Windows Management Instrumentation has stopped WMIPRVSE.EXE because a quota reached a warning value. Quota: ThreadCount Value: 259 Maximum value: 256 WMIPRVSE PID: 53864 Providers hosted in this process: C:\Windows\System32\wbem\WmiPerfClass.dll, C:\Windows\System32\wbem\WmiPerfClass.dll
the error implies Application Queries using the WMI process ...that it has a Thread limit of 256 .... and the error implies it found 259
We dont know whats causing this as we didnt had this issue before we migrated to PB 2022 R2.. The Oracle version we are using is 19c in case anybody needs to know. This is affecting our production and always bringing primary server down and inaccessible by Infrastructure team as well.. only workaround is to reboot server so far.
Would appreciate any advise to fix the same.
Thanks,
Joy
My intention was not to say that PB upgrade is causing the issue, but more if this was a new feature or something as we never had this issue before. We migrated in april 2024 but issue was seen from 7/31.. My Infra team is also trying to decipher as to what is causing the issue. If required we will engage with Windows support and Citrix support as well. Yesterday's issue co-incided with our Database going down as well. The error seemed to point to application making too many queries thats why i was asked to look at the application layer. My dev team investigated but said they never heard or used it for anything thus i came to you all for guidance.
As far as your database going down, it is possible there is some coding issue in your PowerBuilder app that is overloading your database. Sometimes coding issues go undetected until exactly the moon and sun align and then blows things up. I say this because gain I think it is coincidence there is database issue with the PB 2022 upgrade. We have not made changes in how DB connections/transactions work. You can review the new features guide by version to understand exactly what changes Appeon has made between your previous version and PB 2022: https://docs.appeon.com/pb/whats_new/index.html
One thing you might want to do is check if any configurations have changed or if you upgraded the Oracle client at the time you did the PB 2022 upgrade. It could be configuration change or upgrade to Oracle client causing the issue?