Re: Error 172 converting file from 2000i to 9.5

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@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxx> wrote:

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@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive Service & Support Class - 07/2007 ***


caterpillar wrote:

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?

.

Relevant Pages

  • Re: Error 172 converting file from 2000i to 9.5
    ... REBUILD copied a total of 5779 records. ... named database that would be. ... I looked in the 2000i PCC - as you ... different than your DSN name. ...
    (comp.databases.btrieve)
  • Re: Error 172 converting file from 2000i to 9.5
    ... Here is a snippet of the log file when I am rebuilding: ... REBUILD copied a total of 5779 records. ... named database that would be. ... Using the PCC on the PSQL2000i system, right-click the DSN and select ...
    (comp.databases.btrieve)