Database Restore issue OpenEdge 10.2b

B

bmoffet

New Member
I have downloaded and installed 10.2b and when I run prorest skyward skyward.bk I get the following output:
syntax error in structure file: d "000":643060564,1;1
Invalid area number specified. (6826)
Error occurred on line 3. (6819)
!!! Error - database restore utility failed !!! (8564).
Does this indicate that I have corruption in the backup file or that I need to use 10.1B?

The hosting provider mentioned that this database was exported from 10.1B. Unfortunately the evaluation version available on Progress's site is 10.2b.

Any help would be greatly appreciated.
 
With what version did you take the backup?

When it comes to the structure description the rules are as follows:
  • First and foremost: Always have a valid backup of your structure description file at hand. It does not get backed up automatically. You must do your own backup. Chances are you will need it when you lose the file system where your database resides to restore the database with the same extents in the same location as the backup was taken from.
  • If you do a restore and the utility finds a structure description (.st) file in the restore directory it will use it. Obviously the existing st. file must be syntactically correct and should be actual. To use it successfully for a restore it must also contain the same storage areas ( name-wise ) as the backup. Best case scenario: You restore the .st file from a backup in the first place ( see above ).
  • If the restore utility does not find a .st file in the restore directory it will automatically generate one but all extents of all storage areas will reside in the restore directory - which might not be feasible ( see above ).
Regarding the error you got: I don't know what the maximum number is that can be used for a storage area (the would be the number after the colon - 643060564 ), but I never saw such a big number for a storage area and IMHO there is no use case I can think of where it would make sense. At the end I think the number is too big.

To give you a more detailed advise you should post you structure description.

Heavy Regards, RealHeavyDude.
 
You must log in or register to reply here.
Back
Top