This is a tough one to explain properly. My client is running my solution on their network where they are using Microsoft’s Remote Desktop Connection (they formerly used Citrix). Prior to Servoy 2.2.1rc1, I made a post about how they were being disconnected after a short period of idleness and was assured that 2.2.1rc1 would fix that. Because of the incompatiblilty of rc1 and Java 1.4, I had to wait for rc2 to find out that it did not fix this problem. I continue to get these errors from the server log:
2005-08-29 14:42 : Error flushing message buffer to client eda132e6-18c1-11da-9537-b7eee9f90f0c, Connection refused to host: 192.33.4.22; nested exception is: java.net.ConnectException: Connection refused: connect
I am also getting several different errors all with the description of “Error unmarshaling return header” (see attachment).
I don’t know if they are still being disconnected because they are now reporting a much larger problem. Users are saying that text is disappearing from the fields they are editing, often as they are typing it in, but it occurs very sporadically. Through troubleshooting, I have come up with a possible cause. Lets say user 1 is logged in from Server1 and is editing any record in any table. As soon as user 2, also using Server1, launches the solution or leaves the solution, whatever user 1 is editing disappears. The text disappearance is always accompanied by the little blue dot appearing in the status bar that indicates “Data change by other user.” Once user 2 has launched the solution, both users can edit records without any other problems. The blue dot appears occasionally but text does not disappear. The disappearing text seems to be occuring only when another user launches or leaves the solution.
I thought that at some point Servoy was going to be able to discern individual users in an RDC or Citrix environment and not simply identify a client by its IP address. When I look at the list of currently logged-in clients, I see several “Server 1 (192.33.4.22)” and several “Server2 (192.33.4.23)” clients, all with different login times and such. Is it possible that Servoy can’t tell the difference between users using the same RDC server and therefore is unable to properly save data back to the tables? I am at a loss for what to tell my client and they are mad.
Using:
Servoy: 2.2.1rc2
Client OS: Windows 2000 SP4
Backend: MS SQL Server 2000
Do you lock records to prevent users from editting the same record?
Do you have calcs doing things like clearing another field? (never change other fields inside a calc)
The errors you see in the log are networks disconnects log statements, is there something strange with your network?
one other question. those remote desktop machines
are they in the same network as the servoy server where the solutions runs on?
Or is it so that a client comes from where ever connects to a network with remote desktop and then goes again to another network connecting to the servoy server.
To answer the first post, my solution does not do anything to prevent users from editing the same record. I do not have any calcs that clear other fields.
To answer the second post, there are some users who log into the RDP server from home and there are other users who log into the RDP server from other plants, but the only way they are able to launch the Servoy client is via their Remote Desktops, of which all of them are on the same network as the Servoy server. So as far as I understand, a client comes from where ever, connects to a network with remote desktop and is then on the SAME network as the Servoy server.
This is not related, but why do the clients have to access the server via remote desktop, especially if they are on the same network, or any network for that matter.
Erich
My client is a company that has hundreds of users spread out across several locations along the west coast as well as several home users. In an effort to minimize the expense of software licenses and also to reduce and centrally locate hardware, they have chosen to use a remote desktop environment. They used to use Citrix, but have now switched to Microsoft Remote Desktop.
As I stated in my last post, many users are not physically located on the same network, but are virtually on the same network when using Servoy since the remote desktop servers are all located on the same LAN as the Servoy server.
According to the Remote Desktop Overview section of the Windows XP Professional Help file:
When you connect to your computer at work, Remote Desktop automatically locks that computer so no one else can access your applications and files while you are gone.
It sounds like your customer is not using Remote Desktop for its intended purpose.
My client is using Remote Desktop correctly and for valid reasons. The computers on user’s desks are basically just terminals for connecting to the RDP servers, where all the applications are installed. Telling my client that they should stop using Remote Desktop to solve this problem means an investment on their part of several hundreds of thousands of dollars. Plus, they will no doubt mention that this problem never happened when the solution ran in its previous FileMaker version (uh oh, he used the F word). I have faith that a better solution will soon be found.