Programming with dBASE - database engine error

Author

database engine error

Nico Oudshoorn

2005-05-12, 7:23 am

I have an application where the client can input his payments. So he does.
After finishing the input of his payments he can start an application to
check these input and if the checking is ok he can officially book those
payments in the booking table. During the booking the booking-application
gives an error on the table in which the payments have to be booked (the
booking table). The error is: database engine error: read failure and the
name of the booking program and the name of the table involved (the booking
table).

After booking a payment the payment in the payment-table is filled with the
date of the booking.

When I check the booking table in the IDE then the table gives no problems,
only 5 payments have been booked and the sixth booking in the booking tabel
is there with ony the first field filled. In the payment table there already
27 payments that have the indication that they have been booked??? And there
are still 80 payments to book.

The booking table has more than 180.000 records at this moment and several
indexes (mdx).

I am working with XP-Home en dbase plus 2.21.

The settings in my application config are:
& #91;CommandSettings]

EDITOR=
PATH=
ALTERNATE=
SEPARATOR=.
POINT=,
CURRENCY="? "
DATE=DMY
MARK=-
REFRESH=0
REPROCESS=0
DBTYPE=DBASE
IBLOCK=1
MBLOCK=8
TYPEAHEAD=49
BELL=512,50
EPOCH=1950
DECIMALS=2
PRECISION=10
MARGIN=0

[OLEViewer]
StoreAsOLE2=1

& #91;OnOffCommandSett
ings]
CURRENCY=LEFT
CENTURY=ON
LDCHECK=OFF
LOCK=ON
EXCLUSIVE=OFF
AUTONULLFIELDS=OFF
AUTOSAVE=OFF
DELETED=ON
EXACT=OFF
NEAR=OFF
ENCRYPTION=OFF
CONFIRM=ON
CUAENTER=ON
ESCAPE=ON
BELL=ON
FULLPATH=OFF
SPACE=ON
COVERAGE=OFF
DEVELOPMENT=ON
DESIGN=ON
SAFETY=ON
TALK=OFF
TITLE=OFF
HEADINGS=ON

[ErrorHandling]
ErrorAction=4
ErrorLogFile=PLUSErr
.log
ErrorLogMaxSize=100
ErrorHtmFile=error.htm

I hope there is a solution, Nico Oudshoorn.

*Lysander*

2005-05-12, 7:23 am

In article <jGf1P#tVFHA.444@news-server>, noudshoorn@scarlet.nl says...

> The booking table has more than 180.000 records at this moment and severa=
l=20
> indexes (mdx).
>=20
> I am working with XP-Home en dbase plus 2.21.

Clean up the tables (pack).

Try to recreate your indexes
- copy stru to temp,
- there drop and make new indexes
- then append to this table from old table
- then copy the complete temp table with production to the old table=20
with the old name.

~~~

Does this help?

~~~

Do you have Service pack 2??
I hear _a LOT_ of crying about SP2 and BDE. MS changed something about=20
the OPLocks, and that leads to damaged indexes in several cases.

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
European dBase-conference dBKonEurope :::: C A N C E L L E D ::::
English spoken conference around different database-topics

Nico Oudshoorn

2005-05-12, 9:23 am

Thanks for your suggestion. That is what I already did.

Nico.
"*Lysander*" <nobody@nowhere.com> schreef in bericht
news:MPG. 1ced546eb0fc2f359897
74@news.dbase.com...
In article <jGf1P#tVFHA.444@news-server>, noudshoorn@scarlet.nl says...

> The booking table has more than 180.000 records at this moment and several
> indexes (mdx).
>
> I am working with XP-Home en dbase plus 2.21.

Clean up the tables (pack).

Try to recreate your indexes
- copy stru to temp,
- there drop and make new indexes
- then append to this table from old table
- then copy the complete temp table with production to the old table
with the old name.

~~~

Does this help?

~~~

Do you have Service pack 2??
I hear _a LOT_ of crying about SP2 and BDE. MS changed something about
the OPLocks, and that leads to damaged indexes in several cases.

--
ciao,
André
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
European dBase-conference dBKonEurope :::: C A N C E L L E D ::::
English spoken conference around different database-topics

*Lysander*

2005-05-12, 11:23 am

In article <GymzmUvVFHA.320@news-server>, noudshoorn@scarlet.nl says...
> Thanks for your suggestion. That is what I already did.

Does it happen on several computers, or only on one?

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
European dBase-conference dBKonEurope :::: C A N C E L L E D ::::
English spoken conference around different database-topics

Nico Oudshoorn

2005-05-13, 7:23 am

That is interesting. Its a network with two computers. The server was W98
and the client W-XP-home. On the server I had the same problem and on the
client it runs without any problem. Therefore we changed the computers
because we wanted to run this application stand alone on the server. But we
did too was upgrade the client with XP. And now we have the same problem on
the W-XP-home computer (now the server) on which before, when this computer
was the clinet, where no problems.

Hope it helps, Nico Oudshoorn.
"*Lysander*" <nobody@nowhere.com> schreef in bericht
news:MPG. 1ced8b6c279aa9439897
75@news.dbase.com...
In article <GymzmUvVFHA.320@news-server>, noudshoorn@scarlet.nl says...
> Thanks for your suggestion. That is what I already did.

Does it happen on several computers, or only on one?

--
ciao,
André
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
European dBase-conference dBKonEurope :::: C A N C E L L E D ::::
English spoken conference around different database-topics

*Lysander*

2005-05-13, 9:23 am

In article <TzAA3T6VFHA.1188@news-server>, noudshoorn@scarlet.nl says...
> did too was upgrade the client with XP. And now we have the same=20
problem on=20

> the W-XP-home computer (now the server) on which before, when this comput=
er=20

> was the clinet, where no problems.

So, no problems on the W98-machine?
Peer-to-Peer-network: did you turn on LOCALSHARE=3DTRUE in BOTH BDEs?

Is the XP-machine with Service-Pack 2?

--=20
ciao,
Andr=E9
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
European dBase-conference dBKonEurope :::: C A N C E L L E D ::::
English spoken conference around different database-topics

Nico Oudshoorn

2005-05-14, 11:23 am

Yes the problem was on the W98 machine. But we upgraded this machine to
W-XP. The other machine was already W-XP and on this machien it did run
without problems. After upgrading the W-98 machine it didn't run on the
first W-XP machiine as well.

I found that on both machines local share was false. I turned that to true.
And SP2 wasn't installed on the first machine. I also set autosave to true.
The first run I did after that didnt give any problems, but because I did so
many changes I don't know waht the real solution is.

Nico.
"*Lysander*" <nobody@nowhere.com> schreef in bericht
news:MPG. 1ceec6acd7bde1999897
77@news.dbase.com...
In article <TzAA3T6VFHA.1188@news-server>, noudshoorn@scarlet.nl says...
> did too was upgrade the client with XP. And now we have the same
problem on
> the W-XP-home computer (now the server) on which before, when this
> computer
> was the clinet, where no problems.

So, no problems on the W98-machine?
Peer-to-Peer-network: did you turn on LOCALSHARE=TRUE in BOTH BDEs?

Is the XP-machine with Service-Pack 2?

--
ciao,
André
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~
European dBase-conference dBKonEurope :::: C A N C E L L E D ::::
English spoken conference around different database-topics

*Lysander*

2005-05-15, 7:23 am

Nico Oudshoorn schrieb:

> The first run I did after that didnt give any problems, but because I did so
> many changes I don't know waht the real solution is.

Ay!
I would give a good bet on the localshare-setting.

ciao,
André

Sponsored Links