cancel
Showing results for 
Search instead for 
Did you mean: 

Advantage Database Server Data Dictionary connection not closed

0 Kudos

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?

michael_loop
Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

michael_loop
Contributor
0 Kudos

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

0 Kudos

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.