MessageHi Colin,
For what its worth I had a database that I was not able complete "The Big
Clean". I can't remember at exactly which point, it was either the exporting
or importing of the TLog, and DP would crash with an error... So between 1992
and earlier this year (when it is was replaced as the primary production
system, but still inoccasional use) it never had TBC and over that 16 years
only had about 3 reindexes(when there was a dodgy version of a Netware client
in use). and despite being in absolutely constant use with about a dozen or so
users and having well over a million records, it never really had a glitch. So
although I was curious why I took the attitude about the Big Clean that if it
aint broke don't fix it...
Regards
Brian
----- Original Message -----
From: Colin Roberts
To: Dataperfect Users Discussion Group
Sent: Friday, April 18, 2008 8:07 AM
Subject: Re: [Dataperf] A small problem with "The Big Clean"
Hi Jon,
Thanks for your input, but its halting prior to the start of the tran log
import - see below
Just an update on the problem child database. I have started afresh (3x now)
:-( by re-constructing it by taking a copy of the main database and
re-configuring it. Basically the three databases start out identical and then
the two derivitaves have the 1st 3 panels configured differently for different
usage,(edit order, links etc and the data from the old derivatives is imported
into the new once they are reconfigured.
In the problem DB (ironically the simplest of all 3) the 1st two panels don't
get used at all (no data). After 3 attempts with the same result I have just
carried out a big clean on a copy of the main database in case my DPexp//DPimp
files had a problem. It worked flawlessly. Obviously it doesn't like my
re-config this time on this database for some reason - perhaps a link to
nowhere or something like that that I have overlooked in the re-config.
Although the DB appears to function fine I'm thinking that if I can't complete
TBC there's a "gotcha" lurking in there somewhere. Did notice that with a
successful Big Clean on the other DB that the data files don't re-appear in the
directory until the transaction log import is completed (apart from the
original entry panel) The Please Wait message appears immediately after the
index file is recreated before the transaction log is accessed to start the
import. So if you ignore the "please wait" message and start the import only
the entry panel gets populated by the import and the other panels never appear
in the directory unless you access them from the panel list, but then of course
they remain empty, and you cannot populate them by trying to import the
translog again. So I've screwed up somewhere in the config :-(
I'll keep a looking.
Colin
----- Original Message -----
From: Jong
To: 'Dataperfect Users Discussion Group'
Sent: Wednesday, 16 April 2008 14:40
Subject: RE: [Dataperf] A small problem with "The Big Clean"
Colin
FWIW, I haven't seen that but try:
1. scandisk on HDD
2. dpexp, dpimp on *.str.
3. check beginning of each panel file for corrupted records with blanks or
something that causes import to freeze, delete them.
You probablly already did this but incase you didn't!
Best wishes,
Jon
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin
Roberts
Sent: Tuesday, April 15, 2008 5:35 PM
To: Dataperfect Users Discussion Group
Subject: [Dataperf] A small problem with "The Big Clean"
Hi All,
Anyone struck this problem or similar with The Big Clean (TBC)?
Dp26x - Three databases - 2 are derivatives of the main one. Have
recently completed TBC (as per Ralph's Book) on the main database and one of
the derivatives without a problem. The 2nd derivative database is not
completing the big clean as follows
42 panels
Create transaction log - Log looks fine
Delete all data files leaving translog and *str file in directory. Carry
out dpexp/dpimp
Re-enter database and re-create ind & txx files - everything appears fine
till this point, but after those two files are created (both of which appear in
the directory (can be seen in explorer window) the panel entered file is also
created and then a "Please wait" message appears at top of the panel, and the
process comes to a complete stop. No further panel files get created. (Please
wait message stays but there is no CPU or HD activity) With the please wait
message showing (bearing in mind that there is a bug in 26x that allows panel
header messages from other panels to show thru to the top layer panel) you can
move from field to field within that panel. If you exit that panel and enter
the next panel via the panel list then the file, for that new panel entered,
appears to be created and the file appears in the explorer window. You can
exit each panel in turn and enter the next one and each new panel file appears
to be created each time as the panel is entered. But when all files are finally
present, importing the transation log only seems to populate the 1st panel
created after the ind & txx files were created.
This database was & is actually working fine and I can continue working
with it on a backup copy without problems. But just curious why I'm getting
these issues. The Main Database was getting 103 and subsequent 121 errors some
times when editing variable length text fields and TBC sorted it just fine.
Thought I'd do TBC to the couple of derivaties just as a maintenace thing -
neither were having any issues. One also completed fine but as above one has
turned into a problem child - The two databases that completed TBC re-created
all the panel files automatically with the txx and ind files on entering the
database.
Any ideas??
Regards
Colin Roberts
--------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
----------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
------------------------------------------------------------------------------
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
