Skip to Content
0

Advantage Database Server Data Dictionary connection not closed

Mar 09, 2017 at 11:12 AM

196

avatar image

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?

10 |10000 characters needed characters left characters exceeded

Thomas,

Could you provide a few more details of your environment?

What programming interface are you using?

Are you using Local Server or Remote?

TCP or UDP?

Are any errors being generated when the disconnect fails?

You mention ADS 10.10/11.10. Are you actively using both of these versions?

Thanks,

Mike Loop
Senior Support Engineer
SAP Product Support

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Thomas Hens Apr 03, 2017 at 07:24 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Michael Loop
Apr 03, 2017 at 12:32 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded