QAD Progress Database Startup error resolved

1. Start times: SYSTEM Error:wrong Dbkey in block. Found 0, should is 6342528 in area 36.

(439) * * Save file named core for analysis by Progress software Corporation.

Cause: View the database. LG log file confirming that the database was not restored successfully (note:. lg File Box database file in the same directory

　　　

[2015/12/[email protected]:19:18.579+0800] P-31305 T-14415552 I: (12854) Restoring database from Xxxxxxxxxx.db.
[2015/12/[email protected]:22:01.085+0800] P-31305 T-14415552 I: (5057) Backup failed due to EOF during next output device request.
[2015/12/[email protected]:22:01.085+0800] P-31305 T-14415552 I: (1618) Restore failed.
[2015/12/[email protected]:22:01.085+0800] P-31305 T-14415552 I: (8564)!!! Error-database Restore Utility FAILED!!!
[2015/12/[email protected]:22:01.104+0800] P-31305 T-14415552 I: (334) Prorest session end.

2. When re-restore, the report

Start of extending target DB to needed size ... (9432)

Unable to extend before-image files enough to proceed. (6743)
Check for fixed length extents. (6744)
Restore failed. (1618)
!!! Error-database Restore Utility FAILED!!! (8564)

Found after the discovery is the source database bi file and two, and the target database bi file only one

3. Try adding BI:PROSTRCT add Mfgtrain mfgtrain-add.st to the target database

You must remove the variable length BI extent before adding
Additional BI extent (s). (8225)
PROSTRCT add FAILED. (12867)

Confirmation is not good plus, so you want to delete the source database bi, and then regenerate one, you can also free up a little space.

4. Regenerate bi with the following steps:

1) prostrct Remove Mfgprod bi execution, prompting Xxxxxxxxxxx.b2 to successfully delete

2) prostrct remove Mfgpord bi execution, prompting Xxxxxxxxxxx.b1 to successfully delete

3) Create Mfgprod-add.st. Content: B/QAD/QAD2010/DB/MFGPROD.B1

Execute PROSTRCT Add Mfgprod mfgprod-add.st

5. Backup Restore

Probkup Xxxxxxxxmfgprod Xxxxxmfgprod.bak Backup

Prorest Xxxxxxxxmfgdemo Xxxxxmfgprod.bak Restore

QAD Progress Database Startup error resolved