Kbase P3479: Error 598 trying to start database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/09/2008 |
|
Status: Verified
SYMPTOM(s):
Error 598 trying to start database
<file-name> is a copy of <file-name>. Database cannot be opened. (598)
FACT(s) (Environment):
Database is a copy created by OS utilities
Progress 9.x
All Supported Operating Systems
OpenEdge 10.x
CAUSE:
The .db file contains pointers to the locations of the database extents. When a database is copied with an OS utility, these pointers are not updated. 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.
Sometimes for backups and for testing, it can be quicker to make a copy of the database with system. The .st file has to be updated first of all to reflect the new location for this copy of the database.
The following test illustrates the Cause:
1. procopy $DLC/sports2000 sports2000
Because procopy was used, sports is an absolute path db.
2. prostrct list sports2000
3. mkdir copy
4. cp sports2000.* copy
5. cd copy
6. pro sports2000 returns:
<file-name> is a copy of <file-name>. Database cannot be opened. (598)
FIX:
To resolve the problem perform the following steps:
1. Edit the .st in the copy directory to reflect the new location of the database extents.
Pay high attention to ensure that ALL the lines in the structure file are changed.
2. Run the prostrct repair command against the copied database
Syntax> prostrct repair dbname
The database can now be accessed without problems.
Shut down the database before performing any backups using OS utilities. Probkup online is the only supported online backup.