Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 5 of 5 total
Thread Errors and errors in one place we have DBISAM application
Tue, Mar 25 2008 7:02 AMPermanent Link

Durumdara
Hi!

We have a "Sword of Damocles" with our application that working good in 160 place.
But in 161. place we get problems continously.

We has a DBISAM server in W2k in this place, and we got mysterious errors by the users.

1.)
Many times when they refreshed their data records, they the modifications are wasn't visible.

2.)
They got interesting applicaton freezes.

3.)
One user who only uses the app got 8708 error (record changed or deleted by another user).

Then we asked the sysadmin to change server mode to normal windows share mode to check it.

Last errors we got from these users is same: error 8708, and lost/not visible record values.

We have no idea what we can do...

This is a Sword of Damocles, and we haven't got any idea what to do now, but the corp is
impatient now.

The source of the error is possible any thing: the network, the client machines, the
client oss, the client settings... etc.

Do you have any idea where can start our "tour" to solve this problem?

Thanks for your help:
  dd
Tue, Mar 25 2008 9:45 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Durumdara


8708 is not really an error, just a notification that someone else has changed the record. It can be found even on a single user system where there are multiple cursors opened on a table. The only time to "worry" about it is on a single user system with only one user, where each table is only opened once and there are no threads.

As to the rest - first some questions

1. Have you modified the DBISAM server at all
2. Do you use pessimistic or opportunistic locking
3. Do you use flushbuffers
4. What av software is in place - is this being used at other sites
5. Are records serialised so you could spot a gap to see if missing records really are

Since its working in 160 places I suggest you suspect

a) the hardware - especially network hardware, and especially with network freezes
b) other peoples software especially av
c) the users
d) your software

If you look through these ng's you'll often find these sort of problems seem to disappear when network hardware is sorted

Think about adding MadExcept into the app for this site and set it to trap application freezes

Roy Lambert
Tue, Mar 25 2008 1:48 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Durumdara,

<< We have a "Sword of Damocles" with our application that working good in
160 place. But in 161. place we get problems continously.

We has a DBISAM server in W2k in this place, and we got mysterious errors
by the users. >>

Is there anything strikingly different about this installation, such as the
number of users, the OS used for the server, the type of server machine,
etc. ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Mon, Mar 31 2008 4:47 AMPermanent Link

Durumdara
Dear Tim, and repliers!

In the last week we visited the corp I said about it.
We fully changed the access to shared folders, because the system admin not completed this
operation previously.

In this period they are not sent any error report.

Possible the server (hardware/software) caused the problems.

They will buy a better server machine and in the next week we will try it again to working
in server mode.
Then I will report the results to you!

Thanks for your help, and sorry for miswroted informations - the users said about older
state errors, and we believed they are said about the actual state.

dd
Mon, Mar 31 2008 4:00 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Durumdara,

<< In the last week we visited the corp I said about it.
We fully changed the access to shared folders, because the system admin not
completed this operation previously.

In this period they are not sent any error report.

Possible the server (hardware/software) caused the problems.

They will buy a better server machine and in the next week we will try it
again to working in server mode. Then I will report the results to you! >>

Thanks, that would be great.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image