Consultor Eletrônico

Status: Verified

FACT(s) (Environment):

Progress 9.x

SYMPTOM(s):

Error 598 when starting database

<file-name> is a copy of <file-name>. Database cannot be opened. (598)

Database is a copy created by OS utilities.

CAUSE:

Within the .db file there are pointers to the various locations of the database files. When a database is copied with OS utilities, these pointers are not updated. So when the copy database is being started, the pointers still reference the old location, and this situation is interpreted as the database being a copy. The db file must be reset to reference the new location.

FIX:

Update the structure file for the copy database and run prostrct repair.

Example using sports, tested with 9.1D06 on Windows 2000 -

1. prodb test sports
Database copied from c:\progress\prg91d\sports. (1365)

2. This is created initially as a relative path database, so in order to change it to an absolute path database the st file must be updated and a prostrct repair done.

2.1 The following st file (test.st) was used with the prostrct repair:

#
b C:\prgswrk\Test\test.b1
#
d "Schema Area":6,32 C:\prgswrk\Test\test.d1
#
d "Info Area":7,32 C:\prgswrk\Test\test_7.d1
#
d "Order Area":8,32 C:\prgswrk\Test\test_8.d1

2.2 prostrct repair C:\prgswrk\Test\test test.st

3. The database is then copied into another directory (C:\prgswrk\Copy)using os utilities.

4. Trying to proserve this copy results in a 598 error:

C:\prgswrk\Copy\test.db is a copy of C:\prgswrk\Test\test.db. Database cannot be opened. (598)

5. So a prostrct repair needs to be done on the copied database -

5.1 The st file (copy.st) is updated for the copy of the database:

#
b C:\prgswrk\Copy\test.b1
#
d "Schema Area":6,32 C:\prgswrk\Copy\test.d1
#
d "Info Area":7,32 C:\prgswrk\Copy\test_7.d1
#
d "Order Area":8,32 C:\prgswrk\Copy\test_8.d1

5.2 prostrct repair C:\prgswrk\Copy\test copy.st

The database can now be accessed ok.