Kbase P23007: Date mismatch errors: prostrct unlock and prostrct repair do
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/25/2009 |
|
Status: Unverified
SYMPTOM(s):
Prostrct unlock and prostrct repair do not work.
Proutil dbname -C truncate bi -F is not able to force into db.
Database is damaged, see documentation. (1486)
** The database was last used <date/time>. (886)
** The before-image file expected <date/time>. (887)
** Those dates don't match, so you have the wrong copy of one of them. (888)
bkOpenControlArea error. (7104)
CAUSE:
Online OS-copy of database. No prostrct repair was done afterwards on the new db, thus its db-file still pointed to the .d and bi-file of the old db.
FIX:
1. prostrct list <dbname>
2. Delete the .db file
3. prostrct builddb <dbname>
4. proutil <dbname> -C truncate -F
Please refer to Progress Solution P24330 for further details on the consequences of using -F.
5. Dump of all tables, users and sequences
6. Create new database
7. Load contents
or
restore db from backup.