Forum Discussion
On Premises Gateway utilizing many Oracle database connections (PBIEgwService)
Hi andershh,
In order for gateway to flush out its connections, you would need to periodically run a similar script suggested by brendan_w in the following thread to restart gateway.
Replace GWConfig.exe with EnterpriseGatewayConfigurator.exe in the script that brendan_w provides , and the EnterpriseGatewayConfigurator.exe locates in C:\Program Files\On-premises data gateway.
Thanks,
Lydia Zhang
Hi Anonymous,
I'm experiencing the same issue and think this solution may be able to help also. However, the last line of the batch file will start the Gateway Config program which launches a dialog box that asks you to sign in and register the gateway. If I want to schedule this batch job to run nightly, how do I avoid this? I can't be logging into the server every day to click through the dialog boxes.
Thanks in advance!
- Ira
I did the search and found that this DEFECT has been discussed in this forum since 2015, any permanent fixing or solution ? Also the forum was closed with solved status which is not, it just the interim to restart or kill the process.