Hi ya'll,
I have a similar problem to moshen_fakhari: I get an error 88 when I
reindex my 2000i files in 9.5. The file (archive.btr) happens to be
the first one alphabetically, but I m not sure if it is relevant here.
When I go into maintenanmce to recreate the file (for a possible data
import) I get an error 172, which states that the database name cannot
be found. The only other file I get an error on (out of 70 files) is
Attrib.ddf where I get an 88 on rebuild.
Even though the archive.btr table is listed in the DSN, i get the same
error whenever (172) whenever I try to open it with the maintenance
utility or the function executor, but it opens up fine in PCC...
Any ideas out there?

It sounds like the table has an RI constraint, or is otherwise
associated with a named database. Be sure the database name used on
the new system is the SAME as that used on the old server.

Using the PCC on the PSQL2000i system, right-click the DSN and select
properties to see the Named Database name. This may be different than
your DSN name. Then, use the SAME name on the new server.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 07/2007 ***


caterpillar wrote:

Send me a copy of the file, and I can pull out the DBName, if any.
There's no easy way to do this now, and it requires running three
distinct custom-built tools, but it can be done.

I think I will also work on a tool to automate this, in case it
happenes more in the future.
Goldstar Software Inc.
Pervasive-based Products, Training & Services
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 07/2007 ***


caterpillar wrote:

Hi Bill,
Thanks for the reply!!
Here is a snippet of the log file when I am rebuilding:


The rebuild operation start time is 06/08/07 09:50:31.
rbldcli -c -s -f95 C:\UV\Run\Film.btr

REBUILD-20: The utility is processing C:\UV\Run\Film.btr.
REBUILD rejected a total of 0 records.
REBUILD copied a total of 5779 records.
REBUILD rebuilt a total of 13 indexes.
The rebuild operation end time is 06/08/07 09:50:35.
The file was rebuilt successfully.

The rebuild operation start time is 06/08/07 09:50:35.
rbldcli -c -s -f95 C:\UV\Run\Filmback.btr

REBUILD-20: The utility is processing C:\UV\Run\Filmback.btr.
REBUILD-7: The utility could not open C:\UV\Run\Filmback.btr. The
MicroKernel Database Engine status code was 172.
The rebuild operation end time is 06/08/07 09:50:35.

Everything proceeds nicely for most files as seen in film.btr, then I
get a dialog asking for a user and password - that I have to cancel,
resulting in the error 172 - ONLY on certain files as seen in
filmback.btr. It does indeed seem as if these files are associated
with a named database, but I cant for the life of me figure out WHICH
named database that would be. I looked in the 2000i PCC - as you
suggested - and I could find nothing that would distinguish these
handfull of files with the 172 error from the rest of them which
rebuild without any error.

Is there any way to strip the named database info from these files?
Version 2000i doesnt seem to care about them, where 9.5 basically
tells me to log in or forget about 9.5!!!

Many thanks as always... -Bill Roman



On Thu, 31 May 2007 06:58:18 -0500, "Bill Bach"
<goldstar (AT) speakeasy (DOT) net> wrote:

Hi Bill,
I just thought I'd let you know the solution to this issue. As a beta
tester of v10, i got the opportunity to submit this as a conversion
bug.
The answer is - and this will only work whilst running 20001 - is to
use BUTIL -CLONE to make an empty cloned file, then use BUTIL -COPYT
to populate the data delete the old one and rename the new one, and
the DBName is gone) Try doing that in 9.5 or 10 and you just get the
172 error.
So, all fixed, and thanks for your part in kicking me in the right
direction!!!
-Bill Roman




On Fri, 08 Jun 2007 10:19:31 -0500, "Bill Bach"
<goldstar (AT) speakeasy (DOT) net> wrote: