Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 7 of 7 total
Thread Data not showing (Using app that shares files from a folder)
Fri, Jul 19 2013 1:46 PMPermanent Link

kamran

Hi

I have an app that runs on 3 machines

1. server = Vista 64 bit O/S where that data is stored on a shared folder eg c:\appdata
2. ws1 =  Vista 64 bit O/S
3. ws2 = Windows 7 64 bit O/S

From time to time I am not seeing the data from the tables
eg in grids or edits. This happens to random files and at random times.

The data is clearly on the server but loses itself randomly on the workstations?

I have disabled the write cache on the hard drives but that does not seem to help.
Is there an issue somewhere with setup / dbisam itself ?
I do recall that it was running ok before .. but something has changed. I regularly
move onto the latest dbisam versions and am currently on 4.34 but software on site might still be using a slightly
lower version.

Any ideas ?

Regards

Kamran
Sun, Jul 21 2013 2:43 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kamran,

<< I have an app that runs on 3 machines

1. server = Vista 64 bit O/S where that data is stored on a shared folder
eg c:\appdata
2. ws1 =  Vista 64 bit O/S
3. ws2 = Windows 7 64 bit O/S

From time to time I am not seeing the data from the tables eg in grids or
edits. This happens to random files and at random times. >>

What do you mean by you're not "seeing the data" ?  Are the workstations
refreshing in order to see any changes made by other users ?  Unless you
explicitly refresh a table/live query result, you're not necessarily going
to see changes by other users immediately.

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Change_Detection

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Jul 22 2013 5:56 AMPermanent Link

kamran

Hi Tim

Thanks for response.
I will look  into what you suggested.
Funny thing is it never used to happen and seems to be a new occurrence.
The system has been in for some time.

Let me explain.

If I  fire up a client  and go to the page where i have defined a grid linked to data table
there would be no rows showing ?

I go back to the server and the data is definitely there.

So why is the data not showing up in the grid.
The file is open and should show straight away as it does on the server machine !

Thanks

Kamran





"Tim Young [Elevate Software]" wrote:

Kamran,

<< I have an app that runs on 3 machines

1. server = Vista 64 bit O/S where that data is stored on a shared folder
eg c:\appdata
2. ws1 =  Vista 64 bit O/S
3. ws2 = Windows 7 64 bit O/S

From time to time I am not seeing the data from the tables eg in grids or
edits. This happens to random files and at random times. >>

What do you mean by you're not "seeing the data" ?  Are the workstations
refreshing in order to see any changes made by other users ?  Unless you
explicitly refresh a table/live query result, you're not necessarily going
to see changes by other users immediately.

http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Change_Detection

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Jul 22 2013 8:44 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

kamran


Has the program been recompiled or changed in anyway recently? What you describe sounds as though the grid isn't connected to the data and Delphi has been known to remove the links.

Also do you anywhere in the program disable the grid, DisableControls on the table or break the links yourself?

Finally, if when the data isn't seen what happens if you open DBSys on the client and try to view the data?

Roy Lambert [Team Elevate]
Mon, Jul 22 2013 9:26 AMPermanent Link

kamran

Hi Roy

The data shows on the client after coming out of the application and going back in.

Later on it might not show..... how odd.

It gives the impression that the whole data file is empty;

I have checked that data is not being disabled

I will have to look into it further to isolate it;

Thanks


Roy Lambert wrote:

kamran


Has the program been recompiled or changed in anyway recently? What you describe sounds as though the grid isn't connected to the data and Delphi has been known to remove the links.

Also do you anywhere in the program disable the grid, DisableControls on the table or break the links yourself?

Finally, if when the data isn't seen what happens if you open DBSys on the client and try to view the data?

Roy Lambert [Team Elevate]
Mon, Jul 22 2013 10:07 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

kamran

From your other post I see you're thinking of going over to c/s.

I never had anything like this in years of using DBISAM in f/s mode with several clients. It may have something to do with the mix and the versions.

I had a couple of thoughts:

1. add a timer onto the form and if the table(s) aren't in edit mode refresh every 5 seconds.

2. If there's space on the form display the table(s) RecordCount - that would at least give a clue as to wether the table just wasn't being displayed or was disappearing into the ether.

Has there been any corruption in the table(s). I'm wondering if there's a weird problem with the network.

Roy Lambert [Team Elevate]
Tue, Jul 23 2013 9:32 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Kamran,

<< If I  fire up a client  and go to the page where i have defined a grid
linked to data table there would be no rows showing ? >>

And the rows were added prior to the application being launched, or just
prior to the form with the grid being shown ?

If it is the first situation, then you could very well be looking at an SMB2
bug, in which case the only solution is to a) apply a hotfix from MS, b)
modify the registry on each client, or c) move to using DBISAM C/S with the
DBISAM Database Server.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com
Image