Pervasive 2000i server/workstation engine conflict

[smeyer56]

I am having a problem with Pervasive 2000i. We are using the server engine on the server and normally using the client on the workstations. We have the workstation engines on the workstations for times when the server/network is down. 99% of the time this works fine, but when a network connection is lost(1 register today) the workstation engine starts. If the network comes back up and the workstation connects to the server again the workstation engine is still running. These two engines conflict and the server engine locks up giving an error 3014 and everyone on the server engine is kicked out of our application.

Does anyone else have this problem?
What do you do about it?

 

[mirtheil]

Where is the data that is being accessed by the workstation engine wehn the network/server is down? Is it on the local machine? The way the Pervasive engine works, if it can't connect to a server engine, the local engine takes over and tries to open the file. If the server is up and Pervasive can connect to it, the workstation engine shouldn't be opening the files.
My suggestion, besides looking into the network problems, would be to make sure that when the network comes back up, that the application and workstation engine are shutdown and restarted.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[smeyer56]

It seems that they are bumped from Pervasive somehow and the workstation engine then reconnects to the server data.The problem with shutting down the application and workstation is that the users don't see whether the network is back up or not or even if it's down.

I am not sure whether the network is going down or not because it only seems to happen at one workstation at a time. The only way I can tell is that the user gets and error in the application, shuts the application down and restarts it after x time, all users get errors and cannot log in to the application until I find the Workstation that has the workstation running on it, shut down the workstation engine and then shutdown and restart the Pervasive engines.

Shouldn't the workstation engine shutdown and close when it finds the server engine again?

 

[mirtheil]

Shouldn't the workstation engine shutdown and close when it finds the server engine again?

No. The Workstation engine doesn't know about the Server Engine.

Are there any errors in the PVSW.LOG (both at the client and the server)?


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[smeyer56]

Client:
3111: Status 10054 returned while sending 88 bytes.
3131: Reconnect not attempted, AutoReconnect not enabled on either client or server.

Server: Nothing of interest

 

[mirtheil]

So the client is losing connection. You might try enabling AutoReconnect. It might slow down performance a bit but it might also keep the Workstation engine from loading the file.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
Custom VB and Btrieve development.

http://www.mirtheil.com

 

[smeyer56]

I will set that up as soon as I can find the time to restart the engines.

Thanks