on 03-09-2017 11:12 AM
We recently upgraded our software to use Data Dictionary instead of free tables, but we are having some issues with it. One of them was performance (because encryption was turned on, but that problem is fixed), but the second problem is more important:
Sometimes the Data Dictionary file is not closed when using the disconnect method. This connections stay open forever... There are only 2 solutions I found to close the connections :
- Restarting the server
- Using sp_MgKillUser
Both solutions have their own problems, restarting the server is not always possible and using sp_MgKillUser requires to restart all programs using the connection ( otherwise a lot of unexpected errors can occur)
Is this a known bug in ADS 10.10/11.10 and is there a better solution to kill these stale connections?
Thomas,
This issue is going to need more in-depth investigation. Please open a support incident.
Thanks,
Mike Loop
Senior Support Engineer
SAP Product Support
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The program is made using Delphi XE, the database is running on a Windows Server 2012 R2.
I'm using a Remote connection over TCP.
I have tried it on both ADS 10.10 and 11.10, but they give the same result ...
One of the issues is that the disconnect method itself generates an Access Violation (using ADS 10.10 components in Delphi),
the other problem occurs when our application is closed in an unexpected way (like an unexpected error,...). This causes the connection to remain open, even after the configured timeout period.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.