ADS data loss

[former_member231586]

I’m posting this on behalf of a one of our clients. He is concerned there is a bug in Advantage Database Server that could lead to loss of data.

They have about 18 software packages all running and accessing Advantage on the cloud.

The Terminal Server is 2012 R2

The Data Server is 2008 R2

The Advantage Database Server is 11.10.0.22

On Sunday the 12th, the administrator made a change to the network share Advantage was using to access the tables. He unshared the old drive ( 😧 ) and path then he shared the new drive ( G: ) and path both the new and the old share where the same name. Advantage was still running at the time the network share was changed.

After the network share change, Advantage was still opening and writing data to the old network share on ( 😧 ) and not the new network share on ( G: ). Advantage seemed to be unaware the share path had changed.

They ran for a week like this then on Saturday the 18^th the data server was restarted to another issue our tech support was having. On Monday the 20^th, it was determined that the data was reverted back to Thursday the 16^th, thereby missing Friday’s work. One of the software’s data was reverted back to Monday the 13^th.

It appears that the act of “downing” the server on Saturday the 19^th caused the data loss discovered on the 20^th as Advantage was now looking at a different place since the share names were changed on the 12^th. 

The client is thinking that the tables were being cached in the Advantage memory and didn’t have an opportunity to write the data to disk when the data server was downed.

Any help would be appreciated.

[HakanHaslaman]

How was the old and the new drive mapped, did you map to the UNC path or IP address?

Was the old and the new share used via Server-Side-Aliases? Are you able to reproduce this issue again and use now the ARC to verify, where the files will be open? If yes, please open a support incident, make some screenshots and provide more information about your environment and settings, so we can work on this issue directly.

[former_member231586]

Hi Hakan,

Thanks for your quick response.

The server’s local drives:

D:\XYZ

G:\XYZ

The network mapping:

T:  ->  \\Server1\XYZ

There are no Server-Side-Aliases.

I will not be able to reproduce this issue but, I did open a ticket.

Thanks

[HakanHaslaman]

Hi Richard,

In the first view, it looks for me an issue with the Discovery Process.

Are you using an ADS.ini with Lan_IP/Port? If not, I would recommend to use this, to avoid Netbios issues. You can also use the Server-Side-Aliases to point the Server the right place of the files. This will also help to avoid such like behavior of the Discovery Process.

[sungur1]

Hi Hakan,

Is ADS still supported and in Development? I‘m programming in Delphi and found an old ADS version. I‘m wondering, if can get a new Development version?

BR

S.A